Editorials

Deploying SQL Server Automatically

I've had to install SQL Server many times over the years. Often it has felt that most of these installs were one-offs, a dev server, a new QA instance, a production server for a brand new application. A few times I've had to recover from disaster, including restoring master, but often, I just installed SQL […]

2 (1)

2021-07-31

95 reads

Define All The Steps Up Front

After 23 years in one place, I'm pulling up stakes and moving. We're selling our house in one state in the US and we're buying a house in another state about half a continent away. To say it's a stressful and exhausting process is an understatement. The worst part is that no one has defined […]

2021-07-24

113 reads

The Danger of Management Access

First we had the Solarwinds hack, and now we have a Kaseya ransomware epidemic. It seems the criminals are moving up the stack. We used to see physical attacks on tapes and keyboards, then we saw OS level attacks. Now we seem to be getting to the management layer for software that is used to […]

2021-07-21

136 reads

Blogs

Architect a disaster recovery for SQL Server on AWS: Part 1

By

  New blog post - Architect a disaster recovery for SQL Server on AWS: Part...

Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.

By

New blog post - Seamlessly migrate large SQL databases using AWS Snowball and AWS...

Daily Coping 3 Aug 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

How to determine whether SSIS is being used?

By jankovic

Hello I've inherited some dev environment which looks like was abandoned, but I'd like...

xml output from sql query

By Bruin

The script runs but gives me "no data to export"  I see data in...

Dynamically Update A Parameter to Pass to Another Report

By RedSoxRay

I have an existing SSRS Report which displays the following: UserName, UserID, DOB Bill...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers