Developer’s Life – Every Developer is a Spiderman

Originally posted on Journey to SQL Authority with Pinal Dave:
I have to admit, Spiderman is my favorite superhero.  The most...

Data Collection in SQL Server

Problem : As a DBA, one of your primary job description is to handle management and administration of 1 or 100+...

Allowing your App team to run SQL Agent Jobs

Problem : In most of your projects, there is always that situation that the application team have that need to run...

That “Cannot Generate SSPI Context” headache

Problem : You have completed an SQL Server setup on a new instance. The setup is successful, you can connect locally...

SQL Agent Error During Windows Failover Cluster Setup

Problem: You had just finished up installing cluster setup in your Primary node. After verifying your setup is complete and...

Cumulative Update #16 for SQL Server 2008 SP3

Here’s a link for the download for the CU #16 for SQL2008 SP3 http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/03/17/cumulative-update-16-for-sql-server-2008-sp3.aspx.  The post also includes all the previous...

Understanding CXPACKET wait stats in SQL Server

Understanding CXPACKET From the SQL BOL (Books on Line) CXPACKET is defined as Class Exchange Packet and “occurs when trying...

Reviewer #17 Database Replication in SQL Server 2012

Wow, my first article for the year 2014! Here’s to a blessed and fruitful year ahead for all of us...

Understanding the Copy_Only option in Backups for SQL Server

The Copy_Only option is very useful in full backup scenario when you don’t want to break up the sequence of...

Holiday Greetings!!!