Quick tip: Using DBCC SQLPERF(‘LogSpace’)

A lot of a DBA’s time is spent managing and investigating transaction log files.
A commonly used tool is the command:
DBCC...

SQL Saturday 162

SQL Saturday 162 was a great event, kudos to the team involved and I took a lot of pleasure in...

SQL Server:Output Clause

Couple of days back, one of my colleague came to me asking for help. He is inserting multiple record from a...

SQLSaturday Metrics

A recent article in the PASS Connector called out some interesting stats about SQLSaturday for 2011 and 2012. I’m including...

Upcoming Fall Events

During September/October I’ll be presenting at several in-person events:

Tampa IT Pro Camp
Join system administrators and IT professionals for the Tampa...

5 Performance Killers When Working With Linked Servers

When working with linked servers, the most expensive factor to consider is the amount of data that will have to...

My Session on Locking Internals Part 1 in CSSUG Meet

Bad weather won't stop hungry minds. Our today’s Chennai SQL Server User Group (CSSUG) meet happened with around 25 enthusiastic SQL Server...

SQL Server Best Practices for DMV's - Houston Tech Fest 2012

It is a pleasure meeting everyone today at Houston Tech Fest!  The new facility is miles away - literally and figuratively...

Lost in Translation – Deprecated System Tables – sysdevices

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...

SQL Saturday 167

SQL Saturday #167 is just hours away.  We have worked hard to get everything setup and in place and hope...