Hello,I posted this a while ago to several web sites. Someone found an obscure bug in it and I fixed it (newest script attached below). When I posted it to you last time, it didn't show up in any of the categories that I had checked; hmmmm? However, when I searched google, you have it […]
2007-06-13 (first published: 2004-09-28)
1,846 reads
Continuing with this series on building a database system
2007-06-13
3,926 reads
This ActiveX Script runs in DTS Designer and will clean up all unused connection objects. This allows you to rename connections at will by selecting "New Connection" and typing a new name. It also allows you to copy and paste connections then rename them. Then you can cleanup leftover connections when development is complete.
2007-06-12 (first published: 2005-01-05)
469 reads
The purpose of the SqlCredit series is to demonstrate the database design and development portion of a development project. We will build a complete, functioning, tested credit card database to illustrate the complete software development lifecycle.
2007-06-12
3,306 reads
Business intelligence (BI) and service-oriented architecture (SOA) have conflicting principles and needs. This article will show you how to make peace between them.
2007-06-11
6,335 reads
A synonym is a new object to SQL Server 2005. It is a way to give an alias to an already existing object. For example, if you have a table named SalesHistoryFromArchiveF
2007-06-08
3,890 reads
If you've ever used SQL Server 2005 Integration Services (SSIS), you will have come across raw files. Microsoft introduced them with SSIS as a mechanism for storing data on the local file system. The design of raw files enables data to be written very quickly but, unfortunately, to achieve this performance Microsoft has used a proprietary binary storage format.
2007-06-07
3,167 reads
This was just an answer in a forum in September, but I keep getting requests for the script. So I am sharing it here for anyone that could be interested: Problem: large amount of registered servers, multiple DBA's needing updated registration info, DBA workstations added or rebuilt, many servers added at once. In cases like […]
2007-06-05 (first published: 2005-01-26)
905 reads
The only way to guarantee that your business rules are always enforced for all your data is by using constraints. Learn how to use them to enforce business rules in the database.
2007-06-05
3,215 reads
In systems that require, for auditing purposes, advanced logging and reproducibility of reports between runs, a straightforward update, insert, or delete may be counter-productive. In such circumstances, a bitemporal model is necessary
2007-06-04
2,464 reads
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