Posted by
Andy Brown
on 22 December 2017
Introduced in Visual Studio, string interpolation allows you to linking different C# expressions contained in curly parentheses, with everything preceded by a dollar sign. This blog explains how to use this handy new short-cut.
Posted by
Andy Brown
on 08 December 2017
This short blog explains how to convert Julian dates to "normal" ones, and how the formula used actually works!
Posted by
Andy Brown
on 08 December 2017
Did you know that you can automatically generate multiple versions of a pivot table, with each one configured to filter by a different item? We didn't - this blog is an attempt to apologise for our oversight!
Posted by
Andy Brown
on 14 March 2024
Step-by-step instructions for how to show on your LinkedIn profile proof of the Wise Owl courses that you've attended.
Posted by
Andy Brown
on 01 June 2017
There are a few ways to find the differences between two Excel worksheets. This blog considers 3 methods (using Excel formulae, using Query Editor and using the Inquire add-in).
Posted by
Andy Brown
on 27 April 2017
If you've added an expression constraint to control flow in a package in Integration Services, this blog will show you how to display what the constraint does automatically.
Posted by
Andy Brown
on 21 April 2017
Follow this blog to learn how to use an SSIS package to loop over the worksheets in an Excel XLSX workbook, importing the contents of each.
Posted by
Andy Brown
on 02 March 2017
When you are programming in SQL, you often have the choice of using table variables or temporary tables. This blog considers whether one method is substantially quicker than the other (spoiler alert: not really).
Posted by
Andy Brown
on 03 February 2017
Everyone has a favourite system stored procedure (you do, don't you?). But five? That's the subject of this blog, anyway.
Posted by
Andy Brown
on 01 February 2017
A blog setting out an approach to coding in SQL to ensure consistently high standards across your organisation.
Posted by
Andy Brown
on 26 January 2017
This short blog explains how you can customise your quick access toolbar to display the path of the file that you are currently working on.
Posted by
Andy Brown
on 19 December 2016
This blog differs from the Microsoft update summary in two ways: it omits preview and obscure changes, but goes into more detail (and gives practical examples) on mainstream updates.
Posted by
Andy Brown
on 19 December 2016
There are a host of date-based functions in Power BI Desktop for producing cumulative figures, but how do you get running totals for non-date columns? This blog explains!
Posted by
Andy Brown
on 30 November 2016
This blog summarises how to run SQL statements in a Power BI Desktop query, using dynamic SQL to pass in parameter values
Posted by
Andy Brown
on 27 September 2016
If you want to group items in a SQL query, showing a comma-delimited list of ids for each, generating an XML file is not the obvious place to start - but it should be.
Posted by
Andy Brown
on 26 September 2016
A short blog explaining how you can get Excel to read out values in cells every time that you recalculate a worksheet.
Posted by
Andy Brown
on 09 September 2016
If you want to initiate (or take part in) a discussion on our website, you'll first need to create a post - and to do that, you'll need to register on our site. This blog explains how to do both these things!
Posted by
Andy Brown
on 07 April 2016
Looping over Excel workbooks is one thing, but how can you loop over all of the worksheets in a single workbook, importing the contents of each? This blog explains the steps you need to follow.
Posted by
Andy Brown
on 07 April 2016
If you've been given the output from a pivot table or a cube, you can collapse it back into its original state using the UNPIVOT transform in Integration Services.
Posted by
Andy Brown
on 23 March 2016
It's only a small thing, but … this blog shows how you can click and drag with the ALT key held down, then type to apply a table alias to lots of tables simultaneously.