How Paranoid Are You About Backups?
Sometimes just running a backup isn't enough, especially in this era of ransomware. Steve has a few thoughts on backup strategies and recovery skills.
2021-08-09
429 reads
Editorials
Celebrating Lives
Steve is asking for others to contribute to the sqlmemorial site for our #sqlfamily.
2021-08-06
275 reads
Do as I say, not as I do
Steve wishes that Microsoft would follow some of their own advice on SQL Server development in their other software.
2021-08-04
260 reads
Interconnected Temp Files
Links between systems can become a problem if an issue in one system affects the others.
2021-08-02
279 reads
Deploying SQL Server Automatically
I've had to install SQL Server many times over the years. Often it has felt that most of these installs were one-offs, a dev server, a new QA instance, a production server for a brand new application. A few times I've had to recover from disaster, including restoring master, but often, I just installed SQL […]
2021-07-31
474 reads
Your MTTR
There are a lot of metrics you can track and many ways to use them to improve how you build and manage software. Steve has a few thoughts on MTTR and similar metrics.
2021-07-30
326 reads
Leading without Managing
Learning to lead is a valued skill to have, and you can do this no matter what your role. You don't need to be a manager to become a leader.
2021-07-28
282 reads
Do You Have ALL the YAML?
There are lots of data exchange formats, and one of them that has become popular is YAML. However, are you sure you have the entire file?
2021-07-26
1,350 reads
Define All The Steps Up Front
After 23 years in one place, I'm pulling up stakes and moving. We're selling our house in one state in the US and we're buying a house in another state about half a continent away. To say it's a stressful and exhausting process is an understatement. The worst part is that no one has defined […]
2021-07-24
199 reads
How Often Do You Patch?
Patching is a chore that any system administrator needs to deal with. As SQL Server 2016 moves out of mainstream support, Steve asks if you have a plan and how often you ensure systems are patched.
2021-07-23
265 reads
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
The Improvement Limit
Comments posted to this topic are about the item The Improvement Limit
Migrate SSRS Reports to a New Server in Just a Few Clicks
Comments posted to this topic are about the item Migrate SSRS Reports to a...