Least Privilege
Steve wonders how well most organizations and their staff adhere to the principle of least privilege.
2024-07-15
206 reads
Editorials
The Danger of Safety Assistance Tools
During a speaker dinner the other week, a lot of topics were swirling around and a few caught my ear. One of these topics dovetailed nicely with a mistake I recently made. More on that later. The discussion was on the effect on safety that all the new safety-based tech is having on driving. Some […]
2024-07-13
99 reads
The Number that shouldn't be a number
Gail Shaw is often left bewildered by the weird and wonderful data types people choose for their tables, when storing something as simple as a telephone number or a date.
2024-07-12 (first published: 2015-02-02)
721 reads
2024-07-10 (first published: 2024-07-08)
192 reads
The Stretch Database Retirement
Steve has a few thoughts on the removal of Stretch Database from the SQL Server world.
2024-07-10
337 reads
Protecting Schools
Schools often lack resources and struggle to protect themselves. An interview shows one district doing well, with some lessons for those of us in other organizations.
2024-07-06
77 reads
2024-07-05
166 reads
Xp_cmdshell Use Cases
Today Steve asks for the ways in which you use xp_cmdshell in your environment.
2024-07-03
262 reads
The Cost of Rework
Steve notes that we're always better doing things better the first time. That takes some effort.
2024-07-01
176 reads
Shout Your Successes
I was at a customer this week (sorry, can't share who). I spent the day talking about Redgate Monitor and how it can help with query tuning, server management, and estate management. Through the day, the data pros at the company were sharing how they were managing hundreds of servers and several thousand databases. They […]
2024-06-29
124 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers