Posted by
Andy Brown
on 24 November 2021
You can use SQLCMD mode to parameterise the connection, database name, table name and select columns for a query - and much more besides, as this blog explains.
Posted by
Andy Brown
on 18 November 2021
Tired of doing repetitive tasks at Christmas? This blog shows you how to create a Power Automate Desktop flow to send emails out to your nearest and dearest programmatically, with each email including instructions on how they should use the gifts they've been given.
Posted by
Andy Brown
on 18 November 2021
Power Automate Desktop allows you to automate any common sequence of tasks that you perform in Windows, and has the potential to change your working life. So what is it?
Posted by
Andy Brown
on 28 October 2021
To commemorate the rather dubious International Keyboard Short-Cut Day 2021 (the first Wednesday in November of each year, apparently), we offer the 10 Windows key short-cuts which will save you the most time.
Posted by
Andy Brown
on 28 October 2021
In Power BI Service you can now create personal bookmarks to retain any changes you've made to filtering for a report.
Posted by
Andy Brown
on 28 October 2021
Consumers of your reports can alter filters, but you can change an option to prevent these changes persisting for other users.
Posted by
Andy Brown
on 28 October 2021
You can add a tab for a Power BI report within a Teams channel, and also share a report from Power BI Service within Teams - this blog shows you how to do both these things!
Posted by
Andy Brown
on 08 October 2021
This blog shows how you can use Python to loop over all of the emails in a folder in Outlook, saving the attachments for each to your hard disk.
Posted by
Andy Brown
on 08 October 2021
How to solve the problem that Visual Studio Code can't find a module that you've imported.
Posted by
Andy Brown
on 29 September 2021
Some of the sites on this page will make you laugh, and some make you shake your head, but they should all entertain you for a moment or two!
Posted by
Andy Brown
on 31 August 2021
How does Python compare with other programming languages like C#, VB or SQL? This blog looks at the differences we've come across in preparing our Python courses and videos.
Posted by
Andy Brown
on 31 August 2021
The IKEA blue Frakta shopping bag is iconic, and everywhere. Here are 5 suggestions (not always totally serious) for how you can recycle your IKEA bags!
Posted by
Andy Brown
on 31 August 2021
The Stuxnet worm was one of the most sophisticated bits of software ever written. Find out exactly how the US and Israel used it to target Iranian uranium centrifuges, and see the implications this has for us all.
Posted by
Andy Brown
on 27 July 2021
You may know about What 3 Words, which allows you to pinpoint your location in the world using just 3 words. Now there's Four King Words, which does the same for the UK and Ireland using just 4 swear words.
Posted by
Andy Brown
on 27 July 2021
Do you know why World Emoji Day is held on July 17th each year? Or how to see the world's emojis being tweeted in real time? Or that Microsft are trying to resurrect Clippy the paper-clip as an emoji? These are just 3 of the 9 fascinating facts explained in this blog!
Posted by
Andy Brown
on 26 July 2021
How to use the #shared keyword to bring up a list of all of the M functions in Power BI Query, and then use this list to create your own help table or even your own function.
Posted by
Andy Brown
on 26 July 2021
Small multiples are mini-charts shown in a two-dimensional grid, with each chart showing the state of play for a different field's value. After a number of improvements small multiples have finally emerged from preview!
Posted by
Andy Brown
on 01 July 2021
You can now share your screen in Teams, and have your floating head appearing on top of it (the effect is weird if you're the presenter).
Posted by
Andy Brown
on 30 June 2021
DAX contains a number of incredibly useful hidden short-cut keys, allowing you to move lines, comment code and much more!
Posted by
Andy Brown
on 02 June 2021
How wide is too wide when it comes to a computer monitor? Perhaps the answer depends on the size of your desk, but you'll need plenty of space for this monster.