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

Have You Seen This Error?

location: AppendOnlyVerStoreMgr.cpp:776
Expression: 0
SPID: 64
Process ID: 4912
Description: Cannot locate version record and page is not allocated. Status = 3
Msg 3624, Level 20,...

Master Data Services: Changing a model with a subscription view

I have been working heavily with Microsoft Data Services (MDS) in SQL Server 2012 over the past few months, and...

No Full Outer Join in Access

Recently I needed to help a colleague with a small inventory true up task. We needed to know items that...

PASS ProfDev VC presentation recording available

Back on August 15th I did a webinar for the PASS Professional Development virtual chapter on my talk Being the...

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