SQL Server restart validation checklist

Many times there is the need to restart the SQL Server services, this could be a reboot of the server after patching, service pack installation or due to some other reason. Sometimes we may face issues after the restart for example the SPN is not registered, a database is offline etc... For the solution you can use the below standard SQL Server validation checklist after you restart your SQL services.

SQL Q&A: Shrinking, Growing and Redesigning Databases

SQL databases come in all shapes and sizes and schemas. This month, our SQL expert helps with condensing, growing and redesigning databases.

Issues with running DBCC SHRINKFILE on your data files

Why would database performance remain low and fragmentation high event though the entire database has been defragmented every night? In this tip we cover how SHRINKFILE works and some of the issues it might create.

Find the Port a Connection is Using

If you have multiple ports, this article from Mark Greenbaum will tell you which port a connection is using

Model DB

Make a 100+ Server Inventory in 30 minutes

Learn how you can generate a server inventory in 30 minutes for all of your servers with this new article from Stanley Chan.

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.

Truncate Transaction - All Databases

Script to help you to truncate TL for all databases.

Resource Governor

Policy Based Management