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
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
SQL Server 2012 SSAS .. 'Yes we can' use one instance for both the tabular and multi dimensional models
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.
SQL Saturday # 28 in Baton Rouge, Saturday Aug 14th, looks to be one of the best events of the year.
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.
Error rsAccessDenied : The permissions granted to user 'Toma-PC\Toma' are insufficient for performing this operation.
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.
This one caught my eye on the Data Mining Forum and it is not the first time that this one has cropped up.
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