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
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
Rolling Upgrade: Synch Mirrors, Log Shipped DR – Lessons Learned
We recently did a hardware/software upgrade of a set of servers participating in synchronous mirroring for HA purposes with a log shipping solution for disaster recovery to a remote location. … Continue reading
Change Data Capture – Lessons Learned
I like where Microsoft is going with Change Data Capture (CDC). In a data warehousing scenario where you only need what’s changed since the last load it’s a magical solution. There is a … Continue reading