EXECUTE AS USER = ‘Somebody else’

As a database administrator I get lots of security requests. “Please grant me read authority on this table, write on that table,...

Change file logical name for mirror database

Today I encountered a interesting issue when rename logical name for mirror database.

We have a database which has been setup...

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

SQLSaturday Metrics

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

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

SQL Saturday 162

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

Reading Reviews, Ordering a Laptop, and Lenovo

Since earlier this year I’ve been thinking to replace my aging but still useful laptop, mostly to get something lighter,...

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

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

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