LessThanDot Site Logo

LessThanDot

A decade of helpful technical content

This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.

Boost your datatransport with XML, VB 11 and denormalisation techniques !

Xml, as we all know, has a drawback, being the potential growth in size, characteristical to the format , especially when dealing with complex types and collections of complex types. Let’s take a look at a classic example, taken from Wikipedia. <person> <firstName>John</firstName> <lastName>Smith</lastName> <age>25</age> <address> <streetAddress>21 2nd Street</streetAddress> <city>New York</city> <state>NY</state> <postalCode>10021</postalCode> </address> <phoneNumbers> <phoneNumber type="home">212 555-1234</phoneNumber> <phoneNumber type="fax">646 555-4567</phoneNumber> </phoneNumbers> </person> Try to imagine a collection of 1000 persons, each with 4 possible addresses and up to 10 telephonenumbers and having to transport this over a wire, and it all becomes clear instantly.

Read More...

AngularJS vs Knockout – Validation (3 of 8)

I’m reviewing Angular and Knockout to determine which would fit better for a variety of upcoming projects. So here’s the question, how hard is it going to be to add good, client-side validation to my pages? What about custom validation? This is the third of eight posts looking at the capabilities of knockout and Angular. In the introduction post, I outlined the capabilities that I am evaluating for. In the second post, I looked at databinding. This post is exploring simple and custom validation in with AngularJS and Knockout. All of the examples presented throughout the series are available in the tarwn/AngularJS-vs-Knockout repository on github.

Read More...

Unexpected result with the File System Task

Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File System Task in Integration Services. He used a variable to specify the name of the directory to be created and this variable was populated by a parent package configuration. If the configuration failed, he didn't want the package to create the directory specified during design time, so he entered "invalid" in the variable value, expecting the package to fail as it is not a correct path to a directory. This is a common practice to make sure the package doesn't change your development environment if the configuration in production fails. If you get for example an error from a flat file source saying: "cannot find file invalid", you immediately know the problem lies with the package configurations.

Read More...

AngularJS vs Knockout – Data Binding (2 of 8)

I’m reviewing Angular and Knockout to determine which would fit better for a variety of upcoming projects. First things first, how does the data binding work with each of these libraries? This is the second of eight posts looking at the capabilities of knockout and Angular. In the introduction post, I outlined the capabilities that I am evaluating for and the variety of scripts used in the series. This post is looking specifically at how to use data binding with both frameworks, as that will be used through the rest of the series. All of the examples presented throughout the series are available in the tarwn/AngularJS-vs-Knockout repository on github.

Read More...

AngularJS vs Knockout – Introduction (1 of 8)

I’m reviewing Angular and Knockout to determine which would fit better for a variety of upcoming projects. There are already plenty of posts out there comparing AngularJS and Knockout. I have been slowly reading through all the comparisons I could find, but unfortunately I keep running into cases where the posts are too high level, miss capabilities I need, or have errors that undermine my trust in the rest of the post.

Read More...

Wasabi a sinatra/nancyfx inspired webframework for kotlin

Introduction Wasabi is a sinatra inspired webframework for kotlin. Or according to the author. An HTTP Framework built with Kotlin for the JVM. Wasabi combines the conciseness and expressiveness of Kotlin, the power of Netty and the simplicity of Express.js (and other Sinatra-inspired web frameworks) to provide an easy to use HTTP framework Wasabi has no viewengine. You should use a clientside MVC-framework like Angularjs or ember.js. So on to the code.

Read More...

SQL Agent Job High Availability – Availability Groups

The concept of SQL Agent Jobs being highly available or having a high level of fault-tolerance, is typically defined with the implementation of Full Clustered Instances (FCI). However, now that Availability Groups have really taken a great deal over with the advent of SQL Server 2012, Windows Server Failover Clustering is the clustering solution SQL Server builds on. Given that, SQL Agent jobs truly fall into a sort of black hole and you have to start designing and planning for failover situations.

Read More...

Belgian Visug event about VB11

It is very rare these days that you get the opportunity to go to an event where they talk about VB.Net so I think you should go and make the world a better place. It’s the 15th of October. Basic’s not dead (Bert Michielsen) As developers , many of us had their first professional experience in VB.NET as Visual Basic was then called. A PL that severely suffered from trying to be too userfriendly, in contradiction to the new star in the .NET ecosystem back then: C#. Which had the advantage of being at the forefront of every new implementation of the .NET platform.

Read More...

Introducing Windows Azure Infrastructure as a Service

If you haven’t heard about Azure yet, I’d be surprised. Cloud based Platform applications like Windows Azure SQL Databases (WASDs) have been around for several years, and are becoming highly popular. WASDs (for example) don’t quite have all of the same features as Infrastructure based SQL Server. For those times when you need infrastructure based technologies, but still want to leverage the portability and ease of provisioning benefits of cloud based computing, Windows Azure Infrastructure as a Service (Iaas) may offer a solution. And IasS is… That rack you have in your datacenter with a bunch of blades that runs your virtual environment – you know the one. IaaS is that. Only bigger. Lots bigger. Massively big. The fact is, Windows Azure IaaS allows YOU to spin up any kind of virtual machine you wish – with a variety of different size options. These machines run in a remote datacenter, and come with full RDP access as well as Remote PowerShell script access enabled. Managing these machines is easy and done over standard Internet connections. Really? How does all of this work? If you’re familiar with Hyper-V or VMWare technologies, it’s very similar to that. Essentially, there are large datacenters based worldwide. When you provision a new machine – that is, create a new server – a VHD is created using one of the predefined image templates or one you define on your own. This machine is then housed in one of the Azure datacenter – should a disaster happen, The Azure infrastructure will handle moving it to another place that is not currently experiencing said disaster. So, as a SQL professional, what does this mean to me? Great question – Here are a few use cases to think about: If you’re building a new SQL environment, and want to have a place to test things, using Azure IaaS to temporarily build a DEV/TEST environment can be a quick way to get started. Azure IaaS machines are billed by the minute and only billed when powered on, so by managing the operational time of those environments costs can be easily managed. Azure IaaS can be used to extend your SQL environment. You can provision machines in the cloud to extend your AlwaysOn group. Joey D’antoni (b | t) talks about this as SQL Saturday. You can create virtual networks in IaaS to connect those machines that are in the cloud directly to your on premise network and use Azure as a remote datacenter. This can either be used in a DR plan, or to provide geocentric mirroring for users based worldwide. As Azure IaaS machines can be configured with different OSes like Windows or Linux, it can be a great option to run a Hadoop Cluster. This cluster can be easily scaled out during high processing times – like end of the month archival, and then scaled back during lower usage periods to help save costs What other options are there? I’d love to hear in the comments section at the bottom of this post.

Read More...

How to enable image conversions in hybris 5

With hybris 5, you can use ImageMagick to convert your images. ImageMagick is open source software and comes with the hybris 5 platform. Now how do you enable the mediaconversion in hybris running on a Microsoft Windows OS? By default mediaconversion is not enabled in hybris 5 as you can see in the picture from the hMC. Make your Windows ready To use ImageMagick you need to install the Visual C++ 2010 Redistributable Package. Also note that on a 64-bit Windows OS both the x86 and the x64 package need to be installed.

Read More...