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
26 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)
424 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
22 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)
507 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)
124 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
25 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)
554 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
27 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)
185 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers