OK….so I’m in the middle of a very interesting Effective Dating project…basically we’re dealing with some tables that only store current data, but there is a need for future-dated data as well. Because the base table can’t hold that data...
This video demonstrates how to improve the performance of the data flow in an Integration Services package. In this video, you will learn how to tune the following phases of the data flow: Extraction, Transformation, Loading
I want to know how Windows PowerShell can help me as a SQL Server DBA.
Software maintenance is often required when purchasing software packages. But do the vendors deliver value for this charge? Steve Jones has a few thoughts on the subject.
Software maintenance is often required when purchasing software packages. But do the vendors deliver value for this charge? Steve Jones has a few thoughts on the subject.
Software maintenance is often required when purchasing software packages. But do the vendors deliver value for this charge? Steve Jones has a few thoughts on the subject.
Continuing with setting up a 2 node SQL cluster under MS Virtual server 2005 Ent R2 SP1, Perry Whittle looks at the SQL configuration in this article.
Feeling his age a bit, Steve Jones asks you about yours in this Friday's poll. Where do you think you are in your career as a technologist?
We have a sample chapter available from The Data Access Handbook, written by experts at DataDirect Technologies.
Get an overview of how to set up and use XML Web Services using SOAP/HTTP inside SQL Server 2005 (formerly known as "Yukon"). Illustrative examples are included. To get the most from this paper, you should have a basic understanding of Web service technologies including HTTP, SOAP, and WSDL.
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
Comments posted to this topic are about the item UNISTR Escape
Comments posted to this topic are about the item Celebrating Tomorrow
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers