GarryBargsley

Copying an Azure SQL Database

Copying an Azure SQL Database is a vital skill when managing cloud databases. Recently, a request was received from the “business”. They wanted to create a copy of an...

2020-10-21 (first published: )

249 reads

Checking your dumps!!!

No, No, not those dumps:  SQL Server Memory dumps!! Recently, I was on Slack and wondered into the #firstresponderkit channel. I am a big fan of all the First...

2020-10-13 (first published: )

620 reads

Failing SQL Agent Jobs – Part 3

It is Tuesday!!  Time for Part 3 in the series about SQL Server Agent Job Failures. This installment will show you how to setup SQL Agent Alerts and Operators...

2020-09-22 (first published: )

286 reads

Failing SQL Agent Jobs – Part 1

SQL Server Agent Jobs are one of the core features of SQL Server. Agent Jobs perform many actions, from maintenance tasks (server and database), data movement flows, replication, log...

2020-09-09 (first published: )

577 reads

Who is your Fail-Safe Agent??

Did you know it is possible for SQL Server Agent to  alert you of problems if something goes haywire with your Agent? Have you ever had an issue with...

2020-09-02 (first published: )

367 reads

Blogs

Removing a Deleted Column from a Data Masker Masking Set

By

Data Masker for SQL Server is a great tool ensuring the data you use...

Containers: A Short Rant

By

I find myself doing more and more work with containers. Yet, I also find...

Daily Coping 20 Sep 2021

By

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

Read the latest Blogs

Forums

Metadata-Data-Ratio in a table

By sean redmond

Hi all, My understanding about the structure of data within SQL Server is that...

Always On - why No failover occurred?

By onlo

Hi, I am using SQL 2016 (13.0.5888.11). Last Saturday (18th September), in non-office hours,...

Log Shipping Truncate Log File

By coolchaitu

Good Morning, I have read that taking a log backup truncates the log file....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers