Untrusted FK's demo + ADS notebooks
Back in 2012 at SQLSaturday Pensacola, I did a lunch-time lightning talk on indexing, which was supposed to have a big finale on how FK's could silently help with...
2019-05-29
6 reads
Blog Posts
12 Ways To Rewrite SQL Queries for Better Performance
Watch this week's video on YouTube
Over the past several week's I've been exploring ways to rewrite queries to improve execution performance.
I learned a lot of these techniques over time from...
2019-05-28
7 reads
12 Ways To Rewrite SQL Queries for Better Performance
Watch this week's video on YouTube
Over the past several week's I've been exploring ways to rewrite queries to improve execution performance.
I learned a lot of these techniques over time from...
2019-05-28
29 reads
CREATE DATABASE failed on SQL Server FCI cluster: Only formatted files on which the cluster resource of the server has a dependency can be used
Problem Today, I have a request to create a new database on two-node SQL Server 2016 failover cluster instance, which is in an active/passive configuration. I connected to the...
2019-05-28 (first published: 2019-05-14)
3,569 reads
Demo: Predictive Modeling using R and SQL Server Machine Learning Services
Late last year, I wrote a series of articles about Predictive Modeling using R and SQL Server Machine Learning Services. At the time, I thought MLS was an underutilized...
2019-05-28
16 reads
Deploying a stand-alone SQL Server Instance into a Kubernetes Cluster
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2019-05-28 (first published: 2019-03-14)
1,136 reads
Deploying SQL Server to an Azure Container Instance using Terraform – Part Two
In a previous post I went through how to deploy SQL Server running in an Azure Container Instance using Terraform. In that post, I used hardcoded variables in the...
2019-05-28 (first published: 2019-05-15)
305 reads
Recover Database using Stellar Repair for MS SQL
One of my friends client has got an issue with his SQL Server. A weekly database integrity check has reported a corruption for one of his databases. The corruption...
2019-05-28
17 reads
Speaking at Events
G’day, I recently got the opportunity to speak at the “PASS Marathon, The New World of Data Privacy”. I had not spoken at a virtually event for quite some...
2019-05-28
5 reads
A Lost Day
I’m writing this in advance, as I usually recommend for all bloggers, because this is a lost day for me. I’m not going to experience May 27th, 2019 on...
2019-05-27
28 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
The Large Encoded Value
Comments posted to this topic are about the item The Large Encoded Value
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers