SQL Server 2005 has greatly expanded the capabilities of SQL Server in many different areas. One of those that has matured greatly is the integration of XML data inside SQL Server. Longtime writer and guru Michael Coles brings us the first part of a two part series on XML ion SLQ Server 2005.
2008-01-24 (first published: 2007-02-19)
13,197 reads
2008-01-24
50 reads
2008-01-24
56 reads
2008-01-24
64 reads
This article explores the data types and methods used for storing BLOBs (Binary Large Objects), such as images and sounds, inside SQL Server.
2008-01-24
4,577 reads
Data governance is NOT a methodology. Data governance is about authority and discipline over the management of data but not THE method in which the data is governed.
2008-01-24
1,323 reads
Continuing on with his series on SQL Server 2005 Compact Edition, regular author Jacob Sebastian takes a look at how Visual Studio fits into your SQL CE project.
2008-01-23
3,170 reads
We crossed 400,000 members yesterday and it's a great achievement for us. As a celebration, we've decided to give out some prizes. Read on to see if you're one of the lucky winners.
2008-01-23 (first published: 2007-01-23)
4,032 reads
Information governance is defined by Larry English as the act or process of leading, directing, controlling and assuring that information is managed effectively as an enterprise resource. (PDF download)
2008-01-23
1,140 reads
Paul Randal talks about the new spatial data types and their indexes.
2008-01-23
2,907 reads
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
By Steve Jones
Recently I had someone internally ask about whether SQL Source Control supports Git Hooks....
I'm running a group MSA for the database engine and SQL Agent in a...
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Comments posted to this topic are about the item Encoding Strings
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