SQLServerCentral Article

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!

SQLServerCentral Article

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.


Cloud Databases Made Simple: Creating Your First AWS RDS Instance


I recently started full time learning of Amazon Web Services (AWS). I found that...

First Time Speaking with a Mask at an Event


Over the past couple of months, I have started losing my ability to talk...

A New Word: Apolytus


apolytus– n. the moment you realize you are changing as a person, finally outgrowing...

Read the latest Blogs


Hardcoded filter vs filter by parameter

By blom0344

I am trying to set a date filter on several  large transaction tables to...

Do you listen to music when you work?

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Do you listen to music...

Slow update on temp table

By dpaproskijr

I have a job running each night starting at 4:30AM and usually finishing at...

Visit the forum

Question of the Day

Read Only Replica in SQL Server Standard

Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?

See possible answers