Andy Warren

Default Values and Named Parameters for Stored Procs

Are you using default values for your parameters? Using named parameters when you call the proc or passing the values by ordinal? Should you be? Andy thinks 6 out of 10 of our readers will agree with his point of view, we'll be a little more conservative and guess that 5 of out 10 will be closer.

5 (1)

2003-01-08

8,183 reads

Alternatives to SQL Backups

All of do us regular backups. Ok, all of us SHOULD do regular backups. In this article Andy comments on why having a backup plan isn't enough and why you should look at some other options for when you need to fix data errors. This really speaks to the goal of minimizing down time using low tech, readily available solutions. If you're not interested yet, we'll add this - one of the alternatives he suggests is Microsoft Access!

2002-10-28

8,252 reads

Snapshot Replication

Now that Andy has converted Steve Jones to a DMO believer we asked him to spend some time discussing replication. In this kick off article he discussion snapshot replication at a very high level - and looking for reasons to use it. This article isn't about how to do snapshot replication, it's about whether you should.

5 (1)

2002-10-10

11,723 reads

Blogs

What you need to know About Azure SQL backup

By

Most of DBA are coming from On-premise Database Servers they know very well How...

Social: Respecting Names

By

This is a non-technical post, and my opinion. If you don’t want to read...

Proud to present at this year’s VMworld 2020 conference

By

I’m thrilled to support and participate in this year’s VMworld 2020 conference, which is...

Read the latest Blogs

Forums

Best SQL Course in 2020

By Ankitdixit

Hello All, I want to learn the SQL course but I want to gain...

SSIS DB migration from one server to other server.

By Srinivas Sista

Summary: We had migrated SSISDB from SQL Server version 11.0.6260 to SQL Server version...

Permission to view SQL jobs in SQL Server 2017

By Srinivas Sista

Hi, I'm using SQL Server 2017, I need to give developers only to view...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers