Keeping track of all the versions and editions SQL Server instances can be a daunting task if you don’t have the right tools and documentation. A very easy way to obtain version, edition and build information from your SQL Servers is by querying the SERVERPROPERTY function as follows:
SERVERPROPERTY(‘Edition’)… Read more
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
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
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
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
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
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
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
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
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
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
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.
Declare @MyVar varchar(50);
Select UPPER(@MyVar) => Output will be HELLO in uppercase.
You can use the T-SQL UPPER()… Read more
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.
Declare @MyVar varchar(50);
Select LOWER(@MyVar) => Output will be hello in lowercase.
You can use the T-SQL LOWER()… Read more
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
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.
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
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