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

Get Just The Tools: SSMS Download

Ever jump on a machine to connect to a SQL Server and find out… whoops! No tools.  For some reason,...

Job Schedules – SQL Agent

This info should be easier to get than it is. Keep in mind that for something to run the subscription...