Often, when developing reports in Reporting Services (SSRS), one has to mix summary information with the details. In Reporting Services, It is not difficult to provide flexible grouping and to display the detail records in a drill-down on-demand method.
It is not uncommon to experience the occasional slow down of a SQL Server database. A poorly designed database or a system that is improperly configured for the workload are but several of many possible causes of this type of performance problem.
If you are accepting a DBA position, does it make sense to work as a contractor or permanent employee?
The SQL Server community has a new event to attend in local markets. The Orlando Users Group put on SQL Saturday recently and here's a short look at how this event came about, and how you might run your own event.
If you are near Sydney, Australia, Marten Ataalla will provide an introduction to Microsoft SharePoint 2007 with the aim of evaluating its effectiveness for Enterprise Content Management (ECM).
The eleventh installment of the XML Workshop continues looking at namespaces. This time Jacob Sebastian examines default namespaces and how they impact your XML processing.
What can't be fixed by CHECKDB? Read this great entry from the former SQL Server Storage Engine lead.
A new series by Steve Jones that tackles a basic design of a few tables. Read the scenario, look over this design, and see if you can find the problems.
This handy control gives you everything you need to control how users input usernames, passwords, select servers, and choose connection types.
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