You have imported data from a text file into your database which included datetime values formatted as strings. An example is the following string ‘2013-09-12 01:03:52’ which represents the date 12th September 2013 at 3 minutes past 1am on the 52nd second. The following snippet example show how to convert this string to a datetime […]
For all you hipsters that own a Windows 8 phone 😉 the new update 8.0.10328.78 contains a host of new features including Data Sense which gives you a simple setup and visualisations to track your usage. http://www.windowsphone.com/en-au/how-to/wp8/basics/windows-phone-8-update-history See your most data hungry Apps … Watch your limits on the Tile … Easy to setup too … […]
A simple Percentage of Total Calculation example. If you are bringing your MDX dataset into SSRS remember SSRS doesn’t recognise MDX percentage values formatted with FORMAT_STRING=”Percent” – so you’ll need to specify the percentage format in your SSRS chart or tablix.
You want your months to display in your SSRS report as Jan, Feb, Mar etc yet you run the report and the ordering is all out of sorts. Adapt the following MDX sampler, to grab the month key, and follow the steps subsequent to set the ordering in your SSRS chart. The month key will […]
One frequently occurring scenario I come across is a bunch of records with the same identifiers but each row has a different datestamp – then I need to identify the latest record in each group. This is the end result of what needs to be achieved, I want a ranking for each record in the […]
You have a table that contains rows identifying start and end values for a range and you want to convert this to rows i.e. one row for every number between the start of the range and the end of the range. You also need to do it in a view. An example is : Id […]
Page level compression has the benefit of generating high levels of data compression on tables with oodles of data and lots of repetitive values. I like it http://technet.microsoft.com/en-us/library/cc280464.aspx because, amongst other things, both storage and performance work well for reporting applications. The compression activity searches columns for values that can be used to reduce storage […]
To randomise your playlist, open your Windows 8 Phone Music app, start playing the playlist, then locate the icon just below the heart (two arrows pointing upwards). Click this which will start randomising the playlist order after the current song completes.
Importing CSV files through the SSIS Import Export Wizard, will default string data to 50 characters. To override the default mappings you must click Advanced, then painfully go through and override each column mapping one by one from 50 to a larger size. Tedious when you have lots and lots of columns. A suggested workaround […]
It would be nice if the SSIS For Each Loop Enumerator could provide the developer the flexibility to process files in order of filename, file create date or perhaps file modified date. This article really helped me out recently… http://microsoft-ssis.blogspot.com.au/2011/04/how-to-configure-foreach-loop-container.html. Keep it simple – usually means keeping clear of toxic script tasks or script components, […]