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

Configuring/Authenticating with Identity Server in C#

In my previous post I walked through configuring ADFS and writing a small C# console app to authenticate with it...

Using SkyDrive at Work for Collaboration - A Quick Start Guide

It seems that many of my projects in the past year or so have required sharing files with external business...