This white paper describes how to use database mirroring to increase the availability of the replication stream in a transactional environment. The document covers setting up replication in a mirrored environment, the effect of mirroring partnership state changes, and the effect of mirroring failovers on replication. In addition, it describes how to use LSN-based initialization to recover from the failover of a mirrored Subscriber database.

A story of corrupted Master database in SQL Server 2008

by Yogeshwar Phull

SQLServerCentral.com

Administration

This is a real-time production issue I faced with one of our clients

Competing with an MBA

by Steve Jones

SQLServerCentral.com

Editorial

If you are looking to move into management, do you need an MBA? It's nice, but Steve Jones notes that many people are realizing that an MBA doesn't necessarily prepare you to manage other people or lead them in a company.

TSQL Challenge 56 - Create a Sierpinski carpet using TSQL

by Jacob Sebastian

SQLServerCentral.com

T-SQL Challenges

This challnge invites you to generate a Sierpinsky carpet using TSQL

Wish you were here?

by Chris Massey

SQLServerCentral.com

Editorial

As it gets easier to attend events virtually, it's worth considering what the literal, financial value is of physical attendance.

Space Impact of Replication Snapshot Agent Job in SQL Server

by Additional Articles

MSSQLTips.com

Replication

I have noticed that available disk space on my SQL Server is getting low and I see a number of files getting generated in the replication snapshot folder. Because of these files there is a space issue on my server. Why are these files here and what can I do to resolve this problem?

Loading Data With Powershell

by Chad Miller

SQLServerCentral.com

PowerShell

Moving data in and out of SQL Server is a fundamental task for any developer or DBA. Chad Miller brings us a new way that we can load Powershell output into a SQL Server database.

How to handle empty values in a line chart in SSRS

by Additional Articles

MSSQLTips.com

Reporting Services (SSRS)

When continuous data is displayed on a chart, such as a line chart, data is displayed very smoothly. But when non-continuous data is displayed on such a chart, the chart behavior is different. The continuous data is displayed correctly, but the non-continuous data is ignored on the chart. In such cases, handling of empty points in the dataset is required to make the data continuous and displayed correctly on the chart. In this tip we will look at how to implement a solution for this problem.