Database Administration

External Article

Resumable Online Index Create and Rebuild Operations

  • Article

Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this article, Greg Larsen demonstrates resumable index operations available with SQL Server 2017 and 2019. This feature helps DBAs work around those small maintenance windows by allowing certain index operations to be paused and restarted again later.

2019-03-21

1,738 reads

External Article

What Is SQLPSX?

  • Article

SQLPSX is a useful library you can add to PowerShell to automate many DBA tasks. In this article, Laerte Junior demonstrates several useful commands and shows you how to create a SQL Agent job using this library to run daily DBA checks.

2018-11-19

3,347 reads

External Article

Extended Events Workbench

  • Article

The Extended Events (or XEvents) feature has been part of SQL Server since 2008, but many database professionals struggle to get started using it. In this article, Phil Factor demonstrates several useful Extended Event sessions that measure just one thing in each. He then provides the code necessary to parse the resulting XML into something you can use.

2018-10-29

2,206 reads

Blogs

Types of data consulting engagements and what you can expect from them

By

There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Daily Coping 6 Dec 2022

By

Today’s coping tip is to find a new way to tell someone you appreciate...

What’s next: Job search burnout

By

I was given 4.5 months notice this past June and was fortunate to find...

Read the latest Blogs

Forums

Stairways to ScriptDOM Level 4 – Finding Nuanced Patterns

By Diligentdba 46159

Comments posted to this topic are about the item Stairways to ScriptDOM Level 4...

The Availability Group Secondary Connection

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Availability Group Secondary Connection

SSRS Expression Error

By Jeffs1977

I am getting the following error when I try to use the Expression below....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers