Steve Jones

DR as a Service

It's not the first task when I start a new job, but often as a DBA or developer, I usually ask about Disaster Recovery (DR) plans sometime within the first six months. If I'm a DBA, of course I need a plan. If I'm a developer, however, I still need to understand how this might […]

2020-10-01

28 reads

Editor Tips and Tricks for Azure Data Studio

Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how ADS works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azure Data Studio Using Azure Data Studio with TFVC Using Azure Data Studio with […]

5 (6)

2020-09-30

1,206 reads

Blogs

PASS Virtual Summit 2020 Conference Sessions

By

Whether you are a SQL Server Database Administrator or Infrastructure Architect, you should be...

Running Express Edition in a Container–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

How SQL Server stores data types: sql_variant

By

This post looks at a curious data type that isn’t really a data type....

Read the latest Blogs

Forums

Move file to Archive after copy and delete the files

By SSCNewbee

Hi All, I have a data pipeline to get the files from an SFTP...

DLOOKUP in SQL

By MannyR

I tried looking up a comparable function in SQL to the DLOOKUP in ACCESS. ...

Stacked instances of SQL 2017 Express, unable to complete a distributed txn

By Ken-204087

I have two instances of SQL 2017 Express installed on a given computer. Computer...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers