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.
Category: Microsoft SQL Server
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…