So you decided to set up log shipping in order to establish a failover server, but what's next? Log shipping only takes care of keeping a user database in sync from one server to the other. In the ...

Q: We use a lot of distributed transactions and we are now investigating database mirroring to provide high availability to one of our critical databases. During our testing, we discovered that ...

I'm looking for some insight into implementing replication with a SQL 2005 Standard database based on our needs as well as the fact that one major replication type is ...

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target. Logging is an essential feature for any application, as it is ...

SQL Server 2005 also promises better performance. I didn’t run performance benchmarks for this review, but in addition to allowing DBAs to partition the database to balance load, Microsoft has done a ...

I have the option to set the SQL services to run with different user accounts, basically Domain User Account or a Local System account.<BR><BR>Now as I understand it a Domain User Account is often ...