SQLServerCentral Article

Auditing Your SQL Server Environment Part I

Ever been placed into a new environment and couldn't
find an ounce of documentation? This article is the first in a series that will help you make an audit of your new environment
and determine if any SQL Server login does not have a password, has a password the same as the login name or a password that is only one character long.

SQLServerCentral Article

Non-Continous Replicaton and The LogReader

Last year Andy wrote about turning off the log reader as a way to reduce the overhead on a server, primarily when you have many logreaders running. In this follow up article he talks about the downside of using this technique and how the behavior of the logreader can be "tweaked" to make using non-continuous replication a little less of a headache.

Blogs

Daily Coping 19 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 18 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo

By

I’ve added a new parameter to my permissions scripts (well, just the main two...

Read the latest Blogs

Forums

The Case for Patching

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Case for Patching

Is it possible to purge Extended Events file (target) contents?

By VoldemarG

Is it possible to purge the Extended Events file's (target) contents WITHOUT deleting the...

Flow Control Problem with multiple statements

By Paul Stasny

I am creating a function that should retrieve a numerical value from notes. This...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers