SQL Server – Script to Configure TempDB Files per Number of Logical Processors

In order to reduce Tempdb contention one of  the best practices is to maintain multiple sized Tempdb data files, matching the...

Exploring Excel 2013 for BI Tip #15: Locking Slicer Position

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

ExpressProfiler: Yet another "when and why" story.

Core of ExpressProfiler  was born about 8 years ago when I worked for a company whose mission was the migration...

Introduction to Latches in SQL Server

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...

Last Weeks Top “Reading” Links #89

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Plagiarism: A Community Destroyed

Personal Thoughts

Just to be clear, I don't expect everyone to have my same thoughts. I personally fully support SQLServerCentral and...

Reading, Writing, and Riskmetic-Question of the Day

Reading, Writing, and Riskmetic is another Question of the Day, this one about how to allow developers to understand performance...

sp_SrvPermissions & sp_DBPermissions V5.0

These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures...

SQL Server 2012 || Contained Database

Contained databases are the new feature in SQL Server 2012 and are defined on BOL (http://technet.microsoft.com/en-us/library/ff929071.aspx) as below :
A contained...

SSC Editorial: Bad Meetings or Meeting Badly

Bad Meetings or Meeting Badly is the editorial of the day today. Looking at it today, I wish I had...