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

Here is my second video related to Always Encrypted. This video discusses the way of configuring CMK for serving multiple applications hos...

Here is my second video that speaks about Always Encrypted feature. This video shows How Always Encrypted works, how it should be configure...

Assume that you use SQL Server 2016 and trying to create a  Symmetric Key or Asymmetric Key  for encrypting data. If you try use an algori...

I am happy to announce that SQL Server 2016 Reporting Services Cookbook is published and available for all SQL Server enthusiasts. It i...

Another great enhancement with SQL Server 2016 SP1 is the support of CREATE OR ALTER statement with Stored Procedures, Views, Triggers an...

You might have used this command before or you might be unaware of this command. This was introduced with SQL Server 2014 SP2 and it allow...

Do not expect another standard service pack that contains all hot-fixes and updates done on the previous version, this has something else,...

SQL Server 2016 is released and many have started using it. Here is a simple question on SQL Server 2016; True or False: SQL Server 20...

You may or may not have noticed the initial size of the database at creation but there is a fixed size for both data and log files. Most o...

We have been using Adventure Works database with almost all versions of SQL Server and no questions, it can be used with SQL Server 2016 a...

If you are a web developer and have worked with Classic ASP or ASP.Net, then you know that how important it is for maintaining Session Var...

SQL Server SERVERPROPERTY function was introduced with SQL Server 2008 and it was very useful for getting property information about the s...

For a speedy delete or cleaning the table and resetting some of the properties of the table, we use TRUNCATE TABLE statement. This was rea...

Though there are couple of additions with SQL Server 2016 on TSQL, had no chance to test them and see. While I was going through the list,...

SQL Server introduced In-memory optimized tables with 2014 and it has been enhanced with SQL Server 2016. This improves the performance s...

In most cases, we do not set the database file large, initial size is always less than 1GB, unless a decision is taken to make it suitable...

Microsoft SQL Server team has announced that SQL Server 2016 will be available on June 1, 2016. SQL Server 2016 comes with end-to-end...

SQL Server 2016 will be available soon and will be surely seen more and more advanced features that will help us to continue with both oper...

When PolyBase is opened with SQL Server editions other than APS or PDW, I tested it with SQL Server 2016 CTP 2.1. It had some issues but w...

Please note that there is an issue with connecting to Azure SQL Server using latest RC3 build. If you are experiencing the following error...