Concurrency and transaction isolation are a prickly subject, difficult to explain with any kind of clarity without boring the reader and leaving their poor brain in a complete muddle. Therefore, it is often ignored in the vain hope it won't affect us and we can forget all about it. Well you can't ignore it any more and with SQL Server 2005 there's a whole new isolation level added to the four that already exist.
2007-07-19
2,385 reads
2007-07-18
2,936 reads
You are asked for the sa password for a SQL Server in order to perform a software upgrade. You, the DBA, don't know the password and it's not documented. Rodney Landrum provides a way out of this dilemma, demonstrating two techniques for temporarily changing the password, and then returning it to its previous unknown value.
2007-07-18
4,312 reads
Many state data-breach laws exempt encrypted data from PR-nightmare public-notice requirements, but don't let that fool you into thinking it's an easy answer to the data privacy challenge. Here's the lowdown on loopholes, caveats and options to consider when applying encryption.
2007-07-17
2,316 reads
In this article, I'll show you how to create a generic scheduler that runs on a Windows Service. The scheduler will be able to accept pluggable actions that we can develop later implementing a custom interface.
Background
2007-07-17
3,240 reads
SQL Server 2005 has greatly increased the capabilities of the platform and brought the capabilities for complex ETL packages to many businesses at an affordable cost. One of the very interesting transformations you can use in SSIS is the fuzzy grouping task and new author Brian Nordberg brings us a look at how you can use this.
2007-07-16
8,413 reads
How schema changes can propogate in SQL Server 2005's Replication Architecture.
2007-07-16
2,423 reads
2007-07-16
2,263 reads
One of the major productivity benefits that the common language runtime (CLR) offers developers of managed code is that the garbage collector (GC) makes sure any memory allocated on the managed heap is cleaned up after it is no longer needed.
2007-07-13
1,942 reads
A nice How-To from one of the most respected SQL Server MVPs.
2007-07-13
2,550 reads
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...
By Kamil
Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the...
Comments posted to this topic are about the item UNISTR Escape
Comments posted to this topic are about the item Celebrating Tomorrow
Comments posted to this topic are about the item SQL Art: I Made a...
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