Tag Archives: sql server

Disabling SQL Server Network Protocols

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across a question on network protocols recently, which is something I rarely deal with. Often the default … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Disabling SQL Server Network Protocols

Rebuilding a Heap–Don’t Do It

I saw someone mention recently that you can run a REBUILD on a heap table. I hadn’t realized that, but when I looked in BOL, I saw that indeed you can run this on a heap. That’s interesting, in that … Continue reading

Posted in Blog | Tagged , , | 3 Comments

An Impressive SQL Server

This editorial was originally published on May 6, 2011. It is being re-run for the Christmas holiday. Merry Christmas and Happy Holidays! Recently I heard about one SQL Server with 1TB of RAM and another one that was handling over … Continue reading

Posted in Editorial | Tagged , | Comments Off on An Impressive SQL Server

Tracking Logins with Extended Events

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers. I was building a question the other day on Extended Events and needed to build a new session. One of … Continue reading

Posted in Blog | Tagged , , , , | 4 Comments