SSMS 2016 New Feature – Compare Query Execution Plans
Management Studio in SQL Server 2016 has introduced a great new feature: Compare Showplan.
by Mandy Doward - 15/10/2024
Customised, bespoke training designed for you and with you!
We offer more than just a schedule of courses. You tell us what you want and we do our best to put it together for you.
We have been busy over the last few months!
We offer you:
by Mandy Doward - 20/8/2018
SQL Queries to Retrieve Records from Multiple Tables
Relational databases store data in tables and we can retrieve information with SQL SELECT statements accessing one or more tables.
by Mandy Doward - 9/6/2016
Display SQL Server Index Details – Type, Key Columns, Included Columns
Have you ever wanted a query that would give you a list of all the indexes that exist in your database along with details of the index type and all the columns that are a part of the index key and all included columns?
Well have a look at this query. It might help:
by Mandy Doward - 9/6/2016
In this article “Excel is more than a calculator! - Part 2” we will be looking at Pivot Tables, Pivot Charts and Filters. If you have never used these before prepare to be impressed!
Microsoft Excel Pivot Tables & Pivot Charts
Pivot Tables and Pivot Charts enable you to explore your data and analyse business measurements in different ways, for example:
by Mandy Doward - 20/6/2024
Introduction to Microsoft Office Training Course
We have now introduced a new entry level Microsoft Office course “Introduction to Microsoft Office” aimed at those who are completely new to Microsoft Office or need a refresher of the basics:
by Mandy Doward - 25/5/2016
So How Old is Unix?
47 Years Old!!!
And how old is Windows (Server version)? 23 years old.
UNIX is twice the age of Microsoft Windows (Server version)!
by Mandy Doward - 20/6/2024
Get More From Your Business Data
We are seeing an increasing number of our clients wanting to get more out of their databases and as a result we are seeing an increase in demand for business intelligence and data analysis courses.
by Mandy Doward - 9/5/2016
Find out about reports that are being executed on your SSRS Server
Are you being asked questions about reports running on your SSRS servers?
by Mandy Doward - 10/6/2016
Microsoft Word Tables
Microsoft Word offers a very powerful table feature, but it can be a bit of an art working with tables sometimes. In a series of blogs I aim to run through some simple, but essential tasks when working with tables in Word.
It is easy enough to copy and paste a data set into Word from a source such as a Microsfot Excel workbook as a lot of default formats are applied when the data is pasted, but formatting it to your requirements is then often the challenge.
In Working with Tables in Microsoft Word - Part 1 we will look at: