SQL Server 2005 log shipping setup using the wizard
Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish.
Easy or Hard
How should we build tools? Should they be easy to use? Or does it make sense to have some things hard to do so that only experienced used choose them. Steve Jones comments on usability and the implications of your choices.
Easy or Hard
How should we build tools? Should they be easy to use? Or does it make sense to have some things hard to do so that only experienced used choose them. Steve Jones comments on usability and the implications of your choices.
Converting Hexadecimal String Values to Alpha (ASCII) Strings
In an interesting exercise in data conversion, Stephen Lasham brings us a nice article on basic manipulations.
Seeing Double
SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.
International Features in Microsoft SQL Server 2005
This white paper introduces Microsoft SQL Server developers to the international features of Microsoft SQL Server 2005. Topics covered include an explanation of Unicode, added support for supplementary characters in SQL Server 2005, the changes in collation in different versions of SQL Server, changes in data types, performance, updates on data providers, and new international support features in SQL Server 2005 Analysis Services and Integration Services.
TSQL Spam-killer
In which Phil takes a break from a tedious bit of routine coding to build a Spam Filter in SQL.
Retrieve XML data values with XQuery in SQL Server 2005
Use XQuery scripting language to retrieve specific XML data type values in SQL Server. Learn to script and use Value() and Query() to retrieve single and multiple XML values.
Blogs
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
Forums
String_agg not working as needed
I'm trying to get this string_agg to put all the 'comments' into one result...
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers