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

SSRS Date Parameters for Cube Based Datasets

To have a ‘date picker’ report parameter on your SSRS reports the process works the same on all versions of...

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

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

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

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

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

EXECUTE, not required, but advisable.

The other day one of the developers I work with gave me a script similar to this:
BEGIN TRAN
sp_rename 'tablename.columnname', 'newcolumnname'
COMMITHe...

Quick alert on servers which are not compliant for policies set using PBM

Last month I wrote about leveraging policy based management for regular DBA compliance checks. You can read that post here.
Policy based management(PBM) is indeed...