June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Introduction to Service Broker and Sample Script

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Service Broker, SQL Download, SQL Scripts
Service Broker in Microsoft SQL Server 2005 is a new technology that provides messaging and queuing functions between instances. The basic functions of sending and receiving messages forms a part of a “conversation.” Each conversation is considered to be a complete channel of communication. Each Service Broker conversation is considered…
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