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

Everyone knows that SQL Server started supporting CREATE OR ALTER  statement with SQL Server 2016 and it can be used with few objects. How...

I have been blogging for years but I think that the most important and success year is 2016. I have made 171 posts in 2016 based on my e...

Earlier I made a post on SQL Server Backup to URL:  SQL Server Backup to URL - Now easier than before that explains how to take a backup ...

I am sure that everyone is well aware on SELECT INTO statement. This statement allows us to create a table using a SELECT statement just li...

This is not about databases completely maintained in cloud, this is about databases created and maintain on-premises but data and log file...

My previous post discussed SQL Server Backup to URL , this is an error related to it. ​A nonrecoverable I/O error occurred on file ...

This post is written by Andrew Jackson Overview SQL Server Database helps users to create their own databases where they can store or ...

This is not something new with latest Microsoft SQL Server but this is still being discussed and it is unknown or unclear to many of datab...

This is something we always worry, what will happen if the name of the host machine is renamed? After renaming, can I connect with my SQL ...

In a continuous running SQL Server environment, it is not uncommon to see a large error log related to SQL Server that is continuously gro...

When you talk with your database, you use a language that is understandable to the database component you access and specific to the vendo...

We have been developing data warehouses, centralizing enterprise data and addressing business intelligence requirements. Generally, almost...

SQL Server does not resolve names of stored procedures just as it does on tables. This resolution is bit different. Here is the post I mad...

How SQL Server resolves object names if you have not referred it is as a fully qualified object? If it is not a fully qualified object (a ...

I am sure that you are familiar with ROLLBACK TRANSACTION and COMMIT TRANSACTION but have you heard about or used ROLLBACK WORK and COMMIT...

Assume that you have a table with thousands of records and some of the records are being updated by another user. Now you try to read some...

Let's talk about date and time. Have a look on following code and try to guess the value returned by last SELECT statement. USE te...

Few Cumulative updates have been released for SQL Server 2012 and 2014. Here are the links for them: Cumulative update #6 for SQL Server ...

No matter how hard the software has been tested, issues can be still encountered. Same applies to Microsoft SQL Server too and that is the...

Here is another question I got in this week. The question is all about rolling back transactions, whether we need to write a code with ROL...