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

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