Invitation for T-SQL Tuesday #39 – Can you shell what the PoSH is Cooking?

T-SQL Tuesday Party History
In case you’ve been hiding out in the desert, oblivious to all that goes on, there is...

MDX #25 – Slicer or Sub-Cube?

Slicer, Axes and Calculations Can All Filter Data in MDX
Every developer with SQL background knows how the WHERE clause works....

Reblog: February 1 to February 7

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

SQL Server – Cycle Error Logs for SQL Server and SQL Server Agent

SQL Server error logs can fill up quickly, and when you are troubleshooting something you may need to go through...

24 Hours of PASS: Business Analytics Edition videos online

On January 30, BA and BI experts took to the virtual stage for the 24 Hours of PASS: Business Analytics Edition to...

A Month of PowerShell – Day 7 (Script Input/Output)

Welcome to Day 7 of my “A Month of PowerShell” series. This series will use the series landing page on...

A Rickety Stairway to SQL Server Data Mining, Algorithm 6: Association Rules

by Steve Bolton
                In last week’s installment of this series of self-tutorials on SQL Server Data Mining (SSDM), we covered...

Announcing SQL Saturday 197 Omaha Pre-Cons!

Here is a flyer produced by someone on the team - he says it all very well:

--

Friday, April 5, 2013
Get Warmed...

Avoid This Time Scheduling Mistake

I was recently asked by a project manager to lay out when DBAs would accomplish certain tasks for a particular...

Move or Relocate the files of Resoruce Database in SQL Server 2005

The Resource database is a read-only database that contains all the system objects that are included with SQL Server. SQL...