Removing SA from Azure SQL Database
Azure SQL Database is getting the ability to turn off SQL authentication.
2021-04-06 (first published: 2021-03-23)
754 reads
Security
Encrypt and Decrypt Passwords in SQL Server with PowerShell
In this article we look at how to securely store data in text files that could be used for SQL Server authentication or wherever you need to keep data secure.
2021-03-17
2021-02-23
55 reads
2021-02-16
100 reads
2021-02-15
479 reads
2021-02-01
444 reads
Default Credentials
Using default credentials is a poor practice, but people still continue to forget to change them.
2021-01-18
310 reads
Microsoft Fights Back
Microsoft fights back against hackers after a recent vulnerability in a management framework.
2021-01-14
211 reads
2021-01-13
77 reads
The Best Way to Protect Sensitive Data
Steve has a thought on the best way to protect sensitive data.
2021-01-07
135 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers