January 2008

  • SAN considerations for your SQL Server environment

    SANs surpass the performance of locally attached storage for its high availability and high performance access to data. In this tip, Contributor Hilary Cotter highlights what you need to consider w...30 Jan 2008

  • Make changes to SQL Server stored procedures with batch editing

    Many common SQL Server database tasks are performed with stored procedures. Here's a step-by-step process for editing a group of stored procedures at one time, whether you're using SQL Server 2000 ...30 Jan 2008

  • XML data type in SQL Server 2005 vs. VARCHAR (MAX)

    When choosing to use the XML data type or the VARCHAR (MAX) data type, in SQL Server 2005, DBAs and developers should know the potential performance impact of each. Here's a look at two tables, one...28 Jan 2008

  • Top 10 SQL Server development tips of 2007

    Here are the top 10 most viewed SQL Server development tips of 2007. From best practices for writing stored procedures and creating SQL Server tables and columns, to T-SQL enhancements and error ha...28 Jan 2008

  • ApexSQL Log/2005.10

    ApexSQL Log is a Microsoft SQL Server log auditing and recovery tool that analyzes SQL Server's own transaction log to display information about data changes on computers and applications where the...20 Jan 2008

  • SQL Compliance Manager v3.0

    Learn how SQL Compliance Manager v3.0 audits SQL Server databases by generating reports, ensuring compliance with regulatory and data security requirements.18 Jan 2008

  • Spotlight on SQL Server Enterprise 2.0

    Get advanced features to optimize database performance monitoring, diagnostics and issue resolution activities within SQL Server with Spotlight on SQL Server Enterprise 2.0.18 Jan 2008

  • SQLsecure v1.2

    SQLsecure v1.2 provides SQL Server user access and performing rights analysis, ensures security model enforcement and offers advice to improve SQL Server security.17 Jan 2008

  • DB Audit Expert v4.0

    DB Audit Expert is a database security and auditing software product for Microsoft SQL Server, MySQL, Oracle, Sybase and IBM DB2 that tracks and analyzes any database activity, including security s...17 Jan 2008

  • SQL Farm Combine 2.0

    SQL Farm Combine 2.0 is a scalable SQL Server deployment tool allowing administrators to execute scripts and push changes to many databases and servers at once.17 Jan 2008

  • ApexSQL Report/2005.02

    Learn how ApexSQL Report, a data-driven Web reporting application for SQL Server, uses stored procedure metadata to create sortable HTML reports in minutes.17 Jan 2008

  • ApexSQL Doc/2005.13

    ApexSQL Doc/2005.13 can automatically document multiple databases simultaneously into Compiled HTML Help-format or HTML with an extensive command-line interface.17 Jan 2008

  • ApexSQL Log API 2005.10

    ApexSQL Log API is a programmable API that adds transaction log-auditing capabilities to SQL Server database applications, eliminating the need for developers to code auditing functionality themsel...17 Jan 2008

  • ZUI

    SQL Power Tools Inc.'s ZUI monitors SQL Server database activity at all times while targeting poor-performing SQL statements to ensure a healthy database.17 Jan 2008

  • SQLCentric v 2.0.1

    SQLCentric is a fully functional Web-based MSSQL-centric network database monitoring and alert system for your entire SQL Server infrastructure.17 Jan 2008

  • SQL Sentry Event Manager, Version 3

    SQL Sentry Event Manager, Version 3 is a scheduling, alerting and response system for optimizing the performance of database servers across your enterprise, with no agents to install and manage on ...17 Jan 2008

  • SQL diagnostic manager v5.0

    SQL diagnostic manager v5.0 alerts SQL Server admins to health, performance and availability problems within their SQL Server environment from a central console.17 Jan 2008

  • ER/Studio 7.5

    Learn about ER/Studio 7.5 which simplifies the analysis of existing SQL Server data sources, designing and implementing databases and building and maintaining enterprise models.17 Jan 2008

  • Rapid SQL 7.4.1

    Produce quality code in less time and accelerate the delivery of database applications with Embarcadero Rapid SQL 7.4.1, a cross-platform SQL IDE that helps database programmers.17 Jan 2008

  • ApexSQL Code/2005.13

    ApexSQL Code/2005.13 is a SQL server Rapid Application Development (RAD) code generation tool that automatically creates custom code patterns in a variety of programming languages.17 Jan 2008