Cloud vs On-premises
Is the cloud better or worse for a workload? One company, BlueSky, has moved on-premises despite their rapidly growing workload.
2024-07-17
355 reads
Editorials
Least Privilege
Steve wonders how well most organizations and their staff adhere to the principle of least privilege.
2024-07-15
190 reads
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
80 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)
707 reads
2024-07-10 (first published: 2024-07-08)
174 reads
The Stretch Database Retirement
Steve has a few thoughts on the removal of Stretch Database from the SQL Server world.
2024-07-10
306 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
70 reads
2024-07-05
147 reads
Xp_cmdshell Use Cases
Today Steve asks for the ways in which you use xp_cmdshell in your environment.
2024-07-03
253 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
162 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers