Unit test stored procedures in Visual Studio using an existing database or new SQL scripts

The Time to Patch

by Steve Jones

SQLServerCentral

Patching

Microsoft has spent years working on building a reliable and dependable patch process for their software. While some products have had more sporadic updates, SQL Server has moved to a fairly regular schedule. Not quite a predictable "Patch Tuesday" schedule, but you can count on a CU arriving every month or two for SQL Server. […]

SQL Server Best Practices for Data Quality

by Additional Articles

MSSQLTips.com

Data Quality

Accurate data is imperative for an organization to conduct cost effective decision making. Like everything else, change is constant for your data. There is a need to cleanse and validate data when received and on a regular basis. Unfortunately, cleansing and validating data is difficult with the native SQL Server toolset. How do we leverage the SQL Server tool set to achieve these goals?

Exporting Data with PowerShell

by Steve Jones

SQLServerCentral

Recently I had the need to help someone download some data from SQL Server as a part of an automated process. In this case, the person wanted to use PowerShell (PoSh), since they were performing a few other actions with PoSh as well. This article is a short tutorial on exporting data from SQL Server […]

Finding Motivation to Learn

by Steve Jones

SQLServerCentral

Career Growth

There isn't a good excuse to avoid investing in yourself.

Building a Countdown Timer with PowerShell

by Additional Articles

SimpleTalk

Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that can create a window for a countdown timer.

Using SQL Change Automation in SSMS to Track Static Data Changes

by Additional Articles

Redgate

SQL Change Automation 4.1 now allows users to develop static data changes from SQL Server Management Studio.

Happy New Year 2020

by Steve Jones

SQLServerCentral

Misc

Happy New Year from SQLServerCentral and Redgate Software.

SSIS Catalog Environments– Step 20 of the Stairway to Integration Services

by Andy Leonard

SQLServerCentral.com

In this next level of the Stairway to Integration Services, we look at the SSIS catalog environments and how they help you manage your package parameters.