Dinesh's Blog :::: Being Compiled ::::

As you know SQL Server supports three types of protocols, or we can called them as SNI Transport Providers, for communicating with a SQL Se...

General understanding regarding the log file (ldf) is, it is getting automatically truncated when the Recovery Model is set to SIMPLE and ...

Not all cipher texts are required to be converted back to plain texts. Good example is "passwords". All we need with non reversi...

Let's start with a simple thing in 2015. Why we get '*' when converting one type to another? If you have already experienced it...

Can SQL Server send a notification to me when a deadlock is occurred? Can SQL Server alert me when a database starts suffering with resour...

Date and Time Dimensions Most of analysis and reporting requirements include a need to aggregate values over time period and this lea...

Microsoft has released Cumulative Update 1 for SQL Server 2012 Service Pack 2 and it is available for downloading. Here is the link for do...

Are you looking for SQL Server 2014 AdventureWorks databases and applications? It is now available and here is the link: https://msftdbpro...

If you have gone through Windows services, specifically SQL Server services, either through SQL Server Configurations manager or Windows Ser...

Microsoft has released SQL Server 2012 Service Pack 2 and it is available for downloading. Here is the link for downloading: http://www.mi...

This is a common question I always get from my classes/workshops. Do we really get some benefits out of a database with multiple data files ...

Are you looking for a way of adding the name of the account used for the session to the resultset? Here is the way of adding it;

You might have noticed that the data type of object names such as database name is “sysname” which is not listed in data type list when crea...

While trying to get some records from a database configured in a Windows Azure machine (NOT SQL AZURE), I noticed that the connection can be...

As you know, some of the components such as Management Studio (SSMS) and Configuration Manager are shared components of SQL Server instances...

Are you trying to get the total number of records in one of your tables? If yes, what is the best, or what is the quickest way of getting th...

If you have a requirement for connecting with SQL Serer virtual machine configured on Windows Azure, there are few things to be done. The fo...

The LRU , or Last Recent Used algorithm determines the data pages to be dropped from the cache when Data Cache section, which is the large...

“As per MSDN, the maximum memory can be consumed by SQL Server is 8TB, Will SQL Server surely use 8TB if the box is configured with 8TB?”. T...

Couple of new features have been added to Power Query and they are available with the latest version of Power Query: 2.11.3625. Here is th...

Are you searching for SQL Server Data Tools or Business Intelligence Development Studio after installing SQL Server 2014? If so, you are rea...

Cumulative update #12 is available for SQL Server 2008 R2 SP2 . Refer the following link for downloading it and understanding the fixes done...

We did it again! Thanks Sanga, Mahela and the team, proud to be a Sri Lankan.

As a best practice, we always add a new key, known as a surrogate key to dimension tables for identifying the records uniquely. However, gen...

Want to know some major features added to SQL Server 2014? Here is an easy way. This book explains how SQL Server 2014 leverages in-memory...