SQL Server Updates Tricked Me for Years

When applying a new SQL Server cumulative update, hot fix, or upgrade SQL Server doesn’t always apply all the fixes in the patch. When you upgrade the database engine in-place, databases you had already stay at their pre-upgrade compatibility level, which means they run under the older set of optimizer rules. Additionally, many optimizer fixes are not turned on. The reason for this is that while they may improve overall query performance, they may have negative impact to some queries. Microsoft actively avoids making breaking changes to its software. To avoid any negative performance impacts, Microsoft has hidden optimizer fixes… Continue Reading

Bloggers Should Have Reach

One of my goals for 2018 is to expand the reach of my blog. As a blogger starting out I had my own site I posted to, but my blogs only reached those who followed me on Twitter, Facebook, Google + and LinkedIn. My blog automatically posts to these three sites using a WordPress Jetpack Plugin called Publicize. After a few months, I discovered that syndication could be setup on other sites such as SQL Server Central.  This allowed more people the opportunity to read my writing and expand my reach. Many sites, such as these will even send your… Continue Reading

Expanding My Reach

I am so thrilled to have the opportunity to expand my writing with my first Simple-Talk article posted.  Simple- Talk is technical journal and community hub from Redgate. It in I discuss my passion for my work as a Lone DBA.   You can find the full article using the link below. https://www.red-gate.com/simple-talk/opinion/career/survive-lone-dba/ Continue Reading