Virtual SQL Playground Adventure: Building The Virtual Environment

Few blog posts ago, I decided to build a virtual environment for a personal SQL Server sandbox. So, the Virtual...

:CONNECT in SSMS

Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from...

Index Fragmentation

So you’ve setup a bunch of indexes in your database to tune the queries coming in. They’re all running much...

Quick tip: Querying AD with xp_logininfo

We all have blind spots in our knowledge. We don’t know they are there and when we are thinking through...

Real-time query access with PDW

The Parallel Data Warehouse (PDW) officially supports Analysis Services as a data source, both the Multidimensional model (ROLAP and MOLAP modes) and...

Some Notes On Writing A Question Of The Day

I wrote Write The Perfect Question (Of The Day) last week and yesterday dropped a note here about my latest...

Speaking at Midlands PASS Chapter tonight

The Midlands PASS Chapter is an official PASS (Professional Association for SQL Server) chapter located in Columbia, SC. It’s free...

SSRS Top N and Bottom N reporting with Duplicates

Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did...

Tables without Clustered Indexes?

Today, we experienced performance issues with some of the SSRS reports that were deployed as part of the latest application/database...

Upcoming Webinar – Bringing Power BI Q&A to your Organization

Come join me for this webinar on 4/15/2014 at 11:00 AM EST

Bringing Power BI Q&A to your Organization
Q&A is an...