2010-07-20
2,612 reads
Database Mirroring
Database Mirroring Using T-SQL
Part three of this series illustrates how to use a T-SQL script to create database mirroring between a principal and mirrored server.
2009-08-20
3,401 reads
Ten steps to migrate databases between servers in a .Net environment
How to move databases from one server to another with limited downtime
2009-08-17
8,138 reads
2009-07-16
3,056 reads
Database Mirroring in SQL Server 2008
Learn the basics of the Database mirroring in SQL Server 2008. Mak provides a step-by-step on how to create database mirroring. Subsequent installments will discuss how to add data on the principal server and how data is mirrored to the mirrored server.
2009-07-13
3,451 reads
2009-05-13
2,974 reads
2009-04-08
3,030 reads
2009-03-30
3,006 reads
Database Mirroring Automating Failover for Multiple SQL Server Databases With No Witness
If you don't have a witness server and your principal server goes, how do you make your mirror server the principal and bring all your databases online?
2009-03-16
2,921 reads
SQL Server 2008 Mirroring Testing
Comparison of performance of SQL 2008 mirroring to SQL 2005 mirroring.
2008-12-10
7,464 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers