BLOGS BY AUTHOR
BLOGS BY YEAR
Archived blogs from Wise Owl (page 1 of 2)
Showing blogs 1-20 (out of 31)
Posted by Andy Brown on 03 July 2020
Did you know that Outlook doesn't include your Deleted Items folder by default when you search? This owl didn't until today!
Posted by Andy Brown on 08 May 2019
Visual Studio 2019 has a different look (particularly for creating new projects), but Wise Owl can't see any compelling reason to upgrade.
Posted by Andy Brown on 19 January 2018
Visual Studio 2017 includes some clever new quick coding features, better debugging and a much better installation routine, as this blog explains.
Posted by Andy Brown on 12 July 2016
With Visual Studio 2015 you can now develop for a wide range of mobile platforms, including IoS (Apple), Android and even the Apple Watch.
Posted by Andy Brown on 11 July 2016
This short blog summarises how to get legitimate free copies of Visual Studio 2015 and SQL Server 2016 Developer installed on your laptop or computer.
Posted by Andy Brown on 19 May 2016
A short blog explaining a compile error I got using Web Extensions - here's hoping it saves someone else some time!
Posted by Andy Brown on 07 September 2015
The latest incarnation of Microsoft Office (2016) should be released on 22nd September 2015 (Microsoft are always a bit ahead of themselves with versions). This blog gives a detailed guide to what's new, the biggest changes being in Excel and Outlook.
Posted by Andy Brown on 20 February 2015
The editor for calculated fields in Excel (aka measures) isn't the greatest; this blog shows you how to install and use DAX Studio as a substitute editor.
Posted by Andy Brown on 09 January 2014
Access 2013 will still look familiar to existing Access users, but it now includes the facility to develop and publish web applications. This blog explains the thinking behind Microsoft's radical move.
Posted by Andy Brown on 09 January 2014
Power View is an Excel or SharePoint add-in which allows you to create quick and interactive dashboard reports, with built-in drill-down. This blog considers whether you're missing a trick if you don't know how to use Power View.
Posted by Andy Brown on 04 November 2013
The RANKX function works out where a measure lies in order for any dimension, but it has a couple of gotchas to watch out for, as this blog explains.
Posted by Andy Brown on 20 March 2013
This blog shows how to use each of the 5 arguments of the RANKX function to rank rows in PowerPivot.
Posted by Andy Brown on 31 January 2013
PowerPivot is a superb addition to Excel: it allows you to create pivot tables based on multiple tables taken from a variety of data sources, and its DAX language lets you report any statistic you want. This overview summarises how to get started with PowerPivot, and what it does.
Posted by Andy Brown on 16 January 2013
This blog shows you how to create a calendar of dates for use in PowerPivot. Instructions are included for Excel and Access.
Posted by Andy Brown on 09 January 2013
A short blog explaining how to use the keyboard to cycle through previous cursor positions.
Posted by Andy Brown on 04 January 2013
This blog includes the SQL script to generate a table of calendar dates for linking to from within PowerPivot or an Analysis Services tabular model.
Posted by Andy Brown on 25 September 2012
We think - cautiously - that WPF is a better platform for client tool development than Windows Forms. This blog gives 10 reasons why.
Posted by Andy Brown on 06 August 2012
This blog shows you how to use CSS style sheets to change the default appearance of the Reporting Services parameter strip.
Posted by David Wakefield on 26 June 2012
How to link SQL Views and Tables to MS Access using VBA without getting the annoying Unique Record Identifier pop up.
Posted by Andy Brown on 23 April 2012
Designing relational databases is easy once you learn the few basic rules, and the procedure is identical whether you're using SQL Server or Access. This blog illuminates the subject!