(Suprotim Agarwal) I was recently working on a query where a Hotel has a bunch of Privileged Customers. To determine what discount to give to these customers, the query should be able to tell what is the average interval after which each privileged guest visits the hotel. The Guest who visits the ho

(Jason Thomas) There could not be any SSAS interview where at least one question is not asked about the dimension, attribute or measure properties. Many at times, I myself have kept on searching the web to find more information about a particular property only to find that the information is pretty

(Marcin Policht) SQL ServerServer Integration Services’ primary purpose is to serve as a database development platform. As such, it is subject to standard best practices of software programming, which among other recommendations, advocate reusability. Realizing this objective in SSIS frequently invo

(Tim Ford) We’ve all faced this issue: a cursory review of a SQL Server instance we manage appears to have logins assigned to multiple server roles whose rights supercede or overlap one-another. I’m specifically referring to the situation where a login is a member of the sysadmins server role and a

(Mike Chapple) With the May 2010 release of SQL Server 2008 R2, many database professionals wondered why Microsoft didn’t increment the product’s name to SQL Server 2010. Indeed, there is a quite a bit of new functionality in this latest release of SQL Server which, among other things, allows advanc

(Pinalkumar Dave) Earlier I wrote blog post SQL SERVER – Difference Between GETDATE and SYSDATETIME which inspired me to write SQL SERVER – Difference Between DATETIME and DATETIME2. Now earlier two blog post inspired me to write this blog post (and 4 emails and 3 reads from readers).

(Darren Green) This is just a quick one prompted by a question on the SSIS Forum, how to programmatically add a precedence constraint (aka workflow) between two tasks.

(Richard Waymire) In the fourth post about the SQL Server error logs, we examined the logging of database startup and recovery entries. In this final post about the error logs, we’ll examine the logging of security and network startup entries. Understanding how the SQL Server error logs work is grea

(Derek Dieter) The try catch methodology of programming is a great innovation for SQL 2005+. The first question you should ask yourself before using Try/Catch should be “why?”. Why am I going to use Try/Catch?

We are sure that by now, you must have heard of the self service BI concept that has been used with the release of SQL Server 2008 R2. Two new features have been introduced in SQL Server 2008 R2 in order to help provide self service capabilities to the end users.