SQL Utility Archives - Page 16 of 33 - SQL Authority with Pinal Dave

SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007

August 1, 2009

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Note : Download Microsoft SQL Server Management Pack for Operations Manager 2007 by Microsoft The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The…

SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table

July 29, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Database, DBA, SQL Scripts, SQL Utility

Just about a year ago, I had written on the subject of how to insert data from one table to another table without generating any script or using wizard in my article SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO…

SQLAuthority News – SQL Server Value Calculator

July 22, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Documentation, SQL Utility

I have been using twitter for quite some time now (follow me at @pinaldave). In twitter world very often I find something interesting shared by my friends there. SQL Server Expert and Microsoft Evanglist Vinod Kumar has twitted very interesting detail linking to SQL Server Value Calculator. The web version…

SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char

July 1, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Utility

Today, we will examine something very simple and very generic that can apply to hordes of programming languages. Let’s take a common question that is frequently discussed – What is difference between Line Feed (\n) and Carriage Return (\r)? Prior to continuing with this article let us first look into…

SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.1

June 21, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Utility

Note : Download Risk and Health Assessment Utility by Microsoft Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.1 is a practical download package intended exclusively for Microsoft Premier Customers. This package paraphernalia includes all the scoping tools required to prepare and qualify your environment to…

SQLAuthority News – Download – SQL Server 2008 Developer Training Kit

May 22, 2009

Pinal Dave

SQLAuthority News

Database, DBA, SQL Download, SQL Server, SQL Training, SQL Utility

Note : Download SQL Server 2008 Developer Training Kit by Microsoft

SQL Server 2008 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2005. The SQL Server 2008 Developer Training Kit will help you understand how to build web applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008. The training kit is brought to you by Microsoft Developer and Platform Evangelism.

SQL SERVER – Introduction to SQL Server 2008 Profiler – Summary

April 24, 2009

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Profiler, SQL Utility

Introduction SQL Server Profiler is a powerful tool that is available with SQL Server since a long time; however, it has mostly been underutilized by DBAs. SQL Server Profiler can perform various significant functions such as tracing what is running under the SQL Server Engine’s hood, and finding out how…