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

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

Following good practice saves wasted time down the line.

TweetG’day,
Sometimes I come across what I call unusual coding practices. Developers usually have pressure on them to deliver and this...

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