Scripts

Audit Users logging in using "sa" or service accounts

Security is probably one of a production DBA's most important tasks and if developers use application or service accounts to run queries in your production environment you need to identify then and prohibit it. I notice some unwanted activity after staring a new job and decided to create a script that notifies me via email when […]

2019-06-26

6 reads

Generate views to correct the column collation on a target DB's tables automatically

You find you are querying a vendor supported database where you're not allowed to make any collation changes, and which has a weird collation setup: default DB collation that matches your server and other databases all character related columns are explicitly a different collation that does not match your DB or server collation Rather than […]

2019-06-26

3 reads

Blogs

What about orphaned windows users?

By

I should start off by mentioning that this post is applicable to sql server...

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...

Read the latest Blogs

Forums

tuning sql statement which ran for an hour

By vsamantha35

Hi All, Trying to delete rows from a table. it took 1 hour. It...

Frequent disconnectity from Application

By pols

Hi , We have two app servers Aap3 & Aap4.(Microsoft Dynamics app). The Database...

How can I change the credit card numbers during the INSERT ? (e.g.I want all 0s)

By Gamleur84

Hi, I have an application pushing data from source SQL database to an external...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers