Tags » SQL Server 2008 R2

SQL Server - Backup Verification Script - Based on conditions

Problem: There are scenarios where you have to verify the multiple SQL Server instances backup within limited time frame whether it meet your organization backup criteria standards or not. 862 more words

SQL Server

Evolution of SQL Server 2014

Found these images on Google and it’s something I would like to share with you guys:

Join us at LinkedIn!
Don’t forget to join the… 8 more words

SQL Server 2008 R2

Installing SQL Server 2008 R2 Cluster

Microsoft Cluster

A Microsoft cluster is a high-availability system designed to keep the database up as much as possible. It does this by resuming processing on the secondary server in the event of a failure on the principal server. 680 more words

Database Administration

Sql Server: How to rename a column

Quick one today:

Sometimes, we need to rename some column names. Surprisingly, there is no intuitive way to rename a column name in Sql Server i.e. 51 more words


Sql Server : Enable execution STATISTICS for IO and Time for queries

Quick one today:

Sometimes, for some scripts, viewing execution statistics for IO and TIME help measure the improvement you make with code changes.

They could be enabled with the following T-SQL: 50 more words


SQL Server latest Cumulative Updates (July 2014)

Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2008 R2 SP2 and 2012 SP1/SP2:

SQL Server 2008 R2 SP2… 49 more words

SQL Server