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

571 reads

Blogs

SQL Server 2008 and 2008 R2 is end of life on 9 July 2019

By

Next month, Microsoft is ending five years of extended support on SQL Server 2008...

Understanding Columnstore Indexes in SQL Server Part 1

By

Recently I reviewed filtered indexes, this time let’s look at columnstore indexes. These indexes...

Basic User Functions in R

By

As I’ve been learning more about the data platform, I’ve been exposed to some...

Read the latest Blogs

Forums

Compare Dates

By ssc_san

Hello All, create table #app1 ( custID INT, Seqs INT, eff_dt datetime, term_dt datetime...

StoredProc insert and update multiuser issue

By jason.havelock

Happy to day to all, I am looking into an issue with a stored...

New to SQL - difficulties in SUMing only certain rows of a column, other misc.

By Kai

This is for SQL Server 8.0 and I'm using MySQL Workbench on this.  ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers