Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Restoring databases to a set drive and directory

 

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

0 comments, 270 reads

Posted in Simon Says on 8 April 2013

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

1 comments, 920 reads

Posted in Simon Says on 26 October 2012

SQL Saturday 28 was extraordinary!!!!

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

4 comments, 312 reads

Posted in Simon Says on 17 August 2010

Patrick and Thomas LeBlanc..did a great job Congrats!!!

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

1 comments, 570 reads

Posted in Simon Says on 12 August 2010

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

2 comments, 313 reads

Posted in Simon Says on 5 August 2010

The Gotcha’s of Gotcha’s

 

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

0 comments, 533 reads

Posted in Simon Says on 5 August 2010

That DARN TOMCAT

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

3 comments, 613 reads

Posted in Simon Says on 11 January 2010

SSRS reading linebreak in textbox

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

"We are loading data from a single data element into a textbox that can contain html linebreak tags (<br />). Is there a way for…

Read more

1 comments, 901 reads

Posted in Simon Says on 8 January 2010

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.

" Read more

5 comments, 7,441 reads

Posted in Simon Says on 7 January 2010

How to obtain RecordCount (or Number of cases) from a DMX query

 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

1 comments, 1,304 reads

Posted in Simon Says on 5 January 2010

Recursion with SQL Server 2008 within the Financial World

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

0 comments, 662 reads

Posted in Simon Says on 12 September 2009

Newer posts