Tag Archives: sql server

The Challenges of Space

It wasn’t that long ago in my career when a survey showed the vast majority of SQL Server databases were < 10GB in size. These days I’m sure the average has risen as there are some very, very large SQL … Continue reading

Posted in Editorial | Tagged , | Comments Off on The Challenges of Space

Using the DAC with SSMS

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

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

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