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

SQL SERVER – 2008 – Introduction to Table-Valued Parameters with Example

August 31, 2008

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

SQL Scripts, SQL Stored Procedure, SQL Utility

Table-Valued Parameters is a new feature introduced in SQL SERVER 2008. In earlier versions of SQL SERVER it is not possible to pass a table variable in stored procedure as a parameter, but now in SQL SERVER 2008 we can use Table-Valued Parameter to send multiple rows of data to…

SQLAuthority News – Microsoft SQL Server 2008 R2 Report Builder 3.0

August 27, 2008

Pinal Dave

SQL

Data Warehousing, Database, DBA, SQL Download, SQL Server, SQL Utility

Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 supports the full capabilities of SQL Server 2008 Reporting Services including flexible report layout, data visualizations and richly formatted text. The download includes the following functionality above the RC0 release of Report Builder:

SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database

August 23, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Utility

Today in this article I would discuss about the Database Mail which is used to send the Email using SQL Server. Previously I had discussed about SQL SERVER – Difference Between Database Mail and SQLMail. Database mail is the replacement of the SQLMail with many enhancements. So one should stop using…

SQL SERVER – 2005 – Best Practices Analyzer (August 2008)

August 17, 2008

Pinal Dave

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

SQL Download, SQL Server Security, SQL Utility

The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment. This download is the August 2008 release of…

SQLAuthority News – Microsoft SQL Server 2008 Books Online – BOL – English

August 12, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA, Software Development, SQL Download, SQL Utility

SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. The Help viewer used by Books Online requires the Microsoft .NET Framework version 2.0. Books Online includes the following types of information: Setup and upgrade…

SQL SERVER – Download and Install Sample Database AdventureWorks 2005 – Detail Tutorial

August 10, 2008

Pinal Dave

SQL Tips and Tricks

Database, SQL Backup, SQL Download, SQL Restore, SQL Sample Database, SQL Scripts, SQL Utility

Just a day ago I received a question from a reader who just installed SQL Server 2008. After the installation user did not find any sample database along with installation. The user wants to install the sample database which he is very much used to. Let us learn about Sample Database AdventureWorks.

SQL SERVER – Introduction to Log Viewer

July 23, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security, SQL Utility

SQL Server log data is very important for any DBA to troubleshoot SQL Server related problems. In SQL Server 2000 there was no facility to check System and Application log, however in SQL Server 2005 there is facility of the log viewer. It is very useful tool and very easy…