Top Tips

Here you can find a selection of guides and top tips, predominantly based on questions that have been asked in the classroom.  Take a look at our blog for more Top Tips and items of interest.

SQL Server Tips & Examples

 SQL Query - Day of the week for 1st and last day of month

 Business Benefits From Microsoft SQL Server Business Intelligence Solutions

 SQL Query - Week number of order date and last day and weekday of orders month

 SQL Query - Calculate age of employee

 SQL Query - Difference between 2 dates in years, months and days

 SQL SSRS - Export to Excel With Each Region on a Separate Named Worksheet

 SQL SSRS - Repeat Page Headers On Every Page

 SQL SSRS - Working With Charts

 SQL Server Audit & Security - Password & Privlege Checking

 SQL Server & Virtualisation

 SQL Server SQL CROSS APPLY Statement

 Top Queries IO Usage

 Request & Session Resource Usage

 SQL Server - Display Details of Automatic File Growths

 SQL - Display List of Indexes With Columns

 SQL Server - Create Detail from Summary Data

 SQL Server Aggregate Functions and OVER

 SQL Server EXECUTE Statement With RESULT SET Clause

Microsoft Excel Tips & Examples

 Excel Time Savers

 Excel Function Keys

 Excel - Using INDIRECT Functions

 Excel - Using COUNTIFS Function

 Working With Dates in Excel

 Excel Conditional Formatting

 Freezing Panes

 IFERROR

 Excel Week & Working Day Counts

Microsoft Word Tips & Examples

 Microsoft Word Top Tips

 Word Keyboard Shortcuts

Oracle Tips & Examples

 Extracting Words in Oracle

 Extracting Last Word in Oracle

VBA Tips & Examples

 MDX Ranking & Ordering

 VBA Functions in MDX Scripts

 VBA Integer Arithmetic Problem

 Excel VBA Row & Region Selection Tips