Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I started to dig into JSON queries recently,...
2020-12-25 (first published: 2020-12-16)
416 reads
At the end of 2019, Mala (b|t) invited us to write about the gifts we’ve gotten during the year. I’ve decided to try to make this yearly habit. This year...
2020-12-25 (first published: 2020-12-16)
114 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-12-24
30 reads
I’m making my bid. I don’t know this brand needs to continue, or that it will, but I’d like to hold this for posterity, at least in an interim...
2020-12-24 (first published: 2020-12-18)
415 reads
Here's a SQL Puzzle for the festive period. 2020 has been a year of many things but amongst it all, it has been the year of chess. The combined...
2020-12-24 (first published: 2020-12-15)
536 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-12-23
23 reads
Announced last week is a major new feature for Power BI: you can now use DirectQuery to connect to Azure Analysis Services or Power BI Datasets and combine it...
2020-12-23
8 reads
“It was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness, it was the epoch of...
2020-12-23
47 reads
At first glance, the question of how many rows are estimated from a table variable is easy. But, is it really that simple? Well, not really. To dig into...
2020-12-23 (first published: 2020-12-15)
423 reads
Recently I wrote about ignoring comments in SQL Compare. That seems like something I want to do in all my projects, so I went looking for how to set...
2020-12-23 (first published: 2020-12-14)
179 reads
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
I have a SQL Agent job for backing up a set of Analysis Services...
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Comments posted to this topic are about the item 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