SQL Server 2019 – Compatibility Level in Azure
I am not sure when this became available but for Azure SQL Database 150 compatibility level is now available. Last time I created a database few weeks ago, only...
2019-09-18
68 reads
When using Powershell to control Azure the Cloud Shell doesn’t require an additional login.
When studying Azure one of the things you’ll be asked to learn is the Powershell commands that can control, well, ... Continue reading
2019-09-18
82 reads
SQL Server Statistics Health Reminder
I’ve written about statistics in SQL Server a few times now. Through conversations I am reminded that not everyone keeps their table statistics up to date. Keeping your statistics...
2019-09-26 (first published: 2019-09-18)
513 reads
Running SQL Server containers as non-root
Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on Github. This dockerfile was under the mssql-server-linux-non-root directory and (you guessed it) allows SQL Server...
2019-09-25 (first published: 2019-09-18)
1,003 reads
Interview with Greg Low
This is the sixth interview we have done. This time our guest is Greg Low! I bet you know Greg as he is one of the most recognizable person...
2019-09-17
14 reads
Interview with Greg Low
This is the sixth interview we have done. This time our guest is Greg Low! I bet you know Greg as he is one of the most recognizable person...
2019-09-27 (first published: 2019-09-17)
246 reads
Azure SQL Database Types
I want to do a quick summary post of the many different types of Azure SQL Database available and I am not talking about elastic pools, VMs etc, more...
2019-09-17
32 reads
Azure SQL Database – Azure Portal Updates
A small but useful change has been made to the Azure Portal for Data Platform objects. Straightaway more meaningful information is exposed (and centralized), such as the service tier...
2019-09-17
43 reads
SQL Server Quick Tips
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-24 (first published: 2019-09-17)
1,005 reads
SQL Server Quick Tips
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-17
5 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers