Synchronizing SQL user in Database Mirroring- Abi Chapagai
Synchronizing SQL user in Database Mirroring:
If a login used in an application that involves database mirroring has SQL Login, there...
2010-08-16
2,317 reads
Synchronizing SQL user in Database Mirroring:
If a login used in an application that involves database mirroring has SQL Login, there...
2010-08-16
2,317 reads
Different High Availability Solutions in SQL Server.
While working on finding different High Availability solutions, I did quite a bit of...
2010-08-12
5,535 reads
Different High Availability Solutions in SQL Server.
While working on finding different High Availability solutions, I did quite a bit of...
2010-08-12
3,358 reads
Log Shipping By Abi Chapagai (Revised)
In SQL Server, transaction log provides an ability to recover a database to a point...
2010-07-29
2,376 reads
Registration is now open for SQLBits—The 7 Wonders of SQL Conference !!
This year its in York (Sept 30th till October 2nd).
SQLBits is...
2010-07-29
1,475 reads
Introduction
Replication is the process of copying data between two databases on the same server or different servers on the same...
2010-07-28
31,932 reads
My first guest editorial published !
http://www.sqlservercentral.com/articles/Editorial/70725/
Would appreciate any comments you have.
2010-07-15
577 reads
With query performance becoming a constant battle, its often a forgotten fact that cursors should be avoided (in the majority...
2010-07-15
676 reads
A guest editorial today from Justin H-Davies examines the change to management from the perspective of someone going through the transition. How do you deal with those former co-workers?
2010-07-15
435 reads
This is something we had to do again recently and its improved our performance and query speeds on one particular system....
2010-07-12
907 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers