Too many coding standards : T-SQL Tuesday #151
One of my favorite people, Malathi Mahadevan (blog|twitter), is our host this month and she’d like to talk about coding ... Continue reading
2022-06-14
89 reads
Blog Posts
T-SQL Tuesday 151: T-SQL Coding Standards
It’s that time of the month again, the blog party, woohoo! This time Mala Mahadevan (b | t) has invited us to blog about our T-SQL coding standards. I...
2022-06-14
56 reads
Who is Updating That Table? – SQL Audit
I had a problem at work recently where a record was getting updated, and no one knew where or what was updating the record. Our team discussed the best...
2022-06-14
174 reads
2022 State of PostgreSQL Survey
Hello all. I know most of you are still working within SQL Server. However, a few of you are become more like me, hybrid data managers, working in more...
2022-06-13
15 reads
Daily Coping 13 Jun 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-06-13
12 reads
dbatools - Rich Datatypes
Some datatypes can be shown in so many different forms (think measurament units, dates with short/long forms, or regional settings) that can be difficult to have a standard. What...
2022-06-13 (first published: 2022-06-02)
301 reads
Why You (usually) Want a Clustered Index
Note: I originally wrote this a few years ago but never posted it. It resurfaced when I migrated the blog so it’s being posted now.
After watching Kevin Kline’s (blog...
2022-06-13 (first published: 2022-05-16)
555 reads
Daily Coping 10 Jun 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-06-10
38 reads
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but still cost me hours and a ... Continue reading
2022-06-10 (first published: 2022-05-19)
614 reads
VMware & SQL Server 823-824 alerts
We’ve been tracking a weird state with SQL Server virtual machines on VMware and possible warnings on database corruption while VM backups are running, largely centered around (but not...
2022-06-10 (first published: 2022-05-18)
532 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