Business Intelligence Requirements Gathering

There are three fundamental steps in building a data warehouse for a BI solution (see Why you need Business Intelligence):
Identify...

Internet Security Advice For The Family

Constant Vigilance!For today’s post I’m channeling my inner Brian Kelley (Blog | Twitter) and talking about security, in particular Internet security....

Using CROSS APPLY to calculate an aggregate across a single row.

I’ve had CROSS APPLY on the mind recently. You could probably tell since its been the subject of my last...

SQL Server – Filtering objects in Object Explorer – Management Studio

When you are working on a database with a large number of objects sometimes it becomes a challenge to locate...

Using the SSIS Object Variable as a Result Set Enumerator

In the first post in this series, I covered the basics of object typed variables in SQL Server Integration Services,...

Investigating Plan Cache Bloat

SQL Server includes a DMV, sys.dm_exec_query_stats, that returns performance statistics for each query plan cached in memory.  However, it can...

SQLPerformance.com

I have had the opportunity to go through the first three SQLSkills Immersion Events, and one of the side benefits...

Sum Result of SSRS LookupSet Function

SSRS provides several built-in Lookup functions:  Lookup, MultiLookup and LookupSet.  Lookup returns a single value while MultiLookup and LookupSet return...

Recap of our SQL Saturday #225 in Kosovo, Prishtina

SQL Saturday Kosovo #225, happened last week and I’m very happy that we did for the first time in Balkan...

How to Size the SQL Server Memory & Why is it important?

The following blog post has 2 objectives.

 1) How to size the memory correctly ( or atleast being close to correctly )
 2)...