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.
Author: John
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 REXX Test Environment or Executing your own personal EXECs
z/OS systems normally have standard ISPF/TSO program search sequences that are defined by your system programmers. This would include site specific and vendor product libraries. It is often useful to test new programs in your own libraries, or if you…
Sample REXX Coding Standards
The following is a sample set of basic REXX Coding guidelines. They are meant to provide consistent naming and component usage without being overly restrictive. Naming Standards Library Naming Standards The following describes the acceptable dataset naming standards…
Parameter Parsing in REXX
Every time I create a new REXX routine, I always use a template source program for consistency, but more than that, there are features I have developed over time which simplifies the coding effort. In this example, I will focus…
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…