Identity Column Increment Value (EVEN/ODD)

As always I’m sitting at my desk, minding my own business, when an email comes in from a developer.
“Hey DBA’s,...

Identity Column Increment Value (EVEN/ODD)

As always I’m sitting at my desk, minding my own business, when an email comes in from a developer.
“Hey DBA’s,...

Using Extended Events to Detect Connection Pooling

What is connection pooling? Lets start with a definition from MSDN.
Connecting to a data source can be time consuming. To...

Using Extended Events to Detect Connection Pooling

What is connection pooling? Lets start with a definition from MSDN. Connecting to a data source can be time consuming....

Running Parameterized Queries against SQL Server using PowerShell

For many years I didn’t really think about the implications of how I was retrieving data from my SQL Servers...

Do you write ugly T-SQL?

Are your scripts littered with commented blocks of T-SQL code?
select fname,lname
from usertable
where id=1
--and lname like 'smith%'
/*
-- Who knows why...

Pratical Use of a SQL Server Database Snapshot

I was doing a database code deployment the other night and the first step in the release plan was “Take...

TSQL2SDAY #70: Strategies for managing an enterprise

Thanks to MidnightDBA (b/t) for hosting this month’s #tsql2sday.
Strategies for managing an enterprise.
What do you think of when you...

How many errors can the PowerShell error buffer hold?

During my presentation at SQL Saturday Albany I was asked a question about the error buffer that I didn’t know...

Present at SQL Saturday #386 – Achievement Unlocked!

SQL Saturday #386 (Albany, NY) – My first SQL Saturday Session

So that picture to the right is me out front of...