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

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

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

Earlier I wrote an article about the new lookup functions that ship with SQL Server 2008 R2.  Today I’m going to show you another new feature of SSRS 2008 R2, this time in the visualization department.  This feature is the Data Bar.  With this new component it’s fairly easy to make your tabular data a [...]
Click here to see the original post

With my book I wrote together with Kevin Dockx, Microsoft Silverlight 4 Data and Services Cookbook available for a couple of weeks now, I decided to do a small search on reviews. I’ll be honest, I took all I could find right now.

Here’s the ones I found:

Richard Costall:

“Microsoft Silverlight 4 Data and Services Cookbook is a great publication, and worthy of a place any Silverlight developers bookshelf. The formula of ‘recipes’ works well, with well explained, yet simple examples covering almost everything you’d ask when starting out building business applications in Silverlight. It highlights Silverlight 2 and Silverlight 3 functionality differences, yet is right up to date on Silverlight 4.”

Complete review at: http://www.nxtgenug.net/Article.aspx?ArticleID=368

Vikram Pendse writes:

“My Review Comments : * * * * * (5 Stars)..Simple Amazing book !..Go and Grab your Copy Today !!! :)

Impressed with this Book?..want to have a look at? Ok ! What you see is what you get ! kidding..You can download a sample chapter right away !”

Complete review at http://pendsevikram.blogspot.com/2010/05/microsoft-silverlight-4-data-and.html

Damir Tomicic writes:

“Das Buch ist sehr praktisch geschrieben. Der Leser merkt sofort, dass Gill und Kevin die Ansätze selbst ausprobiert und für die Leser optimiert haben. Die gewählte Sprache ist einfach, die Beispiele auch für Anfänger geeignet. Ein guter Einstieg in das Thema.”

Complete review at: http://tomicic.de/2010/05/05/MicrosoftSilverlight4DataAndServicesCookbookGillcleeren.aspx

Review on Amazon.com

“Good Introduction to the Datagrid, Dataform, and different Services (4/5)”

Complete review at http://www.amazon.com/Microsoft-Silverlight-Data-Services-Cookbook/product-reviews/1847199844/ref=dp_db_cm_cr_acr_txt?ie=UTF8&showViewpoints=1

Interested in my book as well? It is available from Packt Publishing, Amazon.com, Amazon UK and many other retailers as well! I hope you enjoy it!

---

Snowball.be - The blog of Gill Cleeren
Click here to see the original post

Almost a year ago I wrote a small blog post to ask everyone to vote on a certain Connect item related to the linking of two datasets in a Reporting Services report.  At this moment there have been 87 positive votes on the request. Now that SQL Server 2008 R2 has been RTM’ed, it’s time to [...]
Click here to see the original post

Consider the following scenario. You’ve been developing some SSIS packages, nicely making sure that all errors and warnings are gone from the Error List window. So the next step is to deploy the packages to the server and schedule them. After some days you decide to have a look at the sysssislog table and discover [...]
Click here to see the original post

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

Community Day 2010 is coming! Registration is now open.

No less than fourteen Microsoft user groups combine their efforts to organize this unique knowledge-sharing and networking event. With so many new Microsoft product and technology releases, the content of this Community Day will be focusing on Visual Studio 2010, SharePoint 2010, Silverlight 4, Office 2010, SQL Server 2008 R2, OCSR2, and many more!
So don’t miss out on the Community Day and join us on Thursday June 24th in Utopolis, Mechelen. We will bring together more than 300 IT Pro’s and developers.
The Community Day 2010 is brought to you by Azug, Besug, Biwug, IT-Talks Pro-Exchange, SCUG, SQLUG, VBIB, Visug, WinSec, XNA-BUG, CLUG, MyTIC and DotNetHub.

Register now for free at www.communityday.be !

---

Snowball.be - The blog of Gill Cleeren
Click here to see the original post

No excuses for not attending if you’re a SQL Server DBA, system administrator or just interested in the subject.  It’s a free training event, it’s presented by Ricardo Noulez and it’s taking place in the Microsoft offices in Zaventem. When? Thursday, April 20th, 2010 Where? Microsoft België Corporate Village Leonardo Da Vincilaan 3 1935 Zaventem More info Managing SQL Server requires insight in the [...]
Click here to see the original post