Introduction

As all of us do when confronted with a problem, the resource of choice is to ‘Google it’.

This is where the plot thickens. Recently I was asked to stage data from numerous databases which were to be loaded into a data warehouse. To make a long story… Read more

SQL Saturday 207 Yaoundé Cameroon, is holding its first SQL Saturday on June 8th. Due to the remoteness from the US, Achilles Nguela has kindly opened the event to live meeting presentations. This is a really a great opportunity to make a BIG DIFFERENCE to the SQL Server community.… Read more

Have you ever been to a SQL Saturday where someone 'rocks up' for a beginner's presentation. In fact he or she works at a help desk and the boss sent him or her, to the event, to 'learn everything there is to know about SQL Server'.

This ACTUALLY happened to… Read more

Introduction

A few months back, I was asked how long a particular nightly process took to run. It was a super question and the one thing that struck me was that there were a plethora of factors affecting the processing time. This said, I developed a query to ascertain process… Read more

Restoring databases to a set drive and directory

Introduction

Often people say that necessity is the mother of invention. In this case I was faced with the dilemma of having to restore several databases, with multiple ‘ndf’ files, and having to restore them with different physical file names, drives… Read more

As most of us are aware, each instance of SSAS 2012 may be run in either tabular or multidimensional mode (and not both). This necessitates having 2 instances should you wish to do both.

HOWEVER, I picked up something interesting at the PASS Nordic Rally. There is an UNSUPPORTED 'toggle' that… Read more

Folks, I have to tell you that this event was great!! It was really well organized, with great speakers. Personally, I know that I learnt a great deal. A special thanks has to go out to Patrick LeBlanc, Tom LeBlanc and the crew who did a super job in organizing the… Read more

Have you ever had 590 + people register for YOUR SQL Saturday.. well Patrick and Thomas did. These folks have put their hearts into this event (which as I blogged before WILL be the event of the year). Do yourselves a favour and have a look at the schedule.

http://www.sqlsaturday.com/28/schedule.aspx Read more

If you are looking for a rewarding way to spend next Saturday, August 14th 2010, do yourself a favour and join us in Baton Rouge LA.

This promises to be one of the best events of 2010. I know.. as I plan to fly down to Louisiana from Providence RI… Read more

Have you ever tried to create a dataset in SSRS 2008 (based upon an OLAP cube) and ran into that notorious “Query (1, 1) Parser: The syntax for '=' is incorrect.”  error message and a plethora of other really informative  error messages.

Well I did,   Read more

Here is a challenge that had me stumped for several days. Besides for working with Reporting Services on a day to day basis, I also work with a reporting product that requires Apache Tomcat.

Both reside on the same development box running Windows XP box with SP2.

One thing… Read more

The problem of the day: I stumbled on this problem on the Microsoft Reporting Services Forum website and thought it might be of some interest.

The problem

Read more

In my problem of the day, I found this one out on the Microsoft Reporting Services Forum. I bumped my head on this one early in December.

This lady is trying to deploy a Reporting Services Solution from Visual Studio to the report server.

Here is the problem.

" Read more

 This one caught my eye on the Data Mining Forum and it is not the first time that this one has cropped up.

The question

"Hello
I have a DMX listed below. Now if i run this in the Sql Server Management Studio, it returns me the list of Customers… Read more

As most of you, we in the financial world have often been faced with the challenge of extracting data from relational sources that within the business frame of reference are more hierarchical in nature. Recently, I did what most of us do from time to time, I searched on “Google”… Read more