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

3 (3)

2019-04-18

519 reads

Blogs

Cool Stuff in Snowflake – Part 9: ILIKE

By

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud...

Scalar Valued Functions in SQL Server 2019

By

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

Globally Distributed Azure Cosmos DB

By

Let’s use the Azure portal to build a globally distributed  Cosmos DB.  Before doing...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Upgrade SQL Server 2012 R2 cluster to 2016 by adding 2016 node

By kdphillips

We have a SQL Server 2012 R2 failover two-node cluster that we'd like to...

Power Shell script to add a user to sysadmin server role on many SQL instances

By SQLMantra

Can someone please copy/paste or provide me the script for this? The list of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers