SQL Server: Listing all the database roles for a given database user

SQL Server 2005 introduces Common Table Expressions (CTEs), which are great for recursive queries. Previously, in order to do recursion,...

Becoming a DBA, Part I

A recent thread on SQLServerCentral.com had an individual what it took to be a successful DBA. Couple that with a...

Structuring the Blog Better

For a variety reasons, including personal/family concerns and workload, I've not been able to write as often as I'd like....

Alpha Version of SQLPing3 Command Line Available

Noted SQL Server security expert, Chip Andrews, has released an alpha version of a command-line version of SQLPing3. You can...

My Book is Out!

How to Cheat at Securing SQL Server 2005

I recently had the opportunity to contribute a couple of chapters to this...

Midlands PASS October Meeting

Taya Blanchard to speak on A
Practical Guide to Making Sense of Your SQL Server Application
Performance
Midlands PASS Chapter - October...

Vacation... and the need for it

I have been on vacation the last week, which meant I spent the previous three weeks at work preparing to...

Midlands PASS Chapter - August 2, 2007

"Database Professional Toolkit" with Brian and Jeremy
Midlands PASS Chapter - August 2, 2007 Meeting
Sponsored by Red Gate Software

The Midlands PASS Chapter...

ApexSQL's Industry Experts program

If you're a Microsoft MVP, ApexSQL has brought back their industry experts program. You can find out more about it...

A Graphical View of the Physical Allocation of a Database

First saw information about a tool called SQL Internals Viewer in a blog post here at Kalen Delaney's blog. The...