2023-12-08
459 reads
SQL Server security
Why Haven’t You Disabled SA? Wrong Answers Only.
On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong answers only.” The results were pretty funny:
2023-12-01
2023-11-17
378 reads
2023-10-14
93 reads
Removing Weak Security from SQL Server
The password options for BACKUP at deprecated, which Steve thinks is a good thing.
2023-08-25
176 reads
2023-08-02
407 reads
How to Change the SQL Server Database Owner
Discover the importance of database ownership in SQL Server and learn the process of changing database owner using SQL Server Management Studio or ALTER AUTHORIZATION statement
2023-07-31
38,138 reads
2023-07-26
506 reads
2023-07-12
408 reads
2023-06-28
426 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