Code smells versus transgressions
The oddest SQL practices can be done deliberately for good reason, but are there any that are always wrong, that are so bad that that their use should be prohibited as a matter of policy?
2016-04-04
156 reads
Editorials
2016-04-01
125 reads
The Database Transaction Unit (DTU) Decoded
In an Azure SQL Database, you pay for a certain number of DTUs, but what are these? Steve Jones explains.
2016-04-01
2,689 reads
Examining SQL Server 2016
Today Steve Jones wonders if any of you are looking at the next version of our platform, SQL Server 2016.
2016-03-31 (first published: 2016-03-29)
286 reads
Is PowerShell Intimidating?
Today we have a guest editorial from Andy Warren that asks if the rest of you are intimidated by PowerShell.
2016-03-30
188 reads
Track Your Consultants
It's possible to perform a man-in-the-middle attack against SQL Server. Steve Jones notes you should be aware these attacks could take place inside of your network.
2016-03-29
88 reads
Dexterity Matters
The individual's dexterity can impact how we use software. Perhaps we need ways to undo mistakes in various systems.
2016-03-28
65 reads
2016-03-28
176 reads
Protecting sa
Today Steve Jones talks about the issues with the sa account, and how you might protect this on all your instances.
2016-03-25
106 reads
Do Less
One way to make code run faster is to have less of it. Or ensure the code you have does less work.
2016-03-24
108 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