Finding Trouble
If there was any one skill I could rank as number 1 for new hires, be they junior or senior, it would be troubleshooting. If someone out there has a … Continue reading
Coming Soon SQL 2016 Live Query Statistics (LQS)
I recently stumbled onto a feature in the upcoming release of SQL Server 2016 that at first seemed really intriguing. Live Query Statistics – a way to see the query … Continue reading
Informed Decision – FORCE_SERVICE_ALLOW_DATA_LOSS
Recently we had a disaster recovery event on a couple of mirrored servers. By that, I mean we were required to move primary database operations to an offsite mirror partner. Because … Continue reading
The Road to SQL Server 2014 MCSE
This afternoon I finally passed the last test in the Microsoft Certified Solutions Expert series for Data Platform. I started the first test in the series while at Tech-Ed 2013 New … Continue reading
TSQL Tue 65: Memory Optimized Hash Indexes
The topic this month is learn something new and then teach it to everyone else. Great topic Mike! Late last year I set the goal to finish up my MCSE. … Continue reading
Experience Is Overated
Be careful not to read too much into the title. It’s not a global statement. Experience has value, but this is my blog and I reserve the right to go on … Continue reading
TSQL Tue 64 Roundup
Last week was my first time hosting TSQL Tue. The topic was “focused tuning”. I had some stiff competition that week with SQLBits and the final week to get PASS submissions … Continue reading
TSQL Tue 64: Tuning SSIS with In-Memory Stage
I’m excited to be hosting TSQL Tuesday this month. The topic is focused performance tuning. Please be sure to check out the other posts submitted for this month’s blog party … Continue reading
TSQL Tue 64: Calling All Tuners and Gear Heads
It is month 64 of Adam Machanic’s monthly blog party known as TSQL Tuesday. I’m very honored to be hosting this month. Let’s get to it. This is your official invite to the SQL Server Performance Grand … Continue reading
Entity Framework Hidden Cursors
As a database administrator I’m most concerned about what’s happening in production – not how many lines of code were saved in development. For this reason I started researching EF on … Continue reading