Provisioning
This week Steve Jones is asking about the timeframe for you to get a new SQL Server instance? Is it substantial? Do you really know? Answer this week.
2016-12-23 (first published: 2013-05-24)
131 reads
Editorials
The Future of Auditing
Auditing is a weak point in SQL Server according to Steve Jones. He looks at a few of its flaws.
2016-12-22 (first published: 2013-12-05)
280 reads
Test Coverage
We don't test software well enough. Obviously we don't write high enough quality software, but testing should catch more issues. Steve Jones talks about how you can perform better T-SQL testing.
2016-12-20 (first published: 2013-11-12)
267 reads
Better Coding, More Savings
The way we write code impacts our users, but it can also impact our wallet, especially in cloud computing. Steve Jones wonders how many people bother to profile and test their code.
2016-12-19 (first published: 2013-05-13)
376 reads
The Toolchain for the Job?
Phil Factor ponders the use of toolchains in automation, and wonders if there might not be a better way.
2016-12-19
113 reads
A Fun Distraction
With the holiday season here, Steve Jones wonders what you'll do for fun away from work.
2016-12-16
116 reads
This is how to fail
Today we have a guest editorial from Tim Mitchell that talks about security and communications with your customers. Ultimately it pays to be open and honest.
2016-12-15 (first published: 2013-12-17)
399 reads
2016-12-14
69 reads
DBAs Need to Learn to Develop
SQL Server is growing as a platform and Steve Jones says that DBAs need to learn development skills.
2016-12-13 (first published: 2014-01-07)
623 reads
2016-12-12
95 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
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