The whole world in a SQL Server database 29 January 2013 Nico-Jacobs SQL Server, Integration Services Some people have the whole world in their hand, but last weekend I tried something slightly less ambitious: Getting (part of) the whole world in a SQL Server database. Loads of spatial data from OpenStreetMap I’m always looking for interesting datasets. I was still lacking a large dataset with spa... [More]
Validation sets in SQL Server Data Mining 22 January 2013 Nico-Jacobs Analysis Services, SQL Server BI, Data Mining What are validation sets? Data Mining Data mining analyses historical data to find patterns that might help us better understand how our business works, or might help predict how the business might evolve in the future: Instead of doing ‘traditional BI’, where we pick some attributes and ask for a... [More]
Metro Style Applications and MVVM 06 October 2011 Lander-Verhack Metro Style When working with windows 8 on a tablet, you quickly notice the different ways a user can interact with your application. Your application can control the full screen, both in landscape or portrait, or can share the screen with an other application. Basically, there are four modes your application w... [More]
Using reporting services with Oracle package / stored procedure 16 December 2010 Nico-Jacobs SQL Server BI, Reporting Services Reporting services can create data sets on top of Oracle stored procedures. Sure, the manual says so, but this afternoon, I tried to get things up and running, and I want to share some of the dead ends and problems I experienced in that, maybe it can help you avoid these obstacles. Don’t panic, not ... [More]
Scripting in integration services data flow 24 November 2010 Nico-Jacobs If you wander how we can program our own conditional splits in SSIS data flow, or implement our own asynchronous transformations, or implement things such as a Year-To-Date, then you forgot to attend my session at the SQL Server Day. Luckily you can catch up with the slides and code samples on my we... [More]
Analysis Services documenter 13 March 2010 Nico-Jacobs Good news for those of you who are using our Analysis Services documenter tool: we just added a new feature. If you generate HTML documentation from a cube, then in the ‘full documentation mode’, the MDX script of your cube will be scripted as well into a bulleted list (one calculated member, named ... [More]
BCS presentation at Techdays Belgium 28 February 2010 Lieven-Iliano Last thursday I did a presentation at the Belgium Techdays in Antwerp. My session focussed on the Business Connectivity Service in SharePoint 2010. With the Business Connectivity Service you can integrate external data in the SharePoint and Office user experience. With the new powerfull .NET Assembl... [More]
5 things SQL Server does different from what many developers expect 06 February 2010 Nico-Jacobs That’s what I will talk about tomorrow at Techdays Belgium. I notice in my courses that many developers are sometimes still surprised with the way SQL Server responds to transactions, or try-catch blocks, or the way it handles stored procedures, indexes and statistics. So if you’re at Techdays, come... [More]
Las Vegas MIX’ing at Microsoft together with BESUG 30 January 2010 kevin-derudder MIX 2010 must be one of the best events Microsoft organizes for web folks. Since not everyone can make it to Las Vegas for this we at Microsoft Belgium together with the Belgian Silverlight User Group have a solution for you. We will organize a live keynote streaming on a big screen in a cool Vegas ... [More]
Service oriented architecture in SQL Server with Service Broker 30 November 2009 Nico-Jacobs Wouldn’t it be nice if a stored procedure could run certain statements in parallel, if we could easily scale out SQL Server applications,… When you have code that can run asynchronously, all these things become possible, if you implement them with the Service Broker: Service Broker is an service ori... [More]