LivingForSQLServer celebrates 2nd year anniversary today

It's been 2 years since I wrote my first blog post on SQLServerCentral ("What happens when a query is submitted").
No...

My Writing Toolkit for the book project

I’m in the middle of writing the first chapter of my book. I’m not just ready to announce the working...

Next Chennai SQL Server UG Meet Is Scheduled

Chennai SQL Server user group meet is scheduled for Dec'2013.
Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:30...

Plan cache bloat by SQLAgent (Prior to SQL2008) !

Recently I was checking the plan cache utilization with the help of the below query which I normally use for...

About

I am a geek, husband, father, geocacher & gratuitous consumer of satellite signals (not in that order). I’ve been in IT professionally for over two decades doing web development,...

Backup History

This is a quick rewrite of the script I just posted a few days ago.  The script had a few...

Get Performance Counters from within SQL Server

I think most DBAs know that you can use the Windows Performance Monitor to capture performance metrics for your SQL...

How to create site directly in new content db

Hey Friends,

Sometime when we build a new SharePoint site or site collection. We may feel to create in a new...

On the Advantages of DateTime2(n) over DateTime

Starting with SQL 2008, we database developers started becoming more familiar with datetime2.  Sometimes folks need convincing though, so here...

SQL Server Policy Based Management Alerts

SQL Server Policy Based Management Alerts

Problem

Policy-Based Management is used to enforce standards on SQL Servers and it's great. But not...