Monthly Archives: February 2016

The Push to Upgrade from SQL Server 2005

Posted on February 12, 2016 by way0utwest

It was interesting to see the results of my straw poll last week on SQL Server 2005. Quite a few people still run that version, and some aren’t looking to upgrade anytime soon. However when support ends, you should be aware that … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Push to Upgrade from SQL Server 2005

Limiting Database Permissions for DLM Dashboard

Posted on February 11, 2016 by way0utwest

I was talking with some of our support people recently about permissions on DLM Dashboard. A client was having issues, and we weren’t sure what was wrong. As a result, I decided to dig in a bit and see how … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Limiting Database Permissions for DLM Dashboard

Reasonable Timeframes

Posted on February 11, 2016 by way0utwest

Many of us hear about problems with various systems on a regular basis. We report them in Database Weekly far too often, and I’m sure a few of you have been informed (or found) bugs, nagging issues, even vulnerabilities in … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Reasonable Timeframes

CROSS APPLY v InLine Functions

Posted on February 10, 2016 by way0utwest

While working on the Advent of Code problems in SQL, I ran across something interesting. Day 4 involves hashing, which is done with the HASHBYTES function in SQL Server. This is a computation and given the problem, there is no … Continue reading →

Posted in Blog | Tagged , , | Comments Off on CROSS APPLY v InLine Functions