SQL Server Vulnerability Assessment
SQL Server Vulnerability Assessment (VA) in SQL Server Management Studio 17.4 or later lets SQL Server scan your databases for...
2018-12-12
318 reads
Blog Posts
T-SQL Tuesday #109–Influence
This month’s T-SQL Tuesday host is Jason Brimhall. He asks everyone to write about influence, which is something that I...
2018-12-12
258 reads
T-SQL Tuesday 109: To influence and to be influenced
The last T-SQL Tuesday of this year is hosted by Jason Brimhall – one of my long-time friends in the SQL...
2018-12-12
123 reads
TSQL-Tuesday #109 – Influence Somebody
Influence Somebody Ahh, December. What a wonderful time. Snow all around (many along the eastern seaboard of the United States were hit Sunday by a snowstorm… I had 7?...
2018-12-12
8 reads
TSQL-Tuesday #109 – Influence Somebody
Influence Somebody
Ahh, December. What a wonderful time. Snow all around (many along the eastern seaboard of the United States were...
2018-12-12
157 reads
Attaching databases via a dockerfile – UPDATE
This has been bugging me for a while but I just haven’t had a chance to get around to revisiting...
2018-12-11
177 reads
Email Notifications in Azure Data Factory: Failure is not an option
(2018-Nov-27) When something goes wrong with your data transformation process in Azure Data Factory, the last thing you expect to happen...
2018-12-11 (first published: 2018-11-27)
9,569 reads
Forcing a Plan That Has a Plan Guide
The question that came up during a recent class I was teaching was: What if you have a plan guide...
2018-12-11 (first published: 2018-11-26)
1,817 reads
Get Rid of those unused indexes!
Indexes in relational databases are very helpful and increase the speed to access data. However maintaining indexes is just as...
2018-12-11
210 reads
How many Cores per Socket do I need?
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-12-11
8,875 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
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...
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