Extract CLR Assemblies from SQL Server
I’ve run into a few situations that required examining the existing CLR assemblies on a server. Whether I needed to...
2012-03-02
3,178 reads
Eric Humphrey
Extract CLR Assemblies from SQL Server
I’ve run into a few situations that required examining the existing CLR assemblies on a server. Whether I needed to do a comparison between two versions to make sure...
2012-03-02
418 reads
Split Typeperf Output in More Managable Chunks
I really like using typeperf for perfmon counter collection. It allows me to save a collection of counters to monitor...
2012-02-17
1,415 reads
Split Typeperf Output in More Managable Chunks
I really like using typeperf for perfmon counter collection. It allows me to save a collection of counters to monitor and store those readings in a csv file for...
2012-02-17
45 reads
Automate CPU-Z Capture to Check for Throttled Processors
Severalprofessionalshaveposted about checking whether or not your processors are running at full speed by using CPU-Z. Some recommendations are to...
2012-02-16
1,137 reads
Automate CPU-Z Capture to Check for Throttled Processors
Several professionals have posted about checking whether or not your processors are running at full speed by using CPU-Z. Some recommendations are to check your servers every couple of...
2012-02-16
44 reads
Script level upgrade for database ‘master’ failed
A few weeks ago one of our clustered server nodes blue-screened and when it came back on SQL refused to...
2011-11-09
4,483 reads
Script level upgrade for database ‘master’ failed
A few weeks ago one of our clustered server nodes blue-screened and when it came back on SQL refused to start. I started digging in and this is what...
2011-11-09
825 reads
Script level upgrade for database ‘master’ failed
A few weeks ago one of our clustered server nodes blue-screened and when it came back on SQL refused to start. I started digging in and this is what...
2011-11-09
11 reads
Sync SSMS Tools Pack Across Computers Using SyncToy
My favorite and most used feature of the SSMS Tools Pack is the query history. This feature has saved me...
2011-10-06
1,141 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