Understanding and working with NULL in SQL Server
Graphic representation of the difference between 0 and NULL
Image taken from 9gag.comAccording to database theory, a good RDBMS must implement...
2019-01-30
1,445 reads
Blog Posts
Understanding and working with NULL in SQL Server
Graphic representation of the difference between 0 and NULLImage taken from 9gag.com
According to database theory, a good RDBMS must implement a marker to indicate "Missing or inapplicable information".SQL Server...
2019-01-30
14 reads
Webinar next week on Database DevOps
Next week is my webinar on why the database is the heart of DevOps. You can still register today to...
2019-01-30
753 reads
Authentication considerations for your applications when migrating to Azure SQL Managed Instances
This blog post is related to my previous blog post on Azure SQL Managed Instances:
Azure SQL Managed Instance – full blown...
2019-01-29
355 reads
Azure SQL Managed Instance – full blown SQL Server in the cloud….?
This blog post is one that I have had percolating in the background since around November 2018.
My good mate John...
2019-01-29
1,180 reads
Cardinality: Not Just For The Birds
Watch this week's video on YouTube
When building indexes for your queries, the order of your index key columns matters. SQL Server can make the most effective use of an...
2019-01-29
7 reads
Cardinality: Not Just For The Birds
Watch this week’s episode on YouTube.
When building indexes for your queries, the order of your index key columns matters. SQL...
2019-01-29
1,030 reads
Cardinality: Not Just For The Birds
Watch this week's video on YouTube
When building indexes for your queries, the order of your index key columns matters. SQL Server can make the most effective use of an...
2019-01-29
8 reads
Controlling the firewall for an Azure SQL DB via T-SQL
The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I...
2019-01-29 (first published: 2019-01-16)
2,241 reads
Deploying SQL Server to Kubernetes using Helm
In previous posts I’ve run through how to deploy sql server to Kubernetes using yaml files. That’s a great way...
2019-01-29 (first published: 2019-01-16)
2,680 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers