All Articles - SQL Authority with Pinal Dave

SQLAuthority News – SQL Server Accelerator for Business Intelligence (BI)

September 19, 2009

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

Business Intelligence, Data Warehousing, SQL Documentation, SQL Download

I have wonderful experience at my recent Business Intelligence tour. I will write down in detail about my experience at different location. However, today I would like to talk about one particular question which was asked at all the locations. It was about SQL Server Accelerator for Business Intelligence (BI).…

SQLAuthority News – Community Tech Days Oct 3, 2009 – Ahmedabad

September 18, 2009

Pinal Dave

SQLAuthority News

Database, MVP, SQL Server, SQLAuthority Author Visit

Dive deep into the world of Microsoft technologies at the Community TechDays and get trained on the latest from Microsoft. Build real connections with Microsoft experts and community members, and gain the inspiration and skills needed to maximize your impact on your organization while enhancing your career. What more… You can watch some of these sessions LIVE online, from the comfort of your workstation as well.

SQL SERVER – Converting Stored Procedure into Table Valued Function

September 17, 2009

Pinal Dave

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

SQL Function, SQL Stored Procedure

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…

SQL SERVER – SQL Server Desktop Screen Background

September 10, 2009

Pinal Dave

SQLAuthority News

SQL Server

Buck Woody (MSFT) has published a blog post about SQL Server Desktop Screen Background. I really like the SQL Server Desktop background and I have replaced that background on my work laptop. I came across this particular post because I am a regular reader of his blog. Few of the other interesting posts written by him are following.