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 […]

Rudy Panigas

2019-04-18

53 reads

Blogs

Shrinking a large database with limited outage windows

By Kenneth Fisher

Yes, I realize you shouldn’t shrink your database (data files or log files), but...

Read the latest Blogs

Forums

How to test Asynchronous Failover

By Ziggy

Hi All, I have a working SQL 2016 Enterprise AAG at our primary datacenter...

SSRS not displaying image from AWS S3 bucket

By ashutosh.kumarpandey

Hi, I am creating a report which needs to show an image from AWS...

How to write MERGE statement in sql server

By kiran.rajenimbalkar

Hi Sir, How to write MERGE statement when using more then two source tables...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Stop a Login

See possible answers