Many of my clients need to make data that lives on one server available on another server. There are many reasons for such a requirement. You might want to speed up cross-server queries by providing a local copy of the data. Or you might want to make the data available to resource intensive reporting queries without impacting the OLTP load, maybe even with an intentional delay so you're always reporting against complete days only. Finally, you might be looking to implement high availability. In all these situations, SQL Server Replication is a viable option to look at when planning for the implementation of such a requirement.

Developing for Delivery, a Practical Example

by Additional Articles

SimpleTalk

Database Deployment

Richard Morris interviewed Michael Stoop, a database developer at Calvi, Europe's leading provider of Telecom Invoice Management software. The discussion focused on how Calvi transformed their database delivery process to accommodate massive database growth, statutory regulations, and developments in their application. Here's their story.

SQL in the City Pasadena 2013

by Press Release

Redgate

SQL in the City

SQL in the City is coming to Pasadena on October 9. Register for a full day of free SQL Server training the Red Gate way. Top tips and best practices for SQL Server database development and administration will be presented by SQL Server MVP experts, including Steve Jones and Grant Fritchey. You’ll also see Red Gate tools in action and have the chance to network with other data professionals.

An Interview with Allen Kinsel, PASS Board Candidate

by Steve Jones

SQLServerCentral.com

Interviews

Allen Kinsel is running for the board of directors of PASS. He took a little time to answer some questions from Steve Jones

Dating Your Employer

by Andy Warren

SQLServerCentral.com

Editorial

Looking for a new job? Want to pick the best one? Your employer probably feels the same way. Andy Warren talks about how your interview is more like dating than you think.

Extended Properties Introduction

by Adam Aspin

SQLServerCentral.com

Metadata

Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties

Generating Random Numbers in SQL Server Without Collisions

by Additional Articles

MSSQLTips.com

generate numbers

From time to time, I see a requirement to generate random identifiers for things like users or orders. People want to use random numbers so that the "next" identifier is not guessable, or to prevent insight into how many new users or orders are being generated in a given time frame, but they don't want to run into any duplicates. We can trade a bit of disk space and relatively predictable (but not optimal) performance for the guarantee of no collisions, no matter how many random numbers we've already used.

Red Gate will be exhibiting at SQL Server Live! Orlando

by Press Release

Redgate

Events

SQL Server Live! is coming to Orlando November 18-22. SQL Server Live! provides comprehensive education and knowledge share on SQL Server database management, data warehouse/BI model design, performance tuning, troubleshooting and more.

Scripting

by Steve Jones

SQLServerCentral.com

Editorial

Scripting will become a more important skill in the future, for a variety of reasons.

A Practical Guide to Microsoft Hyper-V Replica: Part II

by Additional Articles

SimpleTalk

Virtualization, containers, and k8s

A Hyper-V replica installation provides rapid disaster-recovery by asynchronously replicating a VM running at a primary site to a replica site. Know how to prepare for something to go wrong at the Primary Server/Site? In this article Nirmal Sharma presents the Replication options for a Replica Virtual Machine with a focus on Hyper-V Failover.

The Fundamentals of SQL Server Replication by Sebastian Meine

Developing for Delivery, a Practical Example

SQL in the City Pasadena 2013

An Interview with Allen Kinsel, PASS Board Candidate

Dating Your Employer

Extended Properties Introduction

Generating Random Numbers in SQL Server Without Collisions

Red Gate will be exhibiting at SQL Server Live! Orlando

Scripting

A Practical Guide to Microsoft Hyper-V Replica: Part II

Blogs

AI: Blog a Day – Day 6: Embeddings – How AI Understands

The Book of Redgate: Mistakes

ADF Pipeline Debugging Fails with BadRequest – The Sequel

Forums

Why End-User Testing Is Even More Important with AI

Dynamic Unpivot

Writing as an Art and a Job

Question of the Day

String Similarity II