Listing server and database roles for all logins and users in SQL Server – Part 1 – Local Server

I was approached with a unique problem to solve; find out who has what permissions on my Database Servers.  This...

London Baby

Come and join me live in London this coming December where I will be presenting Learning Tree’s2109 SQL Server Virtualization...

SQLskills to present at Omaha SQL Server Users Group Tuesday

The Omaha SQL Server Users Group meeting for October is coming up this Tuesday, and the coordinators have prepared a...

Ten SQL Kindle eBooks for Under $10

Introducing Microsoft SQL Server 201231 Days of SSIS with SQL Server 2008 R2SQL Server Interview Questions and AnswersPerformance Tuning with...

MDX #18 – Easy to concatenate row values into column in MDX

Concatenating row values (within groups) into column in SSRS and TSQL
Concatenating row values into column is a never ending topic...

Rebuild indexes based on fragmentation - sp_RebuildIndex

Reblogged from Basit's SQL Server Tips:
In my previous post here, I’ve discussed how we can detect fragmentation in SQL Server...

Reasons Why People Who Work With Computers Seem To Have A Lot Of Spare Time…

SQL Server – Msg 2555, Level 16, State 1, Line 1 – Error DBCC SHRINKFILE with EMPTYFILE option

When tried to empty one of the tempdb data file using the below T-SQL command: (My goal here is to...

Thanks everyone for a fantastic SQL Saturday Lincoln #165

Today I presented two sessions at SQL Saturday Lincoln (almost in my backyard!) – Virtualizing Business-Critical SQL Servers and Database Health...

Class and instance variables in Python 2.7

The differences and interactions between class variables and instance variables are well described in the Python 2.x documentation, but they...