New to SQL Server 2005 is the Dedicated Administrator Connection (DAC), which provides a way to ensure you can always connect to your server. No more getting locked out of a busy server as could occur in prior versions. Wayne Fillis brings us a short tutorial on this handy new feature.
As DBAs we should be very detail oriented, but Steve Jones talks about some challenges with keeping up with your tasks and projects and some software that might help.
As DBAs we should be very detail oriented, but Steve Jones talks about some challenges with keeping up with your tasks and projects and some software that might help.
In this article, David Leibowitz compares the performance of the prerelease of Microsoft's SQL Server 2008 Reporting Services to SSRS 2005. While it is clear performance improvements have been made for report automation, developers might have differing opinions on the new Report Designer.
Part 15 of this series examines what cost is paid when tables are separated into multiple databases on the same server.
Steve Jones thinks that programmers should be able to negotiate any deal they can and Joel Spolsky has no reason to be upset.
Steve Jones thinks that programmers should be able to negotiate any deal they can and Joel Spolsky has no reason to be upset.
Steve Jones thinks that programmers should be able to negotiate any deal they can and Joel Spolsky has no reason to be upset.
New Author! Don Peterson writes his first article for us and explores why he considers XML to be...bad! There are some interesting points made here and if you've haven't thought about what XML means to you as a DBA, it's a subject worth spending some time on.
How often do you worry about your database size and free space? Steve Jones asks how you administer your SQL Server database space this Friday.
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
I was messing around performing investigative work on a pod running SQL Server 2025...
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Comments posted to this topic are about the item Encoding Strings
Comments posted to this topic are about the item Deep Learning and Craftsmanship Matter
Comments posted to this topic are about the item Building a Real-Time Analytics Pipeline...
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers