Vendors/3rd-party Products

Securing SQL Server with DoD guidelines

  • Article

Making sure your SQL Servers are secured against malicious users is difficult. The United States Defense Information Systems Agency (DISA) publishes a set of guidelines for organizations securing different pieces of software that connect to the US Department of Defense’s networks (DoD). Whether you’re working with the DoD or not, these Security Technical Implementation Guides (STIGs) are a good resource to help you understand potential security vulnerabilities and mitigate them.

2021-02-22

Is Tempdb Causing a Bottleneck?

  • Article

One of your SQL Server instance shows a major dip in performance or throughput, affecting all the user databases. You notice that the slow interludes coincide, as if orchestrated. On investigation, it appears that several transactions running over that period were using a lot of space in tempdb. However, which of them, if any, are causing the tempdb bottleneck, and why?

2021-01-26

Blogs

Using SQL Compare for One Procedure

By

A customer recently was concerned about the time to run SQL Compare for a...

Daily Coping 11 June 2021

By

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

Azure SQL Database – Secondary Database and Tiers

By

On the theme of failover groups let’s do a quick recap on my environment....

Read the latest Blogs

Forums

Tracking, Privacy, and Lots of Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Tracking, Privacy, and Lots of...

Instructions for removing AlwaysOn AGs and underlying Windows cluster

By doodlingdba

Hi there I want to remove AlwaysOn and the underlying Windows Cluster from a...

CU 24 patching issue.

By EasyBoy

We are having an issue applying CU24 patches on SQL 2017. The version of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Write-Debug

See possible answers