Log Shipping and Logins Establishing a failover server for your SQL Server? First things, first: strategize on your logins. By Eric Johnson 06/28/2010 So you decided to set up log shipping in ...

Log Shipping in SQL Server has been around for a while and still provides an easy method for redundancy and load balancing. It uses standard backup and restore technology to ship backups to a ...

The recent versions of Microsoft SQL Server include several high-availability solutions like failover clustering, database mirroring, log shipping and replication.

For our new production environment, we're going to be using SQL 2005 and do log shipping from our main machine to a secondary machine. Part of this environment will include a migration process ...

When Managed Instance was introduced, DBAs everywhere were thrilled mainly because features like SQL Server Agent jobs and cross-database queries were supported in a PaaS offering.

I'm seeking help from the well of SQL Server gurus on this board. My question involves using replication in SQL Server 2000. First let me give you top level overview of what I'm been asked to ...

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target.

Delayed durability offers something that many SQL Server professionals have wanted for years-the ability to disable transaction logging. Why turn off the transaction log? You can accelerate ...

SQL Server transaction logs A transaction log is a sequential record of all changes made to the database while the actual data is contained in a separate file.

Java, SQL Server and JDBC tutorial In this Microsoft SQL Server and JDBC tutorial, you'll learn how to connect to a Microsoft SQL Server in Java using JDBC. The steps are relatively straightforward: ...