• January 17, 2008 17 Jan'08

    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.  Continue Reading

  • January 17, 2008 17 Jan'08

    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.  Continue Reading

  • January 16, 2008 16 Jan'08

    ApexSQL Audit 2005.07

    Apex SQL Audit automatically generates triggers to create a Microsoft SQL Server data audit log and provides a reporting utility that extracts the data into meaningful reports.  Continue Reading

  • January 16, 2008 16 Jan'08

    How secure is your SQL Server network design?

    Too often, SQL Server systems are located on unsafe networks, and databases are easily accessible -- even by way of the Internet. Here are some descriptions of alarming network design practices and the tools that will secure your SQL Server systems.  Continue Reading

  • January 16, 2008 16 Jan'08

    ApexSQL Clean/2005.09

    ApexSQL Clean, a SQL Server development tool, looks for unreferenced and unused database objects like tables and procedures and displays them graphically.  Continue Reading

  • January 15, 2008 15 Jan'08

    ApexSQL Script/2005.10

    Output SQL database structures into scripts, .Net executables, deployment packages and source code with ApexSQL Script, a database development tool.  Continue Reading

  • January 15, 2008 15 Jan'08

    ApexSQL Diff/2005.12

    Discover how ApexSQL Diff saves SQL Server developers time comparing databases. This tool analyzes changes in tables, stored procedures, views and more.  Continue Reading

  • January 15, 2008 15 Jan'08

    Table partitioning with SQL Server 2005

    SQL Server 2005 offers improved database performance. One key upgrade is the table partitioning function, which, among other things, can yield significant benefits for queries executed against large tables. In this tip, see how transactional and ...  Continue Reading

  • January 14, 2008 14 Jan'08

    Synchronizing Analysis Services 2005 databases in SQL Server

    Early versions of Microsoft's Analysis Services did not support straightforward methods for migrating analytical databases. The synchronization feature provided in Analysis Services 2005 simplifies the process of copying the source server to the ...  Continue Reading

  • January 14, 2008 14 Jan'08

    DBArtisan 8.1.5

    DBArtisan is a cross-platform database administration tool to help DBAs maximize the availability, performance and security of their databases.  Continue Reading

  • January 09, 2008 09 Jan'08

    Determining SQL Server database storage requirements

    The first time you calculate storage requirements for a SQL Server database application is significantly important and should be done during the development phase. Here are two methods for pinpointing future storage needs.  Continue Reading

  • January 07, 2008 07 Jan'08

    Top 10 SQL Server Tips of 2007

    We've tallied the 10 most popular SQL Server tips of 2007. From learning the differences between a clustered and non-clustered index and how to optimize SQL Server disk configuration, to routine tasks such as updating table statistics and ...  Continue Reading

  • January 07, 2008 07 Jan'08

    Setting up SQL Server clusters on a SAN

    Storage area networks (SANs) allow you to connect expandable storage to your SQL Server installations, but care must be taken when working with SQL Server clusters.  Continue Reading

  • January 07, 2008 07 Jan'08

    SQL Server clustered index design for performance

    Clustered index design choices are vital for system performance and future maintenance of your SQL Server database. Find out why clustered indexes should be narrow, static, increase over time and how they use many-to-many tables. Also explained in ...  Continue Reading

  • January 02, 2008 02 Jan'08

    Top 7 SQL Server backup and restore tips of 2007

    Optimize SQL Server backup and restore methods natively with these best practices. We've tallied our top seven most viewed tips of 2007 on the topic of backup and restore. Whether you're looking for commands to a speedier restore, steps to take ...  Continue Reading