Daily Archives: July 21, 2021

Using Aggregates in Calculations with Other Columns Functions–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In the last post on Window functions, I looked at ROW_NUMBER, and how I can use this to order … Continue reading

Posted in Blog | Tagged , , | 2 Comments

The Danger of Management Access

First we had the Solarwinds hack, and now we have a Kaseya ransomware epidemic. It seems the criminals are moving up the stack. We used to see physical attacks on tapes and keyboards, then we saw OS level attacks. Now … Continue reading

Posted in Editorial | Tagged | Leave a comment

Daily Coping 21 Jul 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips … Continue reading

Posted in Blog | Tagged , , | Leave a comment