2009 - Page 16 of 55 - SQL Authority with Pinal Dave

SQL SERVER – Converting Stored Procedure into Table Valued Function

September 17, 2009

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

In one of my recent articles, I mentioned the use of Table Valued Function (TVF) instead of Stored Procedure (SP). I received a follow up email asking what type of SP can be converted into a TVF. This is indeed a very interesting question! In fact, not all the SPs…

SQLAuthority News – Download Microsoft SQL Server StreamInsight CTP2

September 16, 2009

Pinal Dave

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

SQL Documentation, SQL Download

Note: Download Microsoft SQL Server StreamInsight CTP2 by Microsoft Microsoft SQL Server StreamInsight is a platform for the continuous and incremental processing of unending sequences of events (event streams) from multiple sources with near-zero latency. These requirements, shared by vertical markets such as manufacturing, oil and gas, utilities, financial services,…

SQL SERVER – Cryptography in SQL Server 2008

September 15, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

SQL Server, particularly the 2005 and 2008 versions, offers the functionality of cryptography. In the following, this functionality is briefly explained. Introduction Any database professional will support the encryption of data. However, the encryption of data has to be carried out at the database engine level. This is quite tricky…

SQL SERVER – Plan Caching and Schema Change – An Interesting Observation

September 14, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Cache, SQL Documentation, SQL Profiler, SQL Scripts, SQL Server Management Studio, SQL Stored Procedure, SQL Utility, SQL White Papers

Last week, I had published details regarding SQL SERVER – Plan Caching in SQL Server 2008 by Greg Low on this blog. Similar to any other white paper, I have read this paper very carefully and enjoyed reading it. One particular topic in the white paper that caught my attention…

SQL SERVER – Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet

September 13, 2009

Pinal Dave

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

Spatial Database, SQL Documentation, SQL Download, SQL White Papers

Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet SQL Server Technical Article Writers: Isaac Kunen Project Editor: Diana Steinmetz Published: July 2008 I recently read this very interesting white paper. I really found it very interesting as this one was one very easy to read and humourous…

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

September 12, 2009

Pinal Dave

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

SQL Documentation, SQL Download

This download package is intended for Microsoft Premier Customers Only. This package includes all of the scoping tools necessary to prepare and qualify your environment to receive a Risk and Health Assessment Program for Microsoft SQL Server. Download Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool…

SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2009- Seattle

September 11, 2009

Pinal Dave

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

SQL PASS, SQLAuthority Author Visit

PASS Summit Unite2009 – the premier event for SQL Server professionals – will be held in Seattle from November 2 to 5. It is the largest and the most intensive Microsoft SQL Server conference in the world organized by SQL Server users for SQL Server users. This year marks the…