SQL-Utilities | Varinder Sandhu

SSIS – Import/Export Wizard – Unexpected Unrecoverable Error

Varinder Sandhu SQL, SQL-Advanced, SQL-SSIS, SQL-Tips and Tricks, SQL-Utilities, Varinder Sandhu

SSIS Import/Export Wizard throws up “Unexpected Unrecoverable Error”. Error message dialog box have three buttons – Abort, Retry, and ignore all cause the wizard to close. The reason I found of this: Installation the .Net Framework 4 Client Profile Solution: Uninstall the .Net Framework 4 Client Profile Or Install Extended .NET Framework 4 You can choose any one solution as per the requirement. If any body have any other solution then please share as comment.

dbForge SQL Complete – SQL Server Management Studio – Visual Studio

Varinder Sandhu SQL, SQL-Utilities, Varinder Sandhu

SQL Complete is a tool available freely (and advanced professional version) which acts as a plugin to SQL Server Management Studio and Visual Studio, and provides powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense. That increases development productivity to quite an extent. For more detail and download one can refer given URL – http://www.devart.com/dbforge/sql/sqlcomplete/ For Demo refer the URL – http://www.devart.com/dbforge/sql/sqlcomplete/sql-complete-demo.html

» Read more

dbForge, SQL Complete

SQL Server – SQL Utility Command GO

Varinder Sandhu SQL, SQL-General, SQL-Tips and Tricks, SQL-Utilities, Varinder Sandhu

GO is not a Transact-SQL statement, even it used in the Transact-SQL. It is a SQL Utility command. SQL Server utilities interpret GO as a signal that they should send the current batch of Transact-SQL statements to an instance of SQL Server. The current batch of statements is composed of all statements entered since the last GO, or since the start of the ad hoc session or script if this is the first GO. A Transact-SQL statement cannot occupy the

» Read more

GO Command, SQL Server

SQL Search

Varinder Sandhu SQL, SQL-Tips and Tricks, SQL-Utilities, Utilities, Varinder Sandhu

Dear Friends, I have tried the Utility SQL Search, it is really helpful for me… Thought it will be handy to all of us and it is a free tool from Red Gate. SQL Search is an add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases. Click here for more detail.

» Read more

SQL Free tools, SQL Search, SQL Server

ASP.NET SQL Server Registration Tool – Aspnet_regsql.exe

Varinder Sandhu ASP.Net, SQL, SQL-General, SQL-Tips and Tricks, SQL-Utilities, Varinder Sandhu

This tool is a part of Microsoft .Net framework and like other tools this tool is also located in [drive:]%windir%Microsoft.NETFrameworkversion folder on your Web server.The ASP.NET SQL Server Registration tool is used to create a Microsoft SQL Server database for use by the SQL Server providers in ASP.NET, or to add or remove options from an existing database. You can run Aspnet_regsql.exe without any command-line arguments to run a wizard that will walk you through specifying connection information for your

SQL Live Monitor

Varinder Sandhu SQL-Utilities, Utilities, Varinder Sandhu

Hello Friends, I have tried the Utility SQL Live Monitor, it really helpful for me…. That’s why I am sharing with you all … Features This tool is designed to provide realtime performance data on SQL Server, as well as data capture for offline analysis. The tools features are: Realtime SQL and System performance data Colour coded alerts Capture data logging to CSV – sample interval configurable PAL Perfmon counter logged to .blg or .csv for offline analysis using PAL

» Read more

SQL, SQL Live Monitor, SQL Monitor, SQL Server