| Date |
Item |
| 14/05/2013 |
New blog - Want to wind up your neighbour? Try this annoying Excel VBA code! |
| 14/05/2013 |
Version changes for PowerPoint 2013 published |
| 08/05/2013 |
New blog - Deleting and Updating Records in SQL |
| 03/05/2013 |
New blog - How error messages work in SQL (including TRY, CATCH, RAISERROR and THROW) |
| 03/05/2013 |
New blog - Using OUTER and CROSS APPLY joins to link to table-valued functions |
| 26/04/2013 |
New blog - Output Parameters and Return Codes in SQL Server |
| 23/04/2013 |
New blog - Problems with Shared Datasets and Subreports in SSRS |
| 22/04/2013 |
New blog - Dynamic SQL |
| 16/04/2013 |
New blog - Variable Scope in Integration Services 2012 |
| 16/04/2013 |
New blog - Problems connecting to Excel workbook from SSIS |
| 08/04/2013 |
New blog - Derived Tables in SQL |
| 05/04/2013 |
New blog - SSIS: Executing SQL statement for each file |
| 04/04/2013 |
New blog - The similarities between particle physics and SEO |
| 04/04/2013 |
New blog - Problem with using VBA to create chart labels |
| 26/03/2013 |
New blog - Using Cursors in SQL Server |
| 20/03/2013 |
New blog - How to use the RANKX function in PowerPivot |
| 18/02/2013 |
New blog - Loops in SQL |
| 08/02/2013 |
New blog - Inline and multi-statement table-valued functions |
| 08/02/2013 |
New blog - How to create and use table variables in T-SQL |
| 04/02/2013 |
New blog - Exporting data from SQL Server Management Studio |
| 01/02/2013 |
Wise Owl bite the SQL Server Integration Services bullet! |
| 01/02/2013 |
New blog - Scalar User Defined Functions in SQL Server - UDFs |
| 31/01/2013 |
New blog - An overview of PowerPivot for Excel 2010 |
| 30/01/2013 |
New blog - What's new in Excel 2013 |
| 28/01/2013 |
New blog - Writing IF and ELSE conditions in SQL |
| 28/01/2013 |
New blog - SQL subqueries (including correlated subqueries) |
| 28/01/2013 |
New blog - Using @@rowcount and other global variables |
| 16/01/2013 |
New blog - Creating a PowerPivot calendar in Access or Excel |
| 16/01/2013 |
New blog - Using Criteria in SQL Queries |
| 09/01/2013 |
New blog - A keyboard short-cut for Word previous position |
| 04/01/2013 |
New blog - Create a calendar table for PowerPivot in SQL Server |
| 03/01/2013 |
New blog - Declaring and using SQL variables |
| 17/12/2012 |
New blog - Creating views in T-SQL or in the view designer |
| 14/12/2012 |
New blog - Use the GROUP BY clause in SQL for statistics |
| 11/12/2012 |
New blog - How to do calculations and expressions in T-SQL |
| 10/12/2012 |
New blog - Creating computed columns in SQL tables |
| 30/11/2012 |
New blog - Writing inner joins and outer joins in SQL |
| 23/11/2012 |
Website hugely simplified and redesigned |
| 19/11/2012 |
New blog - SQL Server - create databases, tables and relationships |
| 08/11/2012 |
New blog - Setting SQL criteria using the WHERE clause |
| 02/11/2012 |
New blog - KB2716442 SQL Server 2012 Windows Update fails |
| 02/11/2012 |
New blog - Write a macro in VBA to fill in an IE form (Internet Explorer) |
| 17/10/2012 |
New blog - Generate the database used by the ASP.NET training blog |
| 17/10/2012 |
New blog - Rounding numbers in Excel |
| 17/10/2012 |
New blog - Online training on user controls in ASP.NET |
| 17/10/2012 |
New blog - Why is raising event from C# User Controls so hard? |
| 16/10/2012 |
New blog - ASP.NET session variables, cookies, query string parameters, etc. |
| 15/10/2012 |
New blog - Using ViewState to remember form values in ASP.NET |
| 12/10/2012 |
New blog - Using SELECT INTO and INSERT to insert SQL rows |
| 05/10/2012 |
New blog - Using T-SQL to create tables programmatically |
| 05/10/2012 |
New blog - T-SQL data types - int, float, decimal, varchar, etc. |
| 01/10/2012 |
New blog - Prevent Reporting Services from caching data |
| 01/10/2012 |
New blog - IE compatibility view stops embedded videos running |
| 01/10/2012 |
New blog - Highlighting negative columns in Excel charts |
| 25/09/2012 |
New blog - Why you should develop systems in WPF, not WinForms |
| 24/09/2012 |
50th YouTube video released! |
| 24/09/2012 |
New blog - The Scratch programming language and Code Clubs |
| 24/09/2012 |
New blog - Some ideas for new features for Microsoft Excel 20xx |
| 24/09/2012 |
New blog - Make Google do a barrel roll, show odd directions, etc. |
| 24/09/2012 |
New blog - Translate Facebook into Piratese, or upside-down English |
| 24/09/2012 |
New blog - Using GridView controls to display data in ASP.NET |
| 10/09/2012 |
WPF, SSRS and SharePoint exercises released |
| 07/08/2012 |
New blog - Creating data classes for ASP.NET data controls |
| 06/08/2012 |
New blog - Changing the appearance of parameters in SSRS |
| 06/08/2012 |
New blog - Use SQL, parameters and bookmarks to create a grid of clickable links |
| 06/08/2012 |
New blog - Make an SSRS matrix dynamic, like a pivot table |
| 06/08/2012 |
New blog - Using a Parameter to set the Data Source for a Report |
| 03/08/2012 |
New blog - Two ways to create alternating colours in SSRS |
| 03/08/2012 |
New blog - SSRS custom assemblies using C# or VB |
| 23/07/2012 |
New blog - Using ORDER BY to Sort in SQL Server Queries |
| 23/07/2012 |
New blog - Basic SQL Queries |
| 13/07/2012 |
New blog - How to embed and call VB functions within a Reporting Services report |
| 10/07/2012 |
Advanced SSRS course outline revamped |
| 26/06/2012 |
New blog - Dynamic SQL - No, No, No! |
| 26/06/2012 |
New blog - Link SQL Views to MS Access using VBA |
| 21/06/2012 |
New blog - Reporting Services - report and group variables |
| 21/06/2012 |
New blog - Controlling Shapes in Visio Using Drop Down Lists |
| 13/06/2012 |
New blog - Keyboard short-cuts in SharePoint Designer 2007 |
| 12/06/2012 |
Looking for an additional Wise Owl trainer! |
| 30/05/2012 |
New blog - Using Excel VBA to Label Multiple Series in a Chart |
| 24/05/2012 |
New blog - SQL stored procedures and passing parameters |
| 15/05/2012 |
New blog - Creating a website using CSS - a full worked example |
| 15/05/2012 |
New blog - How to create styles for HTML tags using CSS |
| 15/05/2012 |
New blog - New in SQL 2012 - code snippets and surrounding code |
| 14/05/2012 |
New blog - Creating CSS cascading style sheets for HTML |
| 11/05/2012 |
New blog - Controlling the number of rows per page in Reporting Services |
| 08/05/2012 |
SQL Server 2012 reviewed |
| 08/05/2012 |
New blog - New features for SQL within SQL Server 2012 |
| 08/05/2012 |
New blog - SQL Server Reporting Services 2012 - What's New? |
| 04/05/2012 |
New blog - What is PowerPivot for Excel 2010 - an Overview |
| 01/05/2012 |
New blog - Creating master pages, CSS, skins and themes |
| 30/04/2012 |
New blog - Introduction to SQL Server Management Studio |
| 30/04/2012 |
New PowerPivot 2010 for Excel course launched. |
| 24/04/2012 |
New blog - Tutorial - creating the perfect ASP.NET website |
| 23/04/2012 |
New blog - Wise Owl is 21 years old this year: 1992-2013 |
| 23/04/2012 |
New blog - Designing databases for SQL Server and Access |
| 16/04/2012 |
Anyone can now create custom skills tests |
| 16/04/2012 |
New Squidoo lenses published |
| 30/03/2012 |
New blog - Why the Easter Bunny prefers SQL Server to Access |
| 23/03/2012 |
New blog - Windows Forms or WPF ? Choosing software. |
| 23/03/2012 |
New blog - Finding missing WPF controls in the Toolbox |
| 15/03/2012 |
New blog - Why VB trumps C#, and how trolls don't agree! |
| 08/03/2012 |
Video tutorials section of Wise Owl site created |
| 06/03/2012 |
New blog - Capture Excel application events - event sinks |
| 06/03/2012 |
New blog - How to Delete Digital Certificates from your Computer |
| 06/03/2012 |
New blog - Macro Security and Digital Certificates in VBA |
| 05/03/2012 |
New blog - Collections of class object using Excel VBA |
| 05/03/2012 |
New blog - Using Excel Add-Ins to Share VBA Code |
| 05/03/2012 |
New blog - Creating classes in VBA - class modules |
| 02/03/2012 |
New blog - Using Calendars in Microsoft Project 2010 |
| 28/02/2012 |
New blog - Protecting Worksheets and Workbooks in Excel |
| 28/02/2012 |
New blog - Using Data Validation in Microsoft Excel |
| 28/02/2012 |
New blog - Advanced controls in userforms with VBA macros |
| 27/02/2012 |
New blog - Writing VBA macros to work with user forms |
| 27/02/2012 |
New blog - Scheduling Data Imports in SQL Server |
| 27/02/2012 |
Better skills assessment test charts |
| 27/02/2012 |
New blog - Using Scenarios in Microsoft Excel |
| 27/02/2012 |
New blog - Drawing UserForms in the VBA code editor |
| 24/02/2012 |
New blog - Goal Seeking in Microsoft Excel |
| 24/02/2012 |
New blog - Writing functions for Excel using VBA |
| 24/02/2012 |
New blog - Using enumerations in VBA |
| 24/02/2012 |
New blog - Arrays in Visual Basic for Applications macros |
| 24/02/2012 |
New blog - Using Styles in Microsoft Excel |
| 24/02/2012 |
New blog - Reporting Services date parameter formats |
| 20/02/2012 |
New blog - Writing recursive programs in VBA |
| 16/02/2012 |
New blog - How to Edit all Records in a SQL Server 2008 Table |
| 16/02/2012 |
New blog - Calculating Age in SQL with a User-Defined Function |
| 16/02/2012 |
New blog - Changing Settings in SQL Server Management Studio |
| 13/02/2012 |
New blog - Free SQL training course | SQL tutorial |
| 13/02/2012 |
New blog - Dates and Times in SQL Server |
| 09/02/2012 |
Advanced Visual Basic and C# courses launched |
| 09/02/2012 |
Visual Basic for the under-16s (Small Basic) |
| 09/02/2012 |
Reporting Services - maps added to course |
| 09/02/2012 |
WPF (Windows Presentation Foundation) courses |
| 09/02/2012 |
New blog - Passing arguments to subroutines in VBA |
| 06/02/2012 |
New blog - Linking to ADO databases with VBA |
| 30/01/2012 |
New blog - Making Reporting Services reports refresh automatically |
| 23/01/2012 |
New blog - Copy, rename, delete and move files and folders |
| 13/01/2012 |
New blog - Reading and writing to/from a text file using TextStreams |
| 13/01/2012 |
New blog - Linking to the Microsoft Scripting Runtime library |
| 13/01/2012 |
New blog - How to choose files and folders in VBA |
| 12/01/2012 |
Update to VB and C# 2010 for WinForms complete |
| 12/01/2012 |
New blog - Customising Microsoft Project |
| 12/01/2012 |
New blog - Custom Reports in Microsoft Project |
| 12/01/2012 |
New blog - Custom Views in Microsoft Project |
| 12/01/2012 |
New blog - Custom Tables in Microsoft Project |
| 03/01/2012 |
New blog - Creating references programmatically in VBA |
| 03/01/2012 |
New blog - Importing Bank Holidays into the Outlook Calendar |
| 15/12/2011 |
New blog - Ten Useful Applications That You Can Get For Free |
| 14/12/2011 |
New blog - 10 reasons why Santa Claus does not use Project |
| 09/12/2011 |
New blog - Using CreateObject and GetObject to create references |
| 05/12/2011 |
New blog - Referencing Word and other applications in Excel VBA |
| 02/12/2011 |
New blog - 10 Excel Quick Tips |
| 29/11/2011 |
New blog - Error-handling and error trapping in Excel Visual Basic macros |
| 25/11/2011 |
New blog - Debugging macros in Excel Visual Basic / VBA |
| 22/11/2011 |
New blog - Event-handling macros in Excel Visual Basic |
| 15/11/2011 |
New blog - Looping in Visual Basic for Applications macros |
| 15/11/2011 |
New blog - Conditions in Visual Basic for Applications - IF and SELECT CASE |
| 11/11/2011 |
SEO consultancy for managers available |
| 11/11/2011 |
New Advanced Reporting Services 2-day course |
| 10/11/2011 |
New blog - How to Create Custom Charts in Microsoft Excel |
| 10/11/2011 |
New blog - Setting the Default Chart Type in Microsoft Excel |
| 09/11/2011 |
New blog - Collections, objects, methods and properties in Excel VBA |
| 09/11/2011 |
Report Builder 3.0 training course launched |
| 09/11/2011 |
SharePoint 2010 end user course available |
| 08/11/2011 |
Skills Assessment tests averaging 150 per day |
| 07/11/2011 |
New blog - Differences between Report Builder and Reporting Services |
| 07/11/2011 |
New blog - Multivalue parameters in Reporting Services |
| 31/10/2011 |
New blog - Install Report Builder 3.0 despite .NET 3.5 Framework error |
| 31/10/2011 |
New blog - How To Create Custom Date Formats in Microsoft Excel |
| 20/10/2011 |
New blog - Common Table Expressions (CTEs) - SQL Training |
| 20/10/2011 |
New blog - Temporary Tables in SQL - a Training Blog |
| 19/10/2011 |
New blog - Using Icon Sets for conditional formatting in Microsoft Excel 2007 |
| 19/10/2011 |
New blog - Conditional formatting with Data Bars in Microsoft Excel 2007 |
| 19/10/2011 |
New blog - How to apply Conditional Formatting in Microsoft Excel |
| 12/10/2011 |
New blog - How to Remove Duplicates from a List in Microsoft Excel |
| 10/10/2011 |
New blog - Why you should program in Visual Basic, not Visual C# |
| 10/10/2011 |
New blog - Using ClientIdMode to name web server controls |
| 03/10/2011 |
New blog - Using the InputBox Function in VBA Macros |
| 03/10/2011 |
New blog - Using Fractions in Microsoft Excel |
| 28/09/2011 |
New blog - Using MsgBox to Display Messages in VBA Macros |
| 19/09/2011 |
New blog - How To Make Part Of An Image Transparent In Microsoft PowerPoint |
| 19/09/2011 |
New blog - Choosing Colours In Microsoft Office Applications |
| 19/09/2011 |
New blog - Overview of Data Controls in ASP.NET 4.0 |
| 07/09/2011 |
New blog - Changing Form Appearance in Access 2007 and 2010 |
| 05/09/2011 |
New blog - Variables and Constants in Excel Visual Basic |
| 24/08/2011 |
New blog - Review of VB.NET Data Storage Structures |
| 22/08/2011 |
New blog - Using the VLOOKUP Function in Excel to Calculate Exam Grades |
| 22/08/2011 |
New blog - Using Range Names in Excel |
| 17/08/2011 |
New blog - Select All The Text In A PowerPoint Presentation |
| 17/08/2011 |
New blog - Stop Text Changing Size in PowerPoint |
| 16/08/2011 |
New blog - Excel Macros Tutorial | Excel VBA training course |
| 16/08/2011 |
New blog - Relative Selection using Excel VBA Macros |
| 11/08/2011 |
New blog - Selecting Cells using Excel VBA Macros - Absolute |
| 08/08/2011 |
New blog - Gradient Fill Colours for SSRS 2008 Chart Data Series |
| 02/08/2011 |
New blog - Changing Visual Studio default settings for ASP.NET |
| 01/08/2011 |
New blog - Using the Organizer in Microsoft Project |
| 01/08/2011 |
New blog - Custom Fields in Microsoft Project |
| 27/07/2011 |
New blog - Creating animation triggers in PowerPoint |
| 26/07/2011 |
New blog - Number format bug in SSRS 2008 R2 |
| 26/07/2011 |
New blog - Repeating Page Headers in Reporting Services 2008 R2 |
| 26/07/2011 |
New blog - Fixing page titles during scrolling in SSRS 2008 R2 |
| 25/07/2011 |
New blog - Exporting SSRS Reports to Excel using RenderFormat |
| 25/07/2011 |
New blog - Free tutorial - Gauges in SSRS Reporting Services |
| 25/07/2011 |
New blog - Free Tutorial in Indicators in SSRS 2008 R2 |
| 21/07/2011 |
New blog - Inserting in-line keys in HTML using CSS |
| 01/07/2011 |
New blog - Compressing pictures in Microsoft PowerPoint 2007 |
| 01/07/2011 |
New blog - Using VBA in Microsoft Project to Set Up Unusual Calendars |
| 01/07/2011 |
New blog - Introduction to Visual Basic for Applications (VBA) |
| 01/07/2011 |
New blog - Assigning short-cut keys to VBA macros in Excel |
| 30/06/2011 |
New blog - Displaying the Developer Ribbon in Excel 2010 |
| 30/06/2011 |
New blog - Recording macros in Excel Visual Basic - VBA Macros |
| 27/06/2011 |
New blog - Top 15 Short-Cut Keys in Microsoft Word |
| 23/06/2011 |
New blog - Baseline Taskbar bug in Microsoft Project 2010 |
| 15/06/2011 |
New blog - Creating a Picture Frame Effect for Images in Microsoft Publisher |
| 15/06/2011 |
New blog - Creating Custom Stencils and Custom Shapes in Microsoft Visio |
| 14/06/2011 |
New blog - How to Draw a Jigsaw Puzzle in Microsoft PowerPoint |
| 14/06/2011 |
New blog - How To Create a Self-Running PowerPoint Presentation |
| 08/06/2011 |
New blog - Adding data labels to a chart using VBA |
| 06/06/2011 |
New blog - Changing the Legend in a Microsoft Project Gantt Chart |
| 01/06/2011 |
New blog - Conditional Formatting in Microsoft Project Gantt Charts |
| 01/06/2011 |
New blog - Using sheet codenames in Microsoft Excel VBA |
| 31/05/2011 |
New blog - Using SQL UNION queries to populate the first Item in a list type control |
| 31/05/2011 |
New blog - Rolling Up Tasks in Microsoft Project |
| 31/05/2011 |
New blog - Shortcuts for changing Project 2010 task types |
| 17/05/2011 |
New blog - Problems with Outlining in SSRS 2008 R2 |
| 16/05/2011 |
New blog - Data Structures in SQL Server Analysis Services |
| 10/05/2011 |
New blog - Visual Studio - Recent Projects not Showing Up |
| 28/04/2011 |
Wise Owl blog goes live! |
| 28/04/2011 |
New blog - Commenting out code in VBA |
| 22/02/2011 |
Wise Owl Blog ready for testing |
| 04/01/2011 |
January 2011 newsletter sent out |
| 21/12/2010 |
New blog - Access project ADP file extended properties error |
| 17/12/2010 |
New skills assessment site launched |
| 28/11/2010 |
New blog - Capturing text using SnagIt |
| 02/11/2010 |
Intermittent downtime problem sorted |
| 29/10/2010 |
Facebook "Like it" button added |
| 30/09/2010 |
Twitter launched |
| 14/09/2010 |
RSS news feed created |
| 02/09/2010 |
September newsletter sent out |
| 01/09/2010 |
Wise Owl are on FaceBook |
| 31/08/2010 |
Credit card payments online |
| 30/08/2010 |
Office 2010 courses launched |
| 30/08/2010 |
Website revamp |
| 30/08/2010 |
Visual Studio Tools for Office course launched |
| 30/08/2010 |
SSRS 2008 R2 course launched |