Run DBCC CHECKDB on a regular basis

Problem One common task as DBA is to run DBCC CHECKDB on a regular basis to detect and correct potential corruption...

DMV-6 : How well my store procedure doing ?……..sys.dm_exec_procedure_stats

sys.dm_exec_procedure_stats DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-us/library/cc280701.aspx
Returns aggregate performance statistics for cached stored procedures. The view...

Las Vegas April 2013 UG Meeting

AlwaysOn – Finally, A usable ‘mirror’! In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not...

Las Vegas April 2013 UG Meeting

AlwaysOn – Finally, A usable ‘mirror’!
In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are...

T-SQL Tuesday #41 - Presenting Opens Doors

This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....

SQL Server – Generate Calendar using TSQL

Introduction
Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011....

T-SQL Tuesday #41 Becoming a SQL Server “Presenter” GET INVOLVED!

Hello Dear Reader!  It’s been a while since I participated in a T-SQL Tuesday, and this month Bob Pusateri (@SQLBob|Blog)...

T-SQL Tuesday – Love For Presenting – #TSQL2sDay

This month, Bob Pusateri (Blog | @SQLBob) is running T-SQL Tuesday on presenting.  T-SQL Tuesday is a monthly blogging event where a number...

T-SQL Tuesday #41 – Presenting Comes Full Circle and I Love It!

It’s time for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday is one of the...

TSQL Tuesday #41–Presenting and Loving it?

Well sort of…it took a while.

I’d done some plays and singing at school but my mother made me practice...