Category: Database Systems

Redgate builds SSMS Ecosystem

Redgate has introduced the Red Gate SSMS Ecosystem.  You can start the installation on the home page.  There are multiple add-ins available that increase the functionality within SSMS.

Correcting Orphaned Users

When migrating databases between servers, userids will become invalidated, and users attempting to access the newly restored database will receive login failures when attempting to connect.  To correct this problem, DBAs should fix all orphaned logins after the database has…

Setting up a maintenance schedule

Setting up a new server does not have to be a daunting task; on the contrary, with well defined processes, it should be just another step before your server goes operational – this is true whether the server is a…

Monitoring SQL Server Maintenance Jobs

When setting up new servers, every DBA sets up a standard set of jobs to maintain the server. This includes tasks such as data backups (full and differential), log backups for disaster recovery, index rebuilds to maintain application efficiency, and…

Welcome

Welcome to our site.  This site is meant to serve as a central repository for database information.  We try to offer a breadth of material, so hopefully you will find useful articles and information, no matter what database or platform you…