Giving Thanks Around the Holidays

In the West, the holiday season summons different memories and plans for different people. The thought of gorging on a...

Temporary Post Used For Theme Detection (dff6a50a-5239-4df1-af43-b1e60d02dde4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (621301ab-a053-48fc-a7ec-01dc1d5fe152 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

Benefits from Data Lifecycle Management

I spend a lot of time talking about the need for automation within your databases, especially in support of development,...

When naming transactions causes an error

For the last part of the series on transactions, I’m going to look at a problem that I ran across...

Model needs exclusive lock

Ran into an issue where a developer was trying to create a database and was denied due to no ability...

Model needs exclusive lock

Ran into an issue where a developer was trying to create a database and was denied due to no ability...

Installation SQL Server 2016

Here is some of the installation processes(https://thakurvinay.wordpress.com/category/installation/) Below is very nice step-by -step installation  process for SQL Server 2016: http://www.databasejournal.com/features/mssql/installing-sql-server-2016.html

Model needs exclusive lock

Ran into an issue where a developer was trying to create a database and was denied due to no ability...

Log Shipping: It's Better Than Bad It's Good!

Comparing data in two identical tables

Continuing with the recipes in SQL Server 2012 T-SQL recipes book – I was drawn to this puzzle that asked for...