One of the more interesting new technologies in SQL Server 2005 is database mirroring, allowing you to implement high availability on a database with commodity hardware. Jay Dave brings us a nice description of this technology.
2008-06-18 (first published: 2007-07-17)
15,582 reads
This is a product that we have not heard much about, but Microsoft has a Data Protection Manager, designed to help ensure you can recover your databases by centralizing your backup files. Author Jay Dave brings us a short overview on this product.
2008-05-06 (first published: 2007-05-23)
5,888 reads
Have you ever misconfigured your SQL Server's memory and been unable to start it? That happened to new author Jay Dave, who has the Data Center edition of SQL Server 2000 with a whopping 36GB of RAM. Here's how to get your instance back up and running.
2008-04-14 (first published: 2007-05-10)
8,799 reads
XML is becoming more pervasive in all of MIcrosoft's product, including SQL Server. Jay Dave brings us a short look at how one of their lesser known tools, the XML Notepad, can be used by SQL Server DBAs.
2007-07-26
3,675 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