2008-06-19
47 reads
Articles
White Paper: SQL Server 2008 Compared to Oracle Database 11g
Microsoft SQL Server has steadily gained ground on other database systems and now surpasses the competition in terms of performance, scalability, security, developer productivity, business intelligence (BI), and compatibility with the 2007 Microsoft Office System. It achieves this at a considerably lower cost than does Oracle Database 11g.
2008-06-19
4,197 reads
A Look at Database Mirroring
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
Using SQL Management Objects to create and restore SQL Databases.
SQL Management Objects(SMO)can be used for customized automation of various database.This article gives an implementation for SMO using C#.
2008-06-18
5,526 reads
Automate Audit Requests
In this article TJay Belt describes a process to help respond to audit requests in a timely manner
2008-06-18
2,393 reads
In The Zone
Are you in the Zone at work? Can you find those times when you are amazingly productive? Tim Mitchell asks a question in this guest editorial.
2008-06-18
57 reads
In The Zone
Are you in the Zone at work? Can you find those times when you are amazingly productive? Tim Mitchell asks a question in this guest editorial.
2008-06-18
38 reads
In The Zone
Are you in the Zone at work? Can you find those times when you are amazingly productive? Tim Mitchell asks a question in this guest editorial.
2008-06-18
49 reads
Upgrade Active/Active cluster to SQL Server 2005
This case study describes upgrading to SQL Server 2005 and Windows 2003 Active/Active cluster from and provides upgrade option pros and cons for SQL Server high availability.
2008-06-18
2,320 reads
Dynamically Generate Folders for File Output using Variables in SSIS
This article describes how to use variables in SSIS to dynamically generate folders and file placement.
2008-06-17
17,879 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
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