Ms SQL Server

Hi All, Excellent opportunity for MS SQlDBA(3--8years) Hyderabad location Client : Mindtree Mode : Permanent position with Mindtree Exp – 3 to 8 yrs Notice – 0 to 30 days Work location - Hyderabad Interview Date :23-August-20(sunday) Interview mode:webex Discussion Please find the detailed Job Description - SQL DBA The person in this position will work in a team environment to support Customers using MS SQL Server. · 3-8 years of Microsoft SQL Server Database Administration experience in SQL Server 2008R2/2008/2012/2014/2016. · Installed SQL Server 2005/2008/2008R2/2012/2014/2016/2017 on new 32-bit and x64-bit Operating System. · Experience in Migrating from SQL Server 2008 to SQL Server 2012 and from SQL Server 2012 to SQL Server 2014/2016. · Experience in upgrading SQL server software to new versions and applying service packs and patches. · Proficient with SQL Management Studio, Enterprise Manager, Query Analyzer, rescheduling jobs with SQL Server. · Creating DB Maintenance plans, rebuild/reorganize indexes & performing integrity checks. · Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans. · Experience with High Availability and Disaster Recovery like Replication, Log shipping, Mirroring and Clustering. · Proficient in implementing different types of Replication models like Snapshot, Transactional and Merge. · Experience in Implementing Always On in SQL Server 2012, 2014, 2016 and 2017. · Experience in Implementing Database Mirroring in SQL server 2005/2008/2008R2. · Involved in Installing, Configuring and Maintaining of Cluster in SQL Server 2008R2 and SQL Server 2012 in Active/Passive. · Auditing database configuration and security configurations. · Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor, Windows performance monitor, DMVs, Resource Governor, Data collection Reports, crystal reports, DBCC and Custom Script, Built-in performance Report and Activity Monitor. · Experience with Database Backup and Restore. Key success factors include: Customer management and teaming skills, supporting customers on phone and written correspondence regarding technical questions and issues Logical and Critical thinking skills Deep technical and troubleshooting skills Passion for technology and learni Communicate efficiently both written and verbally with wide variety of the customers Subject of mail" Ms SQl Dba "Hyderabad If you know of people who would be a good fit and intersted please ask them to reach out to sveta@primusglobal.com

https://www.sqlfeathers.com/2020/07/install-and-configure-master-data.html?m=1 Install & Configure Master Data Services

Here are some of the SSIS Interview questions What is execute process task and when do u use that? How familiar are you writing scripts in SSIS? Did you use VB or C# for scripting? How do you bring the data from FTP server to database? Other than using  batch files did you use scripting to bring the data into data base? Pick one of the complex packages that you created and the lessons learnt from it? Tell some of the transformations that you are more familiar and used? What are different configuration types you used and explain them? Scenario 1 : I have data set from one server and another data set from another server and a flat file data set. There are no linked servers between the servers. How do you load the data from these 3 different servers into 1 data warehouse table? How do you monitor packages running on different servers in Microsoft BI? Like we have work flow monitor in Informatica Difference between script task and script component? How do you automate the package? What are the different ways you can deploy the SSIS package? How do you implement logging in SSIS? What are containers in SSIS? Difference between them? When do you use look-up ? What is full cache, partial and no cache? Did you use SCD component in SSIS? When do you use that? If you do not want to do type2 update but you have to update the records. How do you achieve this? Did you use CDC in SSIS? How do you unzip data using SSIS? Difference between multicast and conditional split? What are synchronous and asynchronous transformations? How do u improve performance in SSIS? You have to monitor which package is taking more time on the server? Where do you go and find out? What is the data viewer? Is it available in control flow or data flow? What are variables and when do you use them? What is the scope of the variable? Scenario 2: I have Fact table already created. I have to load the fact table. How do you create an ETL and what components you use and how do you follow inserts and updates? Scenario 3: I have 4 million customers coming into destination table, but i have to perform update only on few hundreds of customers. How do you achieve type 2 update without SCD concept? What is environment variable in SSIS? When do you use and How do you use that? What are the expressions? How and when do you use them? Can you move and rename the file at the same time in SSIS? If you can How?

SSIS developer @ Mphasis check the JD & Location and apply direcly on the links and share with others SSIS developer Loc : – Bangalore Exp : – 4+Years Notice period: below 30days prefer https://s.ripplehire.com/s/1HFu Please follow the link and submit your profile directly.

Watch "Encrypt View Or Procedure In SQL Server" on YouTube https://youtu.be/2Au69FqYsIE

Ask the Experts: Database Performance Roundtable https://www.quest.com/event/ask-the-experts-database-performance-roundtable8143216/?utm_source=sqlauthority_com_&utm_medium=Direct-3rd%20Party%20Vendor&utm_campaign=FY2021_Q2_AMER_asktheexperts_sqlauthority&utm_term=&utm_content=

The Many Flavours Of SQL - Towards Data Science https://towardsdatascience.com/the-many-flavours-of-sql-7b7da5d56c1e

Microsoft Power BI Masterclass™ – A Complete Hands-on Guide https://ift.tt/2Xfm12L via Real Discount

Basic Interview Tips @SQLFeathers What is the use of =,==,=== operators? = is used to assign one value or variable to another variable. == is used for comparing two strings or numbers. === is used to compare only string with the string and number with numbers. Where are SQL Server user names and passwords stored in SQL Server? User Names and Passwords are stored in sys.server_principals and sys.sql_logins. But passwords are not stored in normal text. What is the difference between GETDATE and SYSDATETIME? Both are same but GETDATE can give time till milliseconds and SYSDATETIME can give precision till nanoseconds. SYSDATE TIME is more accurate than GETDATE. What is CDC? CDC is abbreviated as Change Data Capture which is used to capture the data that has been changed recently. This feature is present in SQL Server 2008. What is SQL injection? SQL injection is an attack by malicious users in which malicious code can be inserted into strings that can be passed to an instance of SQL server for parsing and execution. All statements have to checked for vulnerabilities as it executes all syntactically valid queries that it receives. Even parameters can be manipulated by the skilled and experienced attackers. What are the methods used to protect against SQL injection attack? Following are the methods used to protect against SQL injection attack: 1.Use Parameters for Stored Procedures 2.Filtering input parameters 3.Use Parameter collection with Dynamic SQL 4.In like clause, user escape characters What is the difference between varchar and nvarchar types? Varchar and nvarchar are same but the only difference is that nvarhcar can be used to store Unicode characters for multiple languages and it also takes more (two bytes per character) space when compared with varchar. What are Magic Tables in SQL Server? Insert and Delete tables are created when the trigger is fired for any DML command. Those tables are called Magic Tables in SQL Server. These magic tables are used inside the triggers for data transaction. What are the differences between local and global temporary tables? 1.Local temporary tables are visible when there is a connection, and are deleted when the connection is closed. CREATE TABLE #<tablename> 2.Global temporary tables are visible to all users, and are deleted when the connection that created it is closed. CREATE TABLE ##<tablename> What is the difference between Cluster and Non cluster Index? A clustered index reorders the way records in the table are physically stored. There can be only one clustered index per table. It makes data retrieval faster. A non clustered index does not alter the way it was stored but creates a completely separate object within the table. As a result insert and update command will be faster. Explain the difference between DELETE , TRUNCATE and DROP commands? Once delete operation is performed, Commit and Rollback can be performed to retrieve data. Once the truncate statement is executed, Commit and Rollback statement cannot be performed. Where condition can be used along with delete statement but it can't be used with truncate statement. Drop command is used to drop the table or keys like primary,foreign from a table. #StayHome #StaySafe

SQL Feathers - Home https://m.facebook.com/SQL-Feathers-759279884263250/?ref=bookmarks

Beginning PowerBI - By Dan Clark☝️

SQL Feathers: Finding blocking/locking queries in SQL Server https://www.sqlfeathers.com/2020/04/finding-blockinglocking-queries-in-sql.html?m=1