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,476 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 Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
My knowledge of Extended Events is limited, but I am trying to capture some...
I've got something I'm not aware of performing backups of my dbs at random...
Dear all, I was just wondering: Can you change the default behaviour as illustrated...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers