Scripting in integration services data flow

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

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]

Service oriented architecture in SQL Server with Service Broker

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]