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

Download all SQL Server DENALI CTP3 Demo VHD 36 files at once

Microsoft has made available for download the SQL Server DENALI CTP3 Demo VHD several weeks ago at http://www.microsoft.com/download/en/details.aspx?id=27253. The SQL Server DENALI CTP3 Demo VHD is a fully configured HyperV image of SQL Server Denali CTP3  and SharePoint 2010 good for 180 days. The following software is configured on… Read more

1 comments, 805 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 25 September 2011

Using Unary Operators to control Analysis Services hierarchy aggregations

Analysis Services hierarchy aggregations can be easily controlled using unary operators. For example, in accounting there are GL accounts that are grouped in major GL account groups and used in different financial statements like Profit & Loss Statement, Income Statement, Trial Balance, and Balance Sheet. These GL accounts may affect… Read more

1 comments, 913 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 23 September 2011

Afterthoughts: SQL Saturday #79 South Florida 2011

This past Saturday August 13th I presented two sessions at SQL Saturday #79 hosted by the South Florida SQL Server User Group (SFSSUG) (Webpage | LinkedIn| Twitter). The first presentation was at 11:00am titled “So, What is BI Semantic Model and why should you care?” and the… Read more

0 comments, 709 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 17 August 2011

SSAS errors: DefaultMember(Measures,Measures) (1, 1) The ‘[xxx]‘ member was not found in the cube when the string, [Measures].[xxx], was parsed.

When attempting to browse an Analysis Services cube you may be presented with the following error message:

DefaultMember(Measures,Measures) (1, 1) The ‘[xxx]‘ member was not found in the cube when the string, [Measures].[xxx], was parsed.

The error message is self-explanatory. There is a Default Member being referenced and was not… Read more

0 comments, 348 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 3 August 2011

Dynamically generate current Year, Month or Date member with MDX

MDX can be extended with Visual Basic functions like the FORMAT() and NOW() functions to dynamically generate the current year, month or date member. For example, it can be used as part of a named set to generate current year budget and actuals. It can also be used as part… Read more

0 comments, 952 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 22 July 2011

SQL Server Codename “Denali” CTP3 Resources

SQL Server codename “Denali” CTP3 has been released to the public after much anticipation. You may ask yourself, “What happened to CTP2?” The answer is simple. It was a private build for MVPs and some Microsoft partners. By private, I mean it was not released to the general public. The… Read more

1 comments, 1,400 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 13 July 2011

No way.

No way.


Read more

0 comments, 679 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 29 June 2011

Afterthoughts: SharePoint Saturday Tampa 2011

This past Saturday June 11th, 2011 I had the opportunity to co-present at SharePoint Saturday Tampa thanks to a special invitation by its main organizer Michael Hinckley (Twitter|Blog|LinkedIn). It was a great experience and a very well-organized event. I met several SharePoint professionals I… Read more

1 comments, 452 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 13 June 2011

SSRS Error: Report Preview displays Access to the path ‘…\bin\Debug\Report.rdl’ is denied

While working on Reporting Services at a client site I came across this error when trying to preview a report in BIDS:

The report preview failed because the report could not be built. Read the errors, warnings and messages in the Error List window for specific build failures.

An error… Read more

1 comments, 1,093 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 8 June 2011

Shuttle Endeavor last mission STS-134: I felt the shockwave

I witnessed a piece of history today at 8:56am; the last voyage of shuttle Endeavor on its STS-134 mission. It was truly an amazing experience that will I will always remember. I was able to secure a spot across the Indian River about 12 miles across the Kennedy Space Center… Read more

0 comments, 325 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 16 May 2011

T-SQL: Identifying, inserting and removing spaces in strings

Frequently, when working with strings you will need to identify, insert or remove spaces before, after or in between characters.

For example, you may want to show customer full names  by concatenating the columns that hold the different parts of customer names like FirstName, MiddleName, and LastName, separating each name… Read more

0 comments, 1,618 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 11 May 2011

T-SQL UPPER(): Change an all lowercase string to uppercase

The T-SQL UPPER() command allows you to change a lowercase string to an uppercase string.

For example, it will allow you to change the word hello to HELLO.

Example 1:

Declare @MyVar varchar(50);
Set @Myvar=’hello’;
Select UPPER(@MyVar)   => Output will be HELLO in uppercase.

You can use the T-SQL UPPER()… Read more

0 comments, 871 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 5 April 2011

T-SQL LOWER(): Change an all uppercase string to lower case

The T-SQL LOWER() command allows you to change an uppercase string to a lowercase string.

For example, it will allow you to change the word HELLO to hello.

Example 1:

Declare @MyVar varchar(50);
Set @Myvar=’HELLO’;
Select LOWER(@MyVar)   => Output will be hello in lowercase.

You can use the T-SQL LOWER()… Read more

0 comments, 413 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 2 April 2011

Word Macro to load a Data Warehouse

Recently I came across a very specific requirement for a Data Warehouse project for one of our customers. Due to their very tight data access and transfer security, network packets were not only being encrypted, but they were also being scanned for DML T-SQL statements like Insert, Update and Select.… Read more

0 comments, 271 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 1 April 2011

SSAS errors: Errors in the metadata manager. The dimension with ID of ‘xxx’ referenced by the ‘yyy’ cube, does not exist.

When deploying or processing a cube or dimension you may encounter an error similar to this:

Errors in the metadata manager. The dimension with ID of ‘Student Financial Aid ~MC-Student AK’, Name of ‘Student Financial Aid ~MC-Student AK’ referenced by the ‘Student Financial Aid ~MC’ cube, does not exist.
Errors…

Read more

0 comments, 501 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 22 March 2011

SSIS Foreach File Enumerator returns more files than expected by appending a wildcard (*) to the file mask

While working on a recent project for a customer that involved importing both Excel 97-2003 and Excel 2007/2010 files, I was a little surprised to discover that the Foreach Loop File Enumerator will return both *.xls and *.xlsx files even if you only specify to return *.xls files.

I tested… Read more

1 comments, 500 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 21 March 2011

Differences between Merge and Union All transformations in SSIS

 What are the differences between Merge and Union All transformations in SSIS ?

 The first and most obvious difference is that Merge can only accept two datasets while Union All can accept more than two datasets for input. The second difference is that Merge requires both datasets to be sorted… Read more

0 comments, 403 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 3 March 2011

Newer posts