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
78 reads
Blog Posts
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
36 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
26 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
6 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
1 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
6 reads
The "Go Pack"
I’ve found myself traveling quite a bit this year, with more travel on the horizon. Like many, I travel with a fair bit of technology and of course that...
2019-09-17
1 reads
The 2019 State of DevOps Report–Webinar
Tomorrow I get to chat with another giant in the world of DevOps: Jez Humble. I actually met Jez years ago at a conference, and I was honored to...
2019-09-17
13 reads
Use port forwarding to access SQL Server running in Kubernetes
A really handy feature in Kubernetes is port forwarding. This can be used to narrow down an issue when connections are failing to SQL Server running in a cluster....
2019-09-17 (first published: 2019-09-04)
998 reads
Using strace inside a SQL Server Container
So, if you’ve been following my blog you know my love for internals. Well, I needed to find out exactly how something worked at the startup of a SQL...
2019-09-17 (first published: 2019-09-03)
264 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
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
The Side Job
Comments posted to this topic are about the item The Side Job
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