Expression Based Interactive Sorting using Reporting Services 2008 – Part 2 Dynamic Sort By

In a previous blog written back in June, I showed you how to use the interactive sort option on a...

Help! I Can’t Connect to Analysis Services in SSMS

A few months ago, I installed SQL Server 2008 R2 and chose to install SSIS, SSRS and SSAS as well....

SQLBIGeek’s Function Friday – Convert Job Duration to Seconds

Brian K. McDonald
SQLBIGeek
Twitter: @briankmcdonald

Welcome to the second post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am...

Creating Analysis Services Partitions Using BIDS

As your database grows in size, Analysis Services cubes that use that database grow along with it. As such, one...

SQLBIGeek's Function Friday - Return First Day of Quarter

Brian K. McDonald
SQLBIGeek
Twitter: @briankmcdonald

Welcome to the first of my “SQLBIGeek’s Function Friday” blog series. I understand that I am posting...

SQL Saturday 49 Delivery Mechanisms - Presentation Slide Deck and Files

This past weekend, my wife and I travelled down to Orlando for SQL Saturday 49. I wasn't planning on presenting,...

Return Indexes for a Particular Table using TSQL

I posted a blog recently about returning a listing of all indexes for database, which is good if you want...

When was SQL Server Restarted?

While doing some performance testing recently and utilizing some of the DMV’s I figured, I better find out when the...

Andy Warren’s Word Counter

I typically don’t blog about other people blogs, because quite frankly I don’t like giving summations of the work someone...

List Indexes For Database using TSQL

A while ago, I showed you how to find out what indexes were on a table using the GUI. Today,...