My 2013 SQL Saturday Schedule!

I’ve finally gotten my gear together for (what I consider) the “speaking season”. Here are the SQL Saturdays that I’m...

Parameterizing an Excel Spreadsheet

I’ve had a few discussions in the past week about not only including Excel spreadsheets on PerformancePoint dashboards, but specifically...

Rated R (A Teaser)

How many lines of TSQL codes and Window Functions you need to come up with this?
With R, it takes about...

SQLSaturday Redmond(SQLSat212) is almost here…Will you be there?

This is my first SQLSaturday and I’m super excited to attend this event.

SQLSaturday’s are always a great opportunity to learn something exciting,...

The Tale of One Tabular Model and Excel 2013 with Multiple Power View Reports

SQL Server 2012 Reporting Services introduced Power View, which was initially available only in SharePoint. This limited the use of...

Virtualization Networking Tips for SQL Server 2012 AlwaysOn

A while back Kendal Van Dyke (b | l | t) asked me a great question regarding the ideal VMware vSphere networking...

When the person you hire is not the person you hire

This is something I just heard about recently, but then experienced it for myself.
This story was told to me: A...

Xp_readerrorlog in SQL Server 2012

I have always been a big fan of Xp_readerrorlog. The simple reason is that it much faster to read errorlog...

DTA and Hypothetical Indexes

For those of you that don’t know DTA stands for Database Engine Tuning Adviser and is available from the Tools...

Email Response: SQL Server 2012 Planning and Architecture

I received an email from a connection on LinkedIn seeking some advice for architecture on a new reporting system. Although...