Community Day 2010

by Davy Knuysen 12 May 2010 10:14

Community Day is back with the Fourth Edition of this annual community event on Microsoft technologies! Fourteen Microsoft User Groups combine their efforts to organize this unique networking and knowledge sharing event. With so many new releases from Microsoft, the theme of Community Day 2010 is of course 2010: a new wave of products and technologies. [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: community day, events, sqlug.be, event

Davy Knuysen

XMLA script to deploy MDX Calculations

by Davy Knuysen 5 May 2010 16:13

At a current project I needed to create a deploy script for the MDX calculations of a cube. SQL Server Management Studio makes it very easy for you to create XMLA-scripts to create or alter cubes, dimensions, etc… But it’s not possible to use Management Studio to create an alter-script that only contains the MDX calculations. [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: analysis services, bi, mdx, sql server, sqlserverpedia, data, olap

Davy Knuysen

Parent-Child hierarchies in Reporting Services

by Davy Knuysen 16 April 2010 10:28

Reporting Services 2008 is a great reporting tool, but displaying Analysis Services data with Reporting Services doesn’t always display the data as you would expect. A Parent-child hierarchy is one example of this: When you browse Parent-child hierarchy from an Analysis Services cube with Excel, Excel automatically displays it with nice drill-down functionality. But when [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: analysis services, mdx, reporting services, sql server, data, reporting

Davy Knuysen

Next SQLUG event on What is System Center Operations Manager 2007 R2 and how can it help in managing SQL Servers, May 20th

by Davy Knuysen 15 April 2010 12:02

Managing SQL Server requires insight in the state and performance of the underlying infrastructure, OS and individual SQL components. System Center Operations Manager 2007 R2 cannot only give you that insight, but it can be reused in a broader application/service monitoring view. This session focuses on the out-of-the-box capabilities of System Center Operations Manager 2007 [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: event, sql server, sqlug.be

Davy Knuysen

Save up to 35% for the PASS European Conference

by Davy Knuysen 4 March 2010 00:16

The Belgian SQL Server User Group offers a significant 35% discount for its members (even more than early bird discount) for any PASS European Conference 2010 registration. Use discount code BEC15Y and enjoy your savings on your registration. For more information check our SQLUG website. PASS European Conference 2010 is Europe’s premier conference for SQL [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: event, events, sql 2008 r2, sql server, sqlug.be

Davy Knuysen

Reporting Services Timeout in Sharepoint

by Davy Knuysen 3 March 2010 07:05

Recently someone asked me to check a Reporting Services report that always resulted in an Unexpected Error. The report server was configured for Sharepoint Integrated Mode. I came to the conclusion that the server always returned this error after exactly 2 minutes, so it had to be a timeout exception. The report was kind of big, so [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: bi, moss, reporting services, sql server, data, sharepoint

Davy Knuysen

February 11th, next UG-evening on Service Broker

by Davy Knuysen 18 January 2010 11:27

SQL Server Service Broker and some of the things it can do for you” is brought to you by Nico Jacobs and will take place on February 11th. Since SQL server 2005, it is possible to build a Service Oriented Architecture (SOA) inside SQL Server. The component that enables this is the service broker, a [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: event, sql server, sqlug.be

Davy Knuysen

SQL Server Day 2009 videos now available on Chopsticks

by Davy Knuysen 16 December 2009 10:10

Microsoft has made the sessions presented on SQL Server Day 2009 available on Chopsticks Opening Keynote by Wesley Backelant and Ritchie Houtmeyers Best Practices for SQL Server Consolidation by Tom Van Mulders Breaking the ETL world record with Integration Services by Henk van der Valk Designing Effective Aggregations in Analysyis Services 2008 by Chris Webb [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: .net, analysis services, bi, event, events, excel services, integration services, mdx, moss, office, powerpivot, reporting services, sql 2008 r2, sql server, sqlug.be, chopsticks, sharepoint

Davy Knuysen

SSAS: Custom format string for “duration” using MDX

by Davy Knuysen 7 December 2009 21:38

I recently struggled with the following challenge in Analysis Services: In one of the fact tables there was a field duration which actually was a duration of a certain status in seconds. I needed to display this in a readable format, like “2 days 22:15:59″. bing brought me to the following great article, where Mosha explains how [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: analysis services, bi, excel, mdx, sql 2008 r2, sql server, data

Davy Knuysen

SQL Server Day 2009, now with a third track, fully focused on Development

by Davy Knuysen 17 November 2009 14:59

We are very proud to announce you that, because of the huge success and because of the numerous registrations, we’ve added an additional track to our agenda, which makes SQL Server Day 2009 an entire day, jam-packed with technical sessions spread over 3 tracks, namely Business Intelligence, the SQL Data Platform and Development. 6 break-out [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: uncategorized

Davy Knuysen

Blog N-Technologies

Community Day 2010

XMLA script to deploy MDX Calculations

Parent-Child hierarchies in Reporting Services

Next SQLUG event on What is System Center Operations Manager 2007 R2 and how can it help in managing SQL Servers, May 20th

Save up to 35% for the PASS European Conference

Reporting Services Timeout in Sharepoint

February 11th, next UG-evening on Service Broker

SQL Server Day 2009 videos now available on Chopsticks

SSAS: Custom format string for “duration” using MDX

SQL Server Day 2009, now with a third track, fully focused on Development

RecentPosts

Blog N-Technologies

Tag cloud

RecentPosts