Restarting a Sequence–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

SHUTDOWN SQL Server

Recently a friend by the name of Chris Bell (blog | twitter) wrote about an easy way to disrupt SQL Server....

Actual Emails: What is a "soft delete"?

What's a "soft delete", and why should DBAs be aware of such behavior in tables?
So, a DELETE statement is a “hard” delete. The data is gone.

However, it is a...

Infrastructure matters, even in the Cloud

I am still amused by terminology in the Information Technology field. Words like “Kubernetes,” “containers,” and the BASIC keywords PEEK...

MongoDB – Basic Commands

We discussed about MongoDb installation and startup. I highly recommend to go though the training session which will provide a detail...

SQL Server Availability Group FailoverDetection Utility PowerShell Function Improvements – Named Instances, Archiving Data, Speed

In my last post I wrote about a new function for gathering the data and running the FailoverDetection utility by...

SSIS Catalog Automatic Log Cleanup

Built into the SSIS catalog is a mechanism that can automatically purge log data after a set period of time. In this post, I’ll show you how to set...

T-SQL Tuesday Participation Over the Years

Loads of TSQL Tuesdays

Years ago the TSQL Tuesday party was started by Adam Machanic (b|t). The premise of the monthly event...

T-SQL Tuesday Participation Over the Years

I have personally participated in quite a large number of these TSQL Tuesday events - despite not being every single one. This is a roundup of my personal participation...

Turbo Charged Staging\Caching Tables With In Memory OLTP

Since SQL 2012 some really awesome new technologies have been introduced into the engine that are massively underused. Everyone is...