New Article: Exploiting SQL Server via CONTROL SERVER permissions

I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...

How to setup a task to delete the old backup files or log files from the server ?

Cleaning up the servers disks on daily basis is very important task for smooth functioning of servers.We have seen many...

Why We Follow Best Practices

Why We Follow Best Practices
Best Practices

There are many reasons why we follow best practices. My own reasons have changed over...

How to remove new line character from string using SQL ?

In a varchar column some of the entries were showing space in the left side and even after using the...

The Daily Status Meeting

For the past six months or so I’ve hosted a daily status meeting for a large project. It started out...

SQL Saturday 108 in Redmond was a great success

Thanks to the organizers and volunteers for making SQL Saturday #108 an overwhelming success.  I’m just wrapping up the day...

SQL Saturday 108 (Redmond, WA) Session Files

SQL Saturday 108 (Redmond, WA) Session Files
SQL Saturday 108 Replication Magic
Session files are now available for download. The zip file...

A Script A Day - Day 20 - User Database VLF Count

Today’s script will execute DBCC LOGINFO for all user databases.  This is a script I use to monitor the number...

A Script A Day - Day 19 - Remove Virtual Subscriptions

Today’s script is to help replication performance.  It was something I learned from my resident replication expert Paul Anderton.  Below...

Powershell Get-EventLog and Event Log messages

This post explains how to list Event Log Messages with Powershell Get-EventLog  , on multiple servers and output the results to...