Network Protocols

SQL Server Database Growth and Autogrowth Settings

It's easy to create a database nowadays with point-'n-click, but if you've left your database's autogrowth settings at their default, you may hit problems in the future. Why? What to do about it? Read on!

Table space usage 3

Total Database Information At Your Fingertips Part - II

This article will help to get some basic information from your databases that may help you in different situations.

Table space usage 2

DBCC CHECKDB

Database recovery model change notification report for SQL Server

The database recovery model plays a crucial role for the recovery of a database. With several DBAs having access to a SQL Server instance there are bound to be changes that are not communicated. In this tip we cover a monitoring solution we deployed at our company to alert the DBAs if a database recovery model is different than what it is expected.

Standardize SQL Server Installations with Configuration Files

If you have a requirement to install multiple SQL Server instances with the same settings, you most likely want to do it without following the numerous manual installation steps. The below tip will guide you through how to install a SQL Server instance with less effort.

SQL Server 2008 - Disabling Full Text Search

Wait Time - Query\Client

Script helps to get the client and queries that generate longer waiting time.