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

MVP Status: Renewed

I was just answering an email and realized I’m behind on posting on a few topics, one of them the...

PASS Summit: What’s all the hype?

Last week I received this comment/question from one of my fabulous First Timers:
I have a good natured question coming from...

Presenting at OKC SQL Server User Group Tonight!

Tonight, October 8th at 6:30pm I am virtually speaking at the OKC SQL Server User Group.  I had a blast...

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

Understanding DBCC CHECKDB, to deal with corrupt database

Database files are volatile, constantly being changed and updated, so that, like any other volatile files in the system, there...

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

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

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