免费的SQL Server工具可能让你的生活变得更轻松

Free SQL Server tools that might make your life a little easier

更新:新的东西从最新的更新将是红色的。

This list will grow as I find new tools.这份名单将成长为我找到新的工具。 So if you know of some not on this list do post them in the comments.所以,如果你知道一些不在此名单中的意见后做他们。

SQL Server Management Studio Add-in's SQL Server管理工作室外接的

SSMS Tools Pack - an add-in with lots of IDE options (Query Execution history, regions, debug sections, CRUD stored procedures creation, new query templates, running custom scripts from Object explorer's context menu) for SQL Server Management Studio and SQL Server Management Studio Express SSMS的工具包 -加载项与区域地段的IDE选项(查询执行的历史,调试部分,CRUD的存储过程的创建,新的查询模板,运行SQL Server的SQL Server Management Studio和管理自定义脚本从对象资源管理器的上下文菜单) Studio速成

Data Scripter - generates insert statements for a table 数据的编剧 -生成一个表中插入报表

Create Database Snapshot - simple GUI for creating a database snapshot 创建数据库快照 -简单的图形用户界面创建一个快照数据库

Sort SQL Project Files - sorts SQL project files 排序SQL项目文件 -项目排序的SQL文件

The Black Art of Writing a SQL Server Management Studio 2005 Add-In - a how-to article and a Search DB Objects add-in with code 黑色的写作艺术的SQL Server Management Studio的2005外接 -一个如何对文章和一个搜索数据库对象加载的代码

How to create SSMS Add-in - an article that describes how to create add-ins without any source code 如何创建SSMS中添加中 -一篇文章,介绍如何创建任何源代码的加载项无

Free SQL Server books 免费的SQL Server的书籍

"Boost your DBA expertise" and "DBA Best Practices" - two free books by RedGate “提升您的DBA专业知识”和“DBA的最佳实践” -由两个免费书籍展鹏

SQL Injection tools SQL注入工具

Top 15 free SQL Injection Scanners - 15 free SQL injection scanners :) 排名前15位免费SQL注入扫描仪 - 15个免费SQL注入扫描仪:)

Microsoft Source Code Analyzer for SQL Injection - a static code analysis tool for finding SQL Injection vulnerabilities in ASP code 微软的源代码分析器SQL注入 -一个静态代码的ASP代码分析工具,SQL注入漏洞的发现在

UrlScan v3.0 Beta - a Microsoft security tool that restricts the types of HTTP requests that Internet Information Services (IIS) will process 都是Urlscan.MMDDYY.log 3.0测试版 -微软安全工具,限制HTTP请求类型的Internet信息服务(IIS)将进程

HP Scrawlr - crawls a website, simultaneously analyzing the parameters of each individual web page for SQL Injection vulnerabilities 惠普Scrawlr -抓取一个网站,同时分析注入漏洞的SQL参数页的每一个人网站

Blind Sql Injection Brute Forcer version 2 - accepts custom SQL queries as a command line parameter and it works for both integer and string based injections. SQL盲注野蛮Forcer的版本2 -接受命令行参数定制的SQL查询,它作为一个工程都注射整数和字符串的基础。

Administration 管理

SQL Web Data Administrator - enables you to easily manage your SQL Server data from a web browser Web数据的SQL管理员 -让您可以轻松地从Web浏览器管理您的SQL Server数据

SQL Server Cache Manager - allows you to return information about what is stored is the SQL Server cache and how efficiently it is being used. SQL Server的缓存管理器 -允许您返回存储的信息是什么是SQL Server缓存,以及如何有效地使用它。

SQL Internals Viewer - a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organized and stored. 浏览器的SQL内件 -一个存储工具寻找到SQL Server存储引擎,看数据是如何分配体力,主办。

Microsoft SQL Server 2000/2005 Management Pack - monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems. 微软的SQL Server 2000/2005管理包 - 2005年监测的可用性和性能的SQL Server 2000和问题,可以发出警报的配置。

Performance Analysis of Logs (PAL) Tool - tool that reads in a performance monitor counter log (any known format) and analyzes it using complex, but known thresholds (provided). 性能分析日志(PAL)的工具 -工具,读取性能监视器计数器日志(任何已知的格式),并分析它使用复杂的,但已知的阈值(提供)。


Microsoft Baseline Security Analyzer - helps small- and medium-sized businesses determine their security state in accordance with Microsoft security recommendations and offers specific remediation guidance 微软基线安全分析器 -帮助小型和中小型企业确定其与微软的安全建议国家按照安全,并提供具体的整治指导

RML Utilities for SQL Server (x86) and (x64) - tools to help database administrators manage the performance of Microsoft SQL Server: Overview 二零零一年五)水电费用于SQL Server(86和(x64)的 -工具,以帮助数据库管理员管理服务器的性能的微软SQL: 概述

SQLDumper.exe - comes with SQL Server. 运行Sqldumper.exe -来自与SQL服务器。 Installed at ..Microsoft SQL Server90SharedSQLDumper.exe. Generates a dump file on demand for any Microsoft Windows application.安装在.. Microsoft SQL Server的 90 共享运行Sqldumper.exe。生成一个转储微软Windows应用程序文件的任何需求。

SQL Server 2005 Partition Management - helps in data loading and extraction from partitions SQL Server 2005的分区管理 -帮助分区加载和提取数据

SQLdiag Utility - a general purpose diagnostics collection utility that can be run as a console application or as a service (comes with SQL Server) SQLdiag实用工具 -一种通用的诊断工具,可以收集(运行作为控制台应用程序或作为一个服务来与SQL服务器)

SQL Nexus - analyzes SQLDIAG captures 的SQL的Nexus -捕捉分析执行SQLDIAG

PSSDiag Utility - a general purpose diagnostic collection utility that Microsoft Product Support Services uses to collect various logs and data files PSSDiag实用工具 -通用诊断收集的实用工具,Microsoft产品支持服务使用收集各种日志和数据文件

SQL Recon - performs active and passive scans of your network in order to identify all of the SQL Server/MSDE installations in your enterprise 的SQL侦察 -执行扫描您的网络主动和被动,以确定企业所有的SQL服务器/您的MSDE装置

SQL Server 2005 Express Profiler - a free SQL Profiler for SQL Express 的SQL Server 2005 Express的探查 -免费为SQL Express的SQL事件探查器

Log Parser 2.2 - provides query access to log files, XML files and CSV files, the Event Log, the Registry, the file system, and Active Directory 日志分析器2.2 -提供查询访问日志文件,XML文件和CSV文件,事件日志,注册表,文件系统和Active Directory

Microsoft SQL Server Management Studio Express - apparently a lot of people don't know this exists. 微软SQL Server Management Studio的Express的 -显然是一个很多人不知道这个存在。 Stripped down version of SSMS SSMS中剥离下来的版本

SQL Server 2005 System Views Map - a nice map of all the DMV's and links between them SQL Server 2005系统点击地图 -一个不错的地图所有机动车管理局的和它们之间的联系

SQL Server Web Data Administrator - admin your SQL Server over the web SQL Server的Web数据管理 -管理员在网上您的SQL Server

SQL Server Express Utility - simple interaction with SQL Server SQL Server Express的工具 - SQL Server的简单互动

TableDiff.exe - utility that compares 2 tables for differences in data and schema for SQL Server 2000 and 2005 TableDiff.exe -实用工具,比较2000年和2005年2表差价服务器在数据和架构为SQL

DMVStats - collects, analyzes and reports on SQL Server 2005 DMV performance data DMVStats -收集,分析和报告的SQL服务器2005年机动车管理局的性能数据

Best practices, analysis, health and performance 最佳做法,分析,卫生和性能

SQL Server FineBuild - provides one-click install and best-practice configuration of SQL Server 2005. SQL Server的FineBuild -提供一键安装和最佳做法2005年配置的SQL服务器。

SQL Server 2005 Assessment Configuration Pack for Sarbanes-Oxley Act (SOX) - contains configuration items intended to help you establish and validate a desired configuration for your SQL 2005 servers in order to support your Sarbanes-Oxley compliance efforts SQL Server 2005的评估配置奥克斯利Pack的萨班斯法案(SOX) -包含配置项规定的努力旨在帮助您建立您的SQL和验证所需的配置2005服务器,以支持您的萨班斯法案

SQLIO GUI - user interface for SQLIO Disk Subsystem Benchmark Tool SQLIO界面 -用户界面的工具磁盘子系统基准SQLIO

SQLQueryStress - automatically collects metrics to help you determine whether your queries will perform under load, and what kind of resource strain they put on your server SQLQueryStress -自动收集数据,以帮助您确定是否您的查询将执行负载下,什么样的资源紧张,他们把你的服务器

SQLIO Disk Subsystem Benchmark Tool - used to determine the I/O capacity of a given configuration SQLIO磁盘子系统基准工具 -用来确定的I / O能力给出一个配置

SQL Server 2005 Best Practices Analyzer - lets you verify the implementation of common Best Practices in SQL Server 2005 SQL Server 2005的最佳实践分析工具 -让您确认2005年共同实施的最佳实践在SQL Server

SQL Server 2000 Best Practices Analyzer - lets you verify the implementation of common Best Practices in SQL Server 2000 SQL Server 2000的最佳实践分析工具 -让您确认2000年实施共同在SQL Server的最佳实践

SQL Server Health and History Tool (SQLH2) - collects information from instances of SQL Server to determine how SQL Server is being used SQL Server的健康和历史工具(SQLH2) -收集资料的SQL Server的实例,以确定从SQL Server如何被使用

SQL Server Health and History Tool (SQLH2) Performance Collector - optional tool to collect performance counters that are consumed by the SQLH2 SQL Server的健康和历史工具(SQLH2)性能集电极 -可选的工具来收集性能SQLH2计数器的是消耗

SQL Server Health and History Tool (SQLH2) Reports - reports needed to view the data collected by the SQLH2 SQL Server的健康和历史工具(SQLH2)报告 -报告需要查看SQLH2所收集的数据

SQL Server 2005 Performance Dashboard Reports - performance reports that integrate into SQL Server Management Studio SQL Server 2005的性能控制台报告 -执行情况报告集成到SQL Server Management Studio中

Microsoft SQL Server 2000/2005 Management Pack - monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems 微软的SQL Server 2000/2005管理包 - 2005年监测的可用性和性能的SQL Server 2000和和可发出警报的配置问题

Database Publishing to hosted servers 数据库发布到服务器托管

Microsoft SQL Server Database Publishing Wizard - provides a way to publish databases to T-SQL scripts or directly to supporting hosting service providers 微软SQL Server数据库发布向导 -提供了一种方法来发布数据库的T - SQL脚本或直接支持主机托管服务提供商

Microsoft SQL Server Database Publishing Services - deployed by shared hosting providers to enable publishing of SQL Server databases over the Internet 微软SQL服务器数据库发布服务 -上网共享托管服务提供商部署到SQL Server数据库在使出版

Upgrade and Migration 升级和迁移

Microsoft SQL Server 2005 Upgrade Advisor - used when upgrading from lower SQL Server version to SQL Server 2005 微软SQL Server 2005升级顾问 -版本升级时使用的SQL服务器从低到SQL Server 2005

SQL Server Migration Assistant for Access SQL Server的Access移植助理

SQL Server Migration Assistant for Oracle SQL Server的Oracle移植助理

SQL Server Migration Assistant for Sybase ASE 为Sybase SQL Server的迁移助理日月光

SQL Server Analysis Services SQL Server分析服务

MDX Script Performance Analyser - allows the user to identify how much each calculated member, named set and scoped assignment in an Analysis Services cube's MDX script contributes to the overall performance of a given MDX query. MDX脚本性能分析仪 -使用户能够识别每个多少计算成员,命名集和范围的脚本分配在一个Analysis Services多维数据集的的MDX有助于MDX查询的整体表现是理所当然的。

Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007 - SQL Server 2005 predictive analytics in Office Excel 2007 and Office Visio 2007 微软SQL Server 2005数据挖掘外接程序的Microsoft Office 2007 - SQL Server 2005中的Visio 2007的预测分析在Office Excel 2007和Office


SQL Server Integration Services SQL Server集成服务

DTLoggedExec - allows you to run a Sql Server Integration Services (SSIS) Package producing a full and detailed logging information of execution status and package runtime data. DTLoggedExec -允许你运行一个SQL Server集成服务(SSIS)包产生了全面而详细的记录数据信息包的执行状态和运行。

SQL Server 2005 BI Development Studio (BIDS) SQL Server 2005的商业智能开发工作室(出价)

BIDS Helper - Add-in for Visual Studio Business Intelligence Development Studio BIDS中帮手 -加载工作室为Visual Studio商业智能发展


Samples 样品

SQL Server Analysis Services Product Samples SQL Server分析服务产品样品

SQL Server 2005 Samples and Sample Databases SQL Server 2005的示例和示例数据库

Non MS stuff 非MS的东西

SQL CLR Project - a tool that allows you to deploy .NET assemblies to SQL Server. 的SQL CLR的项目 -一种工具,允许您部署。NET程序集到SQL服务器。 Pretty COOL if you work with SQL CLR a lot很酷,如果你使用SQL CLR的工作很多

SQL Designer - online SQL Database designer. SQL设计 -在线SQL数据库设计师。 Contains Importing and Exporting scripts to and from different formats包含导入和导出脚本,从不同的格式

DbDiff and DbScripting - Compare SQL Server database structures and generate scripts DbDiff和DbScripting -比较SQL Server数据库的结构和生成脚本

SQL Accord Community Edition - compares database schema 和睦社区版的SQL -数据库模式比较

Quest software's Comparison Suite for SQL Server - tried it... Quest软件的比较服务器套件为SQL -尝试它... pretty slick很圆滑

Bypsoft's DBTYP.NET - compares SQL Server, MySQL and Oracle databases. Bypsoft的DBTYP.NET -比较的SQL Server,MySQL和Oracle数据库。 Cross database comparison of schemas and data.十字架构和数据的数据库进行比较。

SQL DB Tools - SqlDbDiff, SqlDbSearch and SqlDbSize utility 的SQL数据库工具 - SqlDbDiff,SqlDbSearch和SqlDbSize效用

ClearTrace - utility to easier read your saved trace files ClearTrace -实用工具,以方便阅读保存的跟踪文件

SQL Sripter - data export and scripting utility for Microsoft SQL Server 的SQL Sripter -输出数据和脚本的Microsoft SQL Server实用工具

ScriptDb - data export and scripting utility for Microsoft SQL Server ScriptDb -数据输出和脚本的Microsoft SQL Server实用工具

Idera's Free Tools - SQL Server backup and recovery tool, performance dashboard and logons and permissions transfer tool 井寺的免费工具 - SQL Server备份和恢复工具,绩效仪表盘和传输工具登录和权限

SQL and other code Formatting SQL和其他代码格式

Jean-Claude Manoli's code formater - online formatting. 让克劳德马诺利的代码formater -网上格式。 I use this for my blog's code formatting.我用我的博客的代码格式这一点。 Has source code download and formats C#, VB, HTML/XML/ASPX , T-SQL and MSH有没有源代码下载和格式的C#,VB的,的HTML / XML /的ASPX,T - SQL中和细胞刺激素

SQLinForm - online and desktop versions SQLinForm -在线和桌面版本

Simple Talk's Prettifier - online format tool for T-SQL, C# and VB. 简单对话的Prettifier - SQL中,C在线格式工具为T -#和VB。

Wangz's Instant SQL Formatter - formats SQL for pretty much all know databases, they also have an add-in for SSMS and QA but it's not fully free so no link :) Wangz的Instant SQL代码格式化 -数据库的SQL格式几乎都知道,他们也有SSMS中和QA外接 ,但它不是完全免费的,所以没有链接:)

Even if none of this stuff helps you at the moment it's good to know they exist.即使这些东西都有助于在目前它的好处你知道它们的存在。

Because DBA-ing is like a box of chocolates, you never know what you're going to get :)因为数据库管理员,安泰像一盒巧克力,你永远不知道你会得到什么:)

posted @ 2012-04-05 15:15  Alex Tian  阅读(783)  评论(1编辑  收藏  举报