Getting Cooperation From A Stubborn Data Dude

by Valentino Vranken 9 June 2010 19:59
Lately I’ve been using Visual Studio Team System 2008 Database Edition with the GDR R2 add-on, also known as “The Data Dude”, to compare databases with each other. And during a schema compare I noticed that the dude can be quite stubborn now and then. Here’s an example and an explanation of why, as far as I [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (161) | Post RSSRSS comment feed

Getting Cooperation From A Stubborn Data Dude

by Valentino Vranken 9 June 2010 19:59
Lately I’ve been using Visual Studio Team System 2008 Database Edition with the GDR R2 add-on, also known as “The Data Dude”, to compare databases with each other. And during a schema compare I noticed that the dude can be quite stubborn now and then. Here’s an example and an explanation of why, as far as I [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (172) | Post RSSRSS comment feed

Aggregating Data With The OVER Clause

by Valentino Vranken 1 June 2010 21:12
In this article I will show you a couple of different T-SQL queries to fetch aggregated data.  The main purpose is to illustrate how the OVER clause can be used to aggregate data. For the examples I will use data from the AdventureWorks2008R2 database, available at CodePlex. The Data The AdventureWorks 2008 R2 database contains a view called [...]
Click here to see the original post

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (168) | Post RSSRSS comment feed

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: , , , , , ,

Davy Knuysen

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (194) | Post RSSRSS comment feed

Importing Data Using The Wizard: Mixing The Wrong Ingredients

by Valentino Vranken 3 May 2010 20:39
A while ago I wrote an article about how you can use the SQL Server Import and Export wizard to import Excel data into a SQL Server database.  In this sequel I’m going to show you some problems which you may encounter when using that wizard.  Just like any good old wizard, he’s only as [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (153) | Post RSSRSS comment feed

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: , , , , ,

Davy Knuysen

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (17) | Post RSSRSS comment feed

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: , ,

Davy Knuysen

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (17) | Post RSSRSS comment feed

Retrieving Data From Excel

by Valentino Vranken 29 March 2010 20:16
The purpose of this article is to demonstrate how to retrieve data from an Excel sheet and put it in a table in a SQL Server database. Introduction Anyone who’s ever used a computer for a significant amount of time has probably come into contact with Excel, the spreadsheet application part of the Microsoft Office suite. Its [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (107) | Post RSSRSS comment feed

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: , , , ,

Davy Knuysen

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (0) | Post RSSRSS comment feed

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: , , , , ,

Davy Knuysen

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (20) | Post RSSRSS comment feed