Partitioning Basics – Part 3 – Switching Data

This post follows on from Partitioning Basics – Part 2
In this final part, I want to go through how partitions can...

PASS DBA VC Session 25th June

It’s always an honour to be able to speak at an event, but events can be expensive to attend and...

Space Used by Database Files

Retrieve data about size and space used for all the files in the current database with this script.

Some tips on...

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