TheSQLPro YouTube Channel

That’s right, it’s time to take this blog up a notch!  Last week I posted a video about using Hyper-V...

Thoughts on December 2013 Power Query Updates

Just in time for Christmas the Microsoft product teams responsible for Power BI have a slew of amazing updates.  The...

SQL Server Installation Folder Setup Log and Command Line Install Information

The other morning I was commenting during our regular meetings amongst fellow DBAs on where to read up on installation...

User Groups and Winners!: Day 3

Today's winner is! Aadhar Joshi!
Congratulations for winning a free month of PluralSight. I'm E-Mailing you the code right now.

We still...

Collecting Historical Wait Statistics

As a DBA, I'm sure you've heard many times to always check the sys.dm_os_wait_stats DMV to help diagnose performance issues...

Learn To Code

Today I ran through the first tutorial at Code.org. It has 20 very short lessons that use Angry Birds and...

T-SQL Tuesday #49: My Go-To Query For Waiting Tasks

I’m not just hosting T-SQL Tuesday, I’m a customer as well. Err, I mean participant. Topic for this month’s T-SQL...

Certification Updates for SQL Server 2014

Info from Microsoft on how the MCSA and MCSE certifications will be altered for SQL Server 2014:
In reviewing the SQL...

T-SQL Tuesday #49: Wait for it

It’s T-SQL Tuesday again and this time it’s being hosted by the SQL Soldier. He’s picked the subject of Waits....

Be a Brilliant DBA

John Sanson (b|t) recently asked a bunch of us, “If you could give a DBA just one piece of advice,...