2023-09-15
278 reads
2023-09-15
278 reads
A challenge that reappears periodically in the world of databases (especially database management) is the need to run code on a subset of databases and to do so in a nuanced manner.
2023-09-04
2023-07-19
373 reads
2023-07-10
361 reads
2023-06-23
335 reads
Do you actively choose which compatibility level makes sense for your SQL Server databases? Or do you just take the defaults? Steve has a few thoughts today on actively managing your system.
2023-06-14
147 reads
This article will show how to generate an HTML formatted report of your disk space.
2023-06-12
4,778 reads
Steve notes that password expiration is important for SQL Logins, but he knows this isn't always configured when logins are created, or checked later to see if it is still enabled.
2023-05-27
153 reads
This article looks at deploying SQL Server on an Azure VM from Azure Data Studio.
2023-05-24
1,323 reads
Learn a number of methods to view or programmatically get the SQL Server instance startup time.
2023-05-12
2,115 reads
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
When ASCII(Column) is null, what does it represent? Is this some kind of special/control...
Hello, I created the below script to output 999 rows from SQL Server table...
I have a database on SQL 2019 in an Availability Group (AG) and I...