Tag Archives: sql server

Using the DAC with SSMS

Posted on June 11, 2015 by way0utwest

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few notes on structuring a post. While troubleshooting another issue, I needed to connect to SQL Server with the DAC. I … Continue reading →

Posted in Blog | Tagged , , , | 3 Comments

Practical Hekaton

Posted on June 11, 2015 by way0utwest

I got into a debate recently with someone about the In-Memory OLTP tables (formerly Hekaton) feature that was released with SQL Server 2014. This person asked if anyone was actually using the technology, given all the limitations that were placed … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Practical Hekaton

T-SQL Tuesday #67 – Extended Events for DBCC

Posted on June 9, 2015 by way0utwest

It’s the second Tuesday of the month and time for another T-SQL Tuesday. This time it’s #67 from Jes Borland on Extended Events. You can read the invite, and whether you can participate today or not, write your blog and … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on T-SQL Tuesday #67 – Extended Events for DBCC

Architecture for Auditing

Posted on June 4, 2015 by way0utwest

In the analog world, when we need to provide an auditing system for checking on physical activity, we usually separate out the roles of people that might record or track activity from those that perform activities. The better separation we … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Architecture for Auditing