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.
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.
Double Check
Steve Jones looks at the positive side of someone else doing your work when you're on vacation. There's an interesting benefit for the company.
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#.
Automate Audit Requests
In this article TJay Belt describes a process to help respond to audit requests in a timely manner
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.
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.
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.
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.
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Jabatan Imigresen Certified Translators: Trusted Support for Official Documents
When preparing documents for immigration in Malaysia, accuracy and compliance are essential. Working with...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers