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 - 20/6/2024
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 - 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 - 13/1/2020
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:
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.
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.
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.
Merging Shapes using Microsoft PowerPoint
There are occasions when you can’t quite find the shape you’re looking for. With the Merge Shape tools, you are able to construct your own shapes. This blog will take you through the steps to creating your own shapes using the Union command from the Merge Shape Tools.