Compression in SQL Server: COMPRESS and DECOMPRESS
On Twitter recently, I asked: Does anyone I know use the COMPRESS and DECOMPRESS features in T-SQL? To those who replied in the affirmative, I asked: What made you...
2019-12-18
143 reads
Blog Posts
Database Reliability Engineering (22 minute video)
I was fascinated yesterday to come across the term, “Database Reliability Engineering,” which I hadn’t seen before. In this 22 minute whiteboarding session, I talk about why we need...
2019-12-18
5 reads
Distributing Jupyter Notebooks
If you’re working with the Microsoft Data Platform, you should be, at the least, exploring Azure Data Studio as a new tool in your toolbox. One of the big...
2019-12-18 (first published: 2019-12-09)
335 reads
Resetting an Azure SQL Database Admin Password
This is likely something that most people know, but it was a bit confusing for me. This post is really here to remind me and help cement this in...
2019-12-18 (first published: 2019-12-05)
2,973 reads
SSIS Layout Formatting Options
Most folks I know go to one extreme or the other when it comes to the visual layout of SQL Server Integration Services packages: either they don’t care a...
2019-12-18
823 reads
Trace Flags That Are Now Defaulted Behaviors in SQL Server
If you have ever attended one of my performance tuning sessions, you know I tend to talk about trace flags. Trace Flags can help fix performance issues and some...
2019-12-18
344 reads
Using a PoSh variable in a string- #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is something I haven’t quite understood or...
2019-12-18
98 reads
Viewing Azure SQL DB security with sp_AzSQLDBPermissions
A few months back I put the Azure SQL DB version of my permissions script into beta. I’m not sure ... Continue reading
2019-12-18
54 reads
Configuration Manager is Corrupt
So you come along one day to validate some service configurations for the SQL Server services and instead of the SQL Server Configuration Manager opening as expected, you are...
2019-12-17
176 reads
Configuration Manager is Corrupt
So you come along one day to validate some service configurations for the SQL Server services and instead of the SQL Server Configuration Manager opening as expected, you are...
2019-12-17
4 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
100 % Falschgeld verfügbar. £, $, €. WhatsApp: +1 (530) 590-5928
Wir liefern perfekt reproduziertes Falschgeld mit Hologrammen und allen verfügbaren Sicherheitsmerkmalen, das weder optisch...
100% FOLSKA SEDLAR TILLGÄNGLIGA. £,$,€ Whatsapp:+1(530)590-5928
Vi levererar perfekt reproducerade förfalskade pengar med hologram och alla tillgängliga säkerhetsfunktioner som är...
NCONOTE CONTRAFFATTE 100% DISPONIBILI. £, $, €. WhatsApp: +1(530)590-5928
Forniamo banconote contraffatte perfettamente riprodotte con ologrammi e tutte le caratteristiche di sicurezza disponibili,...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers