Tags » SQL Server 2008 R2

SQL Server Spatial Art

Yesterday I attended Hope Foley‘s webinar during 24 Hours of PASS, thanks for that!

A few examples:
Here’s Michael Coles Christmas card of 2009: 130 more words

SQL Server 2008 R2

Sql Server : Collation and Unicode vs UTF-8, UTF-16 and UTF-32

More often these days, there have been many conversations around the topic of handling unicode data and UTF-* type data in Sql Server. Some details are below: 300 more words


T-SQL Script to Check the Native Compressed backup file size and Backup Compression Ratio

First of all make sure backup compression is enabled on the SQL Server. You can execute below query to check the backup compression.

select name,,value_in_use from sys.configurations where name like '%backup%'
… 237 more words
SQL Server 2008

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