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

Here is the scenario. You have created a login called "Jane" and have not added to any server role. And you are 100% sure that sh...

When discussing and learning security related to SQL Server, it is always better to know the key concepts and terms related to it. Some of...

Gartner has released its Magic Quadrant for Business Intelligence and Analytics platforms for 2015. Just like the 2014 one, this shows bus...

Regular and well-defined monitoring guarantees smooth running of SQL Server. Based on your goals related to monitoring, you should select ...

It is rare to see a table without at least one constraint because constraints are required to manage data integrity rules. Although we add...

User-Defined Member Properties are attribute relationships added to specific named level in a dimension. Once defined, they can be access u...

Assume that you have multiple transaction log backups that have been taken every hour, starting from 9am to 5pm, and you need to restore t...

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