Practice makes perfect:” right? Well, not exactly. The reality of it all is that this saying is an untrustworthy aphorism. I discovered this in my “younger” days when I was a passionate tennis player, practicing and playing 20+ hours a week. No matter what my passion level was, without some serious coaching (and perhaps a […]
2021-08-14
260 reads
Some organizations see their IT organization as an expense, and not as valuable as it might otherwise be. Steve has a few comments on why this might not be a good idea, or a good place to work.
2021-08-13
283 reads
One of the more analog industries is embracing digital change faster and faster./
2021-08-11
297 reads
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
438 reads
Steve is asking for others to contribute to the sqlmemorial site for our #sqlfamily.
2021-08-06
279 reads
Steve wishes that Microsoft would follow some of their own advice on SQL Server development in their other software.
2021-08-04
271 reads
Links between systems can become a problem if an issue in one system affects the others.
2021-08-02
298 reads
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
481 reads
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
348 reads
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
293 reads
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
If you spend your days tuning queries, managing pipelines, or keeping a production database...
I've got multiple databases on 2 SQL 2019 CU32 servers , all using the...
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
What does this return on SQL Server 2025?
select bit_count(null)See possible answers