Scripts

SQL Server System Audit Report

SQL Server System Audit Report Rudy Panigas, 2018-05-25 (first published: 2016-02-02) With every technology, security is in the forefront of the minds of professionals around the world. Ensuring that your SQL Server is secure is the job of every Database Administrator (DBA). The DBA(s) needs to configure the system to minimize the “attack surface” (reducing […]

5 (1)

2019-04-18

358 reads

Blogs

New Azure “SQL Server settings” blade in the Azure Portal

By

I just noticed today that there is a new blade in the Azure portal...

Mass Backup All Sessions

By

Migrating Extended Event Sessions from one server to another should be a simple task....

The SQL Change Automation in SSMS Beta

By

Give it a try, as the beta is out. I’ve been watching this product...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Determining the length of a data type

By michael.leach2015

On this website in at the beginning of the 3rd paragraph, we have: "Length...

Merge/Split/Switch partition's affect on indexes?

By SystemlordAnubis

Hi All, Currently I have a partitioned table that is partitioned by date.  On...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers