Security Audit
Of late I have seen a lot of questions on how to audit the logins and users on each SQL...
2010-03-19
1,778 reads
Blog Posts
SQL Log Shipping – by Abi Chapagai
SQL Server 2008 High Availability Solution: Log Shipping
In SQL Server, transaction log provides an ability to recover a database...
2010-03-19
1,696 reads
SSRS - Formatting Mutiple Columns
Often when designing reports you are required to apply the same formatting to multiple columns in one table or matrix....
2010-03-19
1,573 reads
Tally Table CTE
Now that I have several posts on what you can do with a Tally table, I figured I'd share my...
2010-03-19
5,151 reads
When It "Has" to Use SA...
As an infrastructure and security architect, I cringe any time any one mentions the following:
Domain AdminrootsaThose accounts can do anything...
2010-03-19
646 reads
Windows Themes (We need a PASS Theme!)
I imagine most of us change our wallpaper on the desktop from time to time. Frivolous but fun, a simple...
2010-03-19
865 reads
Changing Storage for your SQL Server
A friend pinged me the other day with a question on SQL Server storage. He works as a Windows consultant,...
2010-03-18
2,204 reads
Need to Persuade Your Manager or Co-Worker to Your Point of View?
At one time or another, each of us has been in a position where we need to persuade a manager,...
2010-03-18
558 reads
New Goal: Security Presentation for End Users on Social Media
Cross-posted from the Goal Keeping DBA:
In recent days I’ve seen folks jump on Facebook groups and become fans of pages...
2010-03-18
694 reads
Script: Backup All your Databases
We all know the importance of taking regular backups of our SQL Server databases. This is a useful little script...
2010-03-18
1,714 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