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

One Slick Solution and Unexpected Consequences

Quite a few years ago my first job in the military was driving a tracked vehicle, a variant of the...

SSAS How-To: Create Dynamic Time Calculations To Reuse Over Any Measure

Rather than making individual time calculations for each measure in an SSAS cube (i.e. YTD, Prior YTD, YTD Variances, etc), one can use a more dynamic approach to time calcs applicable to all...

SSAS How-To: Create Dynamic Time Calculations To Reuse Over Any Measure

Rather than making individual time calculations for each measure in an SSAS cube (i.e. YTD, Prior YTD, YTD Variances, etc), one can...

SSRS 101 – Creating a SQL Server Reporting Services Project

This is the second installment in this series of SQL Server Reporting Services 2012 Beginner posts. You can read the...