T-SQL Tuesday #34 – Help! I Need Somebody

I couldn’t resist, so here goes….
Help, I need some data,
Help, not just any data,
Help, I was told you...

Colorado SQL - September 2012

COLORADO SPRINGS SQL
September 19, 2012 at 5:30 p.m.

Meeting Location:  Hyatt Place - Garden of the Gods, 503 West Garden of the Gods...

Demystifying SQL Server Differential Database Backups

Odd Man Out
SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood.
Let’s...

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