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

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...

If you are maintaining your profile with world largest professional network (Im sure that you are) and you have done a Microsoft Certificati...

Are you planning to do Microsoft SQL Server certifications in next few weeks? If so, here is an announcement on exams updates. All MCSE rela...

It is a fact that non-clustered indexes improve the performance of data retrieval and we tend to add them mostly based on predicates used. A...

Gartner has published its Magic Quadrant for Business Intelligence and Analytics platforms covering 17 capabilities grouping them into 3 ca...

We had another Door-Quiz at SS SLUG yesterday and as usual, the question asked was tricky. However, many had circled the correct answer and ...

Who introduced or invented Dimensional Modeling? Was it invented by Ralph Kimball ? Since he completely aligns with Dimensional Modeling in ...