![]() SQLcheck shows performance data such as current transaction rate, percent of processor used, average lock wait time, and buffer cache hit ratio. NetIQ's SQLcheck uses a graphical dashboard interface to provide a realtime overview of your SQL Server system's status. Using SSAS can help you gain insights into your. ![]() SSMA mainly migrates tables and select queries with no parameters. SQL Server Analysis Services (SSAS) is a powerful data analysis tool that allows you to create data models and perform complex data analysis tasks. If you need to manage SQL Server and Oracle databases, BMC Software's SmartDBA Cockpit (formerly Web DBA) provides a management console that includes many familiar features of Enterprise Manager in a Web-browser interface. Microsoft provides Microsoft SQL Server Migration Assistant (SSMA) to make migration easier. MBSA also recommends security best practices for SQL Server 2000 and 7.0, Microsoft IIS, Microsoft Internet Explorer (IE) 5.01 and later, and Microsoft Office XP and Office 2000. The Microsoft Baseline Security Analyzer (MBSA) checks for common security exposures and incorrect configuration settings. Choose Data Access and Databases, Microsoft SQL Server, then SQL Server XML View Mapper 1.0. Although XML Schema Definition (XSD) has superseded XDR, the XML View Mapper is helpful for working with existing XDR documents. SQL Server XML View Mapper produces XML Data Reduced (XDR) documents based on SQL Server 2000 databases. The setup can be a cumbersome job, but you can use AdminLog to enter problems, assign them to projects and individuals, and track the answers. LockwoodTech Software's AdminLog is a useful bug-tracking tool to have in your project-management toolbox. When you uncover incompatibilities in the Microsoft Data Access Components (MDAC) level, you can use Microsoft's Component Checker to quickly determine which MDAC version is running. NET Enterprise Servers, SQL Server Development, then SQL Server 2000 Web Services Toolkit. ![]() An add-in to SQL Server 2000, SQLXML 3.0 lets you create Web services from stored procedures, process XML templates, and process XML updategrams. Many SQL Server users still haven't heard about the free SQLXML feature pack. Although vendors sometimes change the availability of free tools, when I wrote this column, all the utilities listed were freeware without time bombs. Here are my seven favorite free SQL Server utilities. During the past year, I've run across many useful free tools.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |