Daily Coping 12 Sep 2022
Today’s coping tip is to forgive yourself when things go wrong. A theme of being better to myself, starting with last Thur and Fri. What’s gone wrong for me?...
2022-09-12
15 reads
Blog Posts
How to keep up with technology
(Side note: There is a “subscribe” button on the right side of my home page if you wish to receive my blogs updates via email as soon as they...
2022-09-12 (first published: 2022-08-29)
413 reads
SQLpassion Live Training about SQL Server Availability Groups
On September 29, 2022 I will run an SQLpassion Live Training about SQL Server Availability Groups. High Availability with previous versions of SQL Server was always complex: you had...
2022-09-12 (first published: 2022-09-05)
181 reads
Daily Coping 9 Sep 2022
Today’s coping tip is to let go of self-criticism and speak to yourself kindly. This tip follows on nicely from yesterday’s tip, just the other side of that one....
2022-09-09
11 reads
How To Linux: A Windows Administrator’s Guide to Linux for the Newbie
Well, it’s long overdue that I left the comfort of my Windows GUI and ventured into the world of Linux. Mind you I have dabbled a very little bit...
2022-09-09 (first published: 2022-08-29)
505 reads
SQL Saturday Baton Rogue Recap
Thank you to everyone who came out and saw me present at the SQL Saturday in Baton Rogue! It was a blast to see smiling faces and not be...
2022-09-09 (first published: 2022-08-23)
121 reads
Daily Coping 8 Sep 2022
Today’s tip is to notice the things you do well, however small. I think I have a lot of room for improvement, and it’s easy to self-criticize and find...
2022-09-08
18 reads
A simple lab to demonstrate the danger of NOLOCKs in INSERT statements
The READ UNCOMMITTED isolation level, which the NOLOCK table hint activates, is not to be trusted when it comes to writing data. You are not always protected by error...
2022-09-07 (first published: 2022-08-25)
550 reads
Daily Coping 7 Sep 2022
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...
2022-09-07
20 reads
Thinking about data points and more …
(2022-Aug-28) Going on a family vacation road trip always fills me with a myriad of happy emotions and expectations to explore new places, see new people and essentially be led...
2022-09-07 (first published: 2022-08-29)
175 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