Code profiling tools can help cure most performance problems, but sometimes the problem is so severe that you'll first need to know how to wield computing's least understood tool, the debugger, before diving in with the Profiler. Brian Donahue, Crash Scene Investigator, is on hand to explain why.
In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.
In this article we are going to see how to change an ADT that is linked to columns with Unique Constraint(s) or Check Constraint(s).
I remember when Windows 3.1 started to gain widespread deployment in businesses. With all it's WYSIWYG features and multiple applications running at the same time, many people felt we'd get to a paperless office. Over a decade later I rarely see an office that doesn't have a copy machine and at least one printer. We've gotten better at shuffling bits, but we haven't gotten rid of paper.
This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup.
Mirrored backup commands in SQL Server 2005 work with media sets to minimize data loss. They can also restore a mirrored backup from a different media family.
These 34 subsystems cover the crucial extract, transform and load architecture components required in almost every dimensional data warehouse environment. Understanding the breadth of requirements is the first step to putting an effective architecture in place.
Continuing on with his great series on XML, Jacob Sebastian looks at elements of mixed types.
Paul Randal, former SQL Server Storage Engine lead, brings us a great explanation of how indexes are affected when you alter your schema.
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