Backup of an Azure SQL DB downloaded outside of Azure
From a dev colleague: “Asking for a client... do you know how to get a backup of an Azure SQL DB downloaded outside of Azure?”
Short answer - You can’t…
Medium...
2019-03-05
27 reads
Will Assaf
"A connection timeout has occurred on a previously established connection to availability replica"
I previously spent some time troubleshooting this issue at one client, and then having encountered it twice more this year, I figured I'd include it in a blog post....
2019-02-01
6,194 reads
Actual Emails: What is a "soft delete"?
What's a "soft delete", and why should DBAs be aware of such behavior in tables?
So, a DELETE statement is a “hard” delete. The data is gone.
However, it is a...
2018-12-19
6 reads
No Speaker? No Problem! Host a non-traditional User Group meeting
Was honored to speak to fellow User Group leaders at the PASS Summit User Group leader meeting on Tuesday. Here's detail and links to some of the things I...
2018-11-07
6 reads
Emphasizing STEM Community Education at your SQLSaturday
Was honored to speak to fellow SQLSaturday Organizers at the PASS Summit SQLSat organizer meeting on Tuesday. Here's an outline, detail and links to some of the things I...
2018-11-06
6 reads
SQL Admin Best Practices with DMV's at the Houston SQL Server UG
Thanks to the full room of SQL enthusiasts who joined me today for the September Houston SQL Server UG Group Meeting! What a great crowd that enjoyed the hospitality...
2018-09-11
7 reads
Organizer's Thoughts on our STEM Kid's Track at SQLSaturday Baton Rouge
New this year to #SQLSatBR that was really nice for us - we hosted a kid's STEM track leveraging an existing children's education organization operated by the STEMupBR program...
2018-08-20
6 reads
SQLSaturday Baton Rouge thank yous
Hello everyone who was at #SQLSatBR this year!We had a huge early morning wave of attendees this morning that inundated our sponsors just like a cooling rain inundated us in...
2018-08-12
5 reads
SQLSaturday Baton Rouge at LSU on August 11
We're a little under a month away from #SQLSatBR!We need VOLUNTEERS.Registration is required!We still have tables of all sizes available for sponsors!Our 10th annual SQLSaturday features an 14-track lineup...
2018-07-17
7 reads
Baton Rouge User Groups Networking Night
What a great evening of interesting presentations, professional networking, and Jambalaya!We had 5 speakers last night on topics covering: Availability Groups (me), software documentation, leveraging the SQL Server community,...
2018-07-12
4 reads
Blogs
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers