Data Warehousing Concepts Interview Questions & Answers : This blog contains the Interview questions and answers from the Section Sql Server Data Warehousing Concepts . This blog contains 47 Frequently Asked Questions and Answers on Sql Server Data W...

This blog contains basic and important interview questions and answers from the SQL Server Version SQL Server 2008 Onwards. Total 67 Questions and Answers are included in this blog.It is a continuation series on the blog Interview Questions and Answe...

SQL SERVER – Interview Questions and Answers (Common Questions Asked): This blog contains the most common and important Interview Questions and Answers on SQL Server. This is a continuation blog in the SQL Server Interview Questions and Answers Ser...

SQL Server 2016- In-Memory OLTP – Row Structure and Indexes : There are several decisions to be made when designing indexes for Memory-optimized tables in In-Memory OLTP, and to make the best choice, it pays to understand something about the nature...

One of the most useful tools in SQL Server for analyzing and troubleshooting a query’s performance is the execution plan. An execution plan can tell you how the database engine intends to execute a query, as determined by the query optimizer, or ho...

Exploring Azure Storage for SQL Server DBAs : If you need to run SQL Server in an Azure Virtual Machine, your choice of Azure storage will have a great effect on its performance. If performance is important, you are likely to discover complications a...

Encrypting SQL Server: Transparent Data Encryption (TDE) : Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the original encryption certificate and master key, the data cannot...

SQL SERVER – Performance Tuning – Part 2 of 2 – Analysis, Detection, Tuning and Optimizing : This second part of Performance Tuning – Part 1 of 2 – Getting Started and Configuration. I suggest you read the first part before continuing on t...

SQL SERVER – Performance Tuning – Part 1 of 2 – Getting Started and Configuration: Performance tuning is always a complex subject whenever one has to deal with it. When beginning with SQL Server, this was the most difficult area for me. However...

How to Transfer 3 Million of Rows or 1.5 GB of Data Per Minute in SQL Server ? Recently there was a huge task – improve ETL process between MS SQL servers – to transfer near billion of rows every day in a real time. This means, once a master SQL...

You may have heard of something called rate limiting or throttling bandwidth, which ensures that you do not use up all the bandwidth available when you are downloading or surfing the ‘net and bog down other users. Resource Governor works similarly,...

Introduction to Change Data Capture (CDC) in SQL Server: Change Data Capture in SQL Server records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables, and makes a record available of what changed, where, and when, in simple relational 'change...

Set Up Database Mail for SQL Server Job Failures : Setting up Database Mail to send an email if a SQL Server job fails. The Steps are : Configure Database Mail,Create a SQL Server job,Adjust the properties within the SQL Server Agent,Create an Operat...

SQL Server 2016 – Introduction to Stretch Database : Stretch Database and the feature will be beneficial to those needing to keep transactional data for long periods of time and those looking to save money on storage. Being able to seamlessly migra...

With the introduction of SQL Server 2016 you now have a new way to encrypt columns called Always Encrypted. With Always Encrypted, data is encrypted at the application layer via ADO.NET. This means you can encrypt your confidential data with your .N...