Virtual Business Card


A Jack of all trades is a master of integration, as such an individual who knows enough from many learned trades and skills to be able to bring their disciplines together in a practical manner, and is not a specialist but can be an expert in many fields. Such a person is known as a polymath or a renaissance man; a typical example is someone like Leonardo da Vinci.

Tuesday, February 23, 2010

Cool free SQL Tools out there

Microsoft Source Code Analyzer for SQL Injection
Microsoft Source Code Analyzer for SQL Injection is a static code analysis tool for finding SQL Injection vulnerabilities in ASP code. Customers can run the tool on their ASP source code to help identify code paths that are vulnerable to SQL Injection attacks.

Internals Viewer for SQL Server
Internals Viewer is a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organised and stored.

SQLQueryStress
SQLQueryStress is a free tool for SQL Server programmers. It is designed to assist with performance stress testing of T-SQL queries and routines. The tool 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.
 
Simple Talk Prettifier
Online format tool for T-SQL, C# and VB.
 
SQL DB Tools
SqlDbDiff, SqlDbSearch and SqlDbSize utility
 
ClearTrace
Imports SQL Server 2000, SQL Server 2005 and SQL Server 2008 trace and profiler files into SQL Server and displays summary performance information. It is designed to provide the same performance summary as Read80Trace but in a graphical environment and for SQL Server 2005 and SQL Server 2008.
 
SQL Server Sample Database
Project hosting site for Microsoft SQL Server Samples and Community Projects. Projects listed here are official Microsoft samples for SQL Server (released with Service Packs or major releases of SQL Server) and applications developed by MVPs, and the SQL Server community at large.
 
DTLoggedExec
DTLoggedExec is a tool that allows you to run a Sql Server Integration Services (SSIS) Package producing a full and detailed logging informations of execution status and package runtime data, including dataflow profiling information. In brief it allows to fully log and instrument package execution.
 
Microsoft SQL Server Database Publishing Wizard 1.1
The SQL Server Database Publishing Wizard provides a way to publish databases to T-SQL scripts or directly to supporting hosting service providers.
 
Microsoft SQL Server Database Publishing Services 1.1
SQL Server Database Publishing Services can be deployed by shared hosting providers to enable publishing of SQL Server databases over the Internet.

BIDS Helper
A Visual Studio.Net add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio (BIDS).

SQLRecon 1.0
SQLRecon performs both active and passive scans of your network in order to identify all of the SQL Server/MSDE installations in your enterprise.

DMVStats
Microsoft SQL Server 2005 provides Dynamic Management Views (DMVs) to expose valuable information that you can use for performance analysis.

PSSDIAG Data Collection Utility
PSSDiag is a diagnostic data collector for Microsoft SQL Server. It can simultaneously collect Perfmon/Sysmon logs, Profiler traces, event logs, SQLDIAG reports, and detailed blocking information. It is commonly used by Microsoft Product Support Services engineers to collect diagnostic data from end-user installations and can also be used by end-users to troubleshoot and monitor their own SQL Server installations.

No comments:

Post a Comment