Archived blogs from Wise Owl (page 1 of 2)

Showing blogs 1-20 (out of 29)

A summary of the changes introduced in Visual Studio 2017

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.

Using Xamarin to develop mobile phone apps in Visual Studio

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.

How to install Visual Studio 2015 Community and SQL Server 2016 Developer

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.

A strange error when using Web Extensions to auto-compile SASS

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!

What's new in Microsoft Office 2016 (including Excel 2016 changes)

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.

Tags:   Outlook | General topics    |    Excel | General    |    Musings | Microsoft Office

Using DAX Studio to edit calculated fields or measures in Excel

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.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | DAX

Access 2013 - an overview of the new web app feature

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.

A review of Power View, including examples of use

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.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | General

Using the RANKX function in PowerPivot DAX measures

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.

Tags:   PowerPivot 2010 | DAX

How to use the RANKX function in PowerPivot

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.

Tags:   PowerPivot 2010 | DAX

An overview of PowerPivot for Excel 2010

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.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | General

Creating a PowerPivot calendar in Access or Excel

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.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | Calendar

A keyboard short-cut for Word previous position

Posted by Andy Brown on 09 January 2013

A short blog explaining how to use the keyboard to cycle through previous cursor positions.

Tags:   Word | General

Create a calendar table for PowerPivot or Analysis Services in SQL Server

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.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | Calendar    |    SQL Server versions | SQL Server 2012

Why you should develop systems in WPF, not WinForms

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.

Tags:   WPF | General    |    WinForms | General

Changing the appearance of parameters in SSRS

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.

Tags:   SSRS | Parameters    |    HTML and CSS | CSS

Link SQL Views to MS Access using VBA

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.

Tags:   SQL | Views    |    Access | Importing and linking    |    T-SQL | Other

Designing databases for SQL Server and Access

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!

Tags:   Access | Designing databases    |    SQL | Tables and columns    |    T-SQL | SQL Tutorial

Why the Easter Bunny prefers SQL Server to Access

Posted by Andy Brown on 30 March 2012

The Easter Bunny stores his distribution data in SQL Server, not Access; read why!

Tags:   Musings | Random musings    |    Access | Designing databases

Windows Forms or WPF ? Choosing software.

Posted by Andy Brown on 23 March 2012

If you're developing software, should you use old-fashioned but reliable WinForms, or the exciting new concept, WPF?

Tags:   WPF | General    |    WinForms | General
This page has 0 threads Add post