by Mandy Doward - 13/12/2017

SQL Server Microsoft Official Curriculum (MOC ) Courses

Following PTR gaining Microsoft Learning Partner Status in November we will be adding a number of new courses to our existing SQL Server training portfolio over the coming weeks.

by Mandy Doward - 13/12/2017

 We are very proud…….

…. to announce that last month PTR achieved the Microsoft Learning Partner Status!

Yes, we have added Microsoft Learning Partner Status to our long standing Silver Data Partner Status.

Ian and I formalised our many years of providing consultancy and training services in Microsoft Technologies by attaining Microsoft Certified Solutions Associate (MCSA) certification and Microsoft Certified Trainer (MCT) status.


by Mandy Doward - 14/11/2017


PTR was 28 years old yesterday and that got me thinking about all the things that have changed over those 28 years!


So what does it mean to be 28 years old?


by Mandy Doward - 7/11/2017

Tailored IT Training

As the end of 2017 approaches we are being flooded with bespoke tailored training requests as many of our clients plan for exciting projects rolling out in 2018.

Such projects invariably mean that training is required to provide new skills, and a standard public scheduled course often doesn't fit the bill when training staff who may have slightly differing requirements. That is where PTR is different to many training companies.

by Mandy Doward - 11/10/2017

Working with PIVOT Tables In SQL Server Queries

Many data analysts will be familiar with exploring data using Pivot Tables in Excel workbooks. The following example shows the detail sales data for bike related products, and an Excel Pivot Table created from that data:

The Totaldue values are grouped by Quarter and product.

by Mandy Doward - 28/6/2017

Specifying a No Rows Message for an SSRS/Report Builder Report


I’m sure we have all come across a scenario where a parameter report has allowed a user to specify a combination of conditions that results in no matching records for a dataset behind a region in an SSRS report.

If the report has headers, footers or textboxes then there may be some output produced when the report is run to make it obvious that there is no valid data for the report, as in the following example:

by Kelly Doward - 21/6/2017

Microsoft Access Forms - Set up a database to open in a form

There is a feature in Access, which allows you to use a form to front end your database. This blog will help you create a basic form and then set this form to be open, when you load the database.

Creating a Basic Form
Using Access Options

by Kelly Doward - 26/5/2017

Introduction to Excel VBA Part 2

If you didn’t catch part one, click here.

In this blog we will explore other methods of selecting cells and ranges of cells.

by Kelly Doward - 24/5/2017

Using The DateDif Function in Microsoft Excel

Have you ever needed to work out the difference between two dates? DateDif allows you to do this, and show the result in Days, Months, Years, Month Days or Year Months.

by Mandy Doward - 24/5/2017

What Is Report Builder?

Report Builder is a report creation tool from Microsoft enabling you to develop simple to complex reports and dashboards based on data from a variety of data sources such as SQL Server, Azure, Oracle, DB2, Teradata databases, SAP, XML,ODBC sources.

Report Builder implements the same Report Designer that is provided by SQL Server Reporting Services (SSRS) and the SQL Server Data Tools (SSDT) development tool.