Migration Help

Minimal Configuration

Easily Repeating Work

There are many ways to work more efficiently, but tracking and saving your work might be one of the best.

Five Nines

Yearly Uptime of Four Nines

Removing Deleted Pages

Reusing Tools for New Purposes

Steve likes the idea of reusing one tool to do another job.

Endpoint Authentication Order

How to (Somewhat) Increase SQL Server Security

Problem Some time ago Argenis Fernandez(@DBArgenis) found and described a vulnerability that allows you to get into SQL Server with 'sa' rights. This method does not require a restart of the SQL Server service or the whole machine, the condition is a local administrator account on the server. Reminder SQL Server until 2008R2: Until SQL 2008R2, […]

SQL Server instance startup type check by SQL script

I have developed the script to check SQL Server instances startup type, sometimes we didn't know all our SQL instances startup type correctly configurated, especially we cannot distinguish the Automatic and Automatic(Delayed Start) from the direct query, the only way is querying from the registry, you can use this script in your environment to bulk […]