June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Download IIS Database Manager

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download, SQL Utility
IIS Database Manager allows you to easily manage your local and remote databases from within IIS Manager. IIS Database Manager automatically discovers databases based on the Web server or application configuration and also provides the ability to connect to any database on the network. Once connected, IIS Database Manager provides…
Read More

SQL SERVER – Execution Plan and Results of Aggregate Concatenation Queries Depend Upon Expression Location

Pinal Dave
SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Documentation
I was reading the blog of Ward Pond, and I came across another note of Microsoft. I really found it very interesting. The given explanation was very simple; however, I would like to rewrite it again. Let us execute the following script. This script inserts two values ‘A’ and ‘B’…
Read More

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

Pinal Dave
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).…
Read More

SQLAuthority News – Download Microsoft SQL Server StreamInsight CTP2

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,…
Read More

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

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…
Read More

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

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…
Read More