What is the Difference Between Physical Sockets, Physical Cores, and Logical Cores? I witnessed an interesting conversation on Twitter today where someone was talking about how he uses the terms sockets and cores interchangeably, since everyone else...

The Importance of Database Compatibility Level in SQL Server : Prior to SQL Server 2014, the database compatibility level of your user databases was not typically an important property that you had to be concerned with, at least from a performance pe...

Top SQL Server Interview Questions With Answers - In this tutorial, I will be covering some of the most frequently asked SQL Server Interview Questions to make you familiar with the type of questions that can be asked during a Job Interview related t...

Top 50 SQL Server Interview Questions & Answers . 1. What are the two authentication modes in SQL Server?There are two authentication modes –Windows Mode,Mixed Mode. Modes can be changed by selecting the tools menu of SQL Server configuration prope...

SSIS Interview Questions Part 2 .If you're looking for Interview Questions on SSIS for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research SSIS has a market s...

SSAS Interview Question Part 2 . SQL Server Analysis Services (SSAS) Interview Questions And Answers . How Many Types Of Dimensions Are There And What Are They? They are 3 types of dimensions: confirm dimension,junk dimension, degenerate attribute.

In this Power BI Interview Questions blog, we will be discussing some of the most important interview questions associated to Power BI certification which will help you stand out in your interview.

If you are planning to give an interview for an SSRS Developer role but confused on how to crack that interview and also what would be the most probable SSRS interview questions that the interviewer may ask? Well, you have reached the right address.

If you're looking for SSAS Interview Questions for Experienced or Freshers, you are at right place. According to research SSAS has a market share of about 26.35%. So, You still have the opportunity to move ahead in your career in SSAS certification g...

Top SSIS Interview Questions and Answers. Following are frequently asked SSIS Interview questions for freshers as well as experienced Database managers. SSIS or SQL Server Integration Services (SSIS) is a component of Microsoft SQL Server, which can...

How to add a TDE encrypted user database to an Always On Availability Group :SQL Server Transparent Data Encryption, also known as TDE, is a “data at rest” encryption mechanism that is introduced in SQL Server 2008 as an Enterprise Edition featur...

Different Approaches to Correct SQL Server Parameter Sniffing :How many times when a process takes longer than expected you have listened to the same complaint: It was working yesterday? This is a tough complaint to face, especially when you need to...

Let’s say that you care about your SQL Server environment, but let’s also say that you care about your time too. You are actually one of those people who always strive to do more with less. Now let’s say that you frequently have to install new...

Practical Processor Selection for SQL Server 2014/2016 OLTP Workloads: Imagine that you have just gotten management approval for a new on-premises, database server that will run a mission critical OLTP workload with SQL Server 2014 Enterprise Edition...

The XML Data type has definite uses, but the way of interrogating, retrieving, and manipulating the values of properties and attributes within XML have been so foreign to the SQL language as to be somewhat of a barrier to their use.