SQL Server Software

ApexSQL Enforce

Introduction Rules, guidelines, and standards are necessary! At least if you are involved in software development in one way or another. When you work in teams of more than one person, you almost certainly need to establish a set of rules in place in order to avoid some kind of disaster.  So what are some examples of a […]

Embarcadero Change Manager

Introduction Change Management is probably one of the most crucial tasks that developers and/or administrators face today. The risks for production systems associated with every new release or even patch are immense. And although these risks can never be completely eliminated, one can minimize them by an extensive testing period and a sophisticated change management […]

Embarcadero’s Change Manager

Introduction Change Management is probably one of the most crucial tasks that developers and/or administrators face today. The risks for production systems associated with every new release or even patch are immense. And although these risks can never be completely eliminated, one can minimize them by an extensive testing period and a sophisticated change management […]

SQL Server DBA Dashboard

Microsoft added a reporting feature to SQL Server Management Studio (SSMS) when they rolled out SQL Server 2005 SP2. This new reporting option is called “Custom Reports”. Now DBA’s and developers can expand the reporting capabilities within SSMS by building their own custom reports. Custom Reports are just Reporting Services reports rendered within SSMS. This […]

SwisSQL DBChangeManager

Product: SwisSQL DBChangeManager Publisher: AdventNet Price: Edition Price Free 0 Licence From 295$ Introduction If you are a DBA or a Database developer how many times have you needed to compare your schemas between your development, staging and production servers? Apart from comparing, you may need to apply changes to various servers. As there is […]

SQLMesh – SQL Server Search Tool

Product: SQL Mesh Personal v1.5b Publisher:SQL Mesh Price: Free Introduction Searching your database objects in your databases has become a must for you if you are database developer or database administrator. For example, you are searching for all objects containing customerID these could be tables,views,stored procedures or triggers. There is no native support in SQL […]

SoftTreeTech SQL Assistant

Executive Summary Product: SQL Assistant Publisher: Softtreetech Price: 1 developer license with 1 year maintenance and support for $149.00 Introduction If you are a database developer, I am sure you are writing hundreds or thousands of T-SQL codes per day. When you are writing your T-SQL script, I’m sure you are spending more time to […]

Spotlight on ApexSQL Diff – Server-based database comparison tool

Introduction Databases are no static objects. Most databases constantly change on a more or less regular basis. Detecting changes and synchronizing two copies of a database is a tedious and no easy task. You can either do it the hard way by reviewing both copies all by yourself object by object or you can make […]

Red Gate’s SQL Refactor Boosts DBA Productivity

Executive Summary Product: SQL Refactor (Version 1.0) Publisher: Red Gate Software Limited Pricing: Single User License: $295 Quantity and bundle discounts available Key Features and Benefits: Reformats Transact-SQL code to make it more readable. Uppercases Transact-SQL keywords to make code more readable. Script summary feature provides a high-level overview of code. Identifies unused variables and […]

Improve Database System Performance With Diskeeper

Software Spotlight Product Diskeeper 2007 Version 11.0.703.0 Publisher Diskeeper Corporation Price Different price packages are available for different requirements.Check their Web site for the latest prices. As a DBA or a DB engineer, keeping your SQL Server at an acceptable performance level should be a high priority. Most of your clients will want your database […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |