SQL 2014 CTP1, where is my BIDS?

Oh wait sorry, I meant SSDT. Or was it SSDTBI? To avoid confusion about the developer tool to create BI...

SQL Server – Understanding ‘sp_spaceused’ Results for Database Size Information

From a recent conversation with a customer, I noticed even some of the experienced DBAs are not very clear about...

SQL Server 2014 CTP1 Released

This week has been the week of the release: We’ve had the Visual Studio 2013 Preview and now the SQL Server 2014 CTP1. And that’s just the ones I’m...

5 community stored procedures you need for your servers

We’re blessed in the SQL Server community that there are so many people willing to share work they have done...

A Rickety Stairway to SQL Server Data Mining, Part 14.1: An Introduction to Plug-In Algorithms

by Steve Bolton

…………In my last post in this amateur series of self-tutorials on SQL Server Data Mining (SSDM), I got...

Improved Temp Table Caching in SQL Server 2014

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Under some preconditions...

Natural Born Killers (The series) – Day 8 Parameter Sniffing

To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...

Ohio Business Intelligence Road Trip 2013

Next month Mike Davis and myself will be making a epic road trip.  We will be flying into Columbus, OH...

PowerSQL – Different Approaches to Find Free Space in all disk drives

Different ways to find FreeSpace  in all disk drives of a given server
T-SQLUsing WMIObjectCountersAll three methods are explained below
This post...

SQL Server Installation Date

I have been working on a project recently to collect system metrics of a SQL Server environment. One of the items...