Wise Owl blogs written by David Wakefield

Showing blogs 1-5 (out of 5)

Resolving a problem with SSRS and a Windows 10 update

Posted by David Wakefield on 18 June 2018

After installing Windows 10 our laptops started returning a 503 error in Web Portal - this blog shows how to resolve this.

Tags:   SSRS | General

How to get the custodians of your data to give you access!

Posted by David Wakefield on 18 June 2018

GDPR isn't as restrictive as most commentators claim, as this blog sets out to show. Don't let data custodians block you from analysing your corporate data!

Tags:   Musings | General IT

Dynamic SQL - No, No, No!

Posted by David Wakefield on 02 July 2012

Dynamic SQL should only be used as a last resort. This article gives you a tip for avoiding the use of dynamic SQL in WHERE clauses

Tags:   SQL | Selecting data    |    SQL | WHERE criteria    |    SQL | Dynamic SQL    |    T-SQL | Other

Link SQL Views to MS Access using VBA

Posted by David Wakefield on 26 June 2012

How to link SQL Views and Tables to MS Access using VBA without getting the annoying Unique Record Identifier pop up.

Tags:   SQL | Views    |    Access | Importing and linking    |    T-SQL | Other

Using SQL UNION queries to populate the first Item in a list type control

Posted by David Wakefield on 31 May 2011

Adding a first or default item to a list control which gets its data from a table can be tricky. This blog gives an elegant solution using UNION queries, which works equally well for ASP.NET dropdown controls, Windows Forms dropdowns or Access combo boxes.

Tags:   SQL | Selecting data    |    Access | Forms and subforms    |    ASP.NET webforms | ADO.NET and data    |    T-SQL | Other
This page has 0 threads Add post