This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Wise Owl Blogs - Home (page 22 of 25)

Showing blogs 421-440 (out of 487)

Common Table Expressions are even better than I'd realised, as this blog shows

Posted by Andy Brown on 01 February 2016

CTEs (or Common Table Expressions) allow you to divide complicated queries up into two or more simple discrete tasks, as this blog explains.

Tags:
SQL > CTEs, subqueries T-SQL > Other

A short blog listing many ways to create aliases for columns in SQL

Posted by Andy Brown on 01 February 2016

It's not often that this owl learns new things about SQL when giving a course, but when I do, I like to share my new knowledge! This blog shows a new way to create aliases for columns in SQL.

Tags:
SQL > Selecting data T-SQL > Other

How to create dynamic connection strings in Integration Services packages

Posted by Andy Brown on 08 January 2016

It's often useful to make connections point to different Excel workbooks or SQL Server databases, depending on the value you set for variables or parameters. This blog shows the underlying principle - it's up to you then to apply this in your workplace!

Tags:
SSIS > General SSIS SSIS > Data flow

Referring to a range using square brackets

Posted by Andy Brown on 17 December 2015

This short blog shows that there is a third way to refer to a range, other than using the RANGE or CELLS keywords.

Tags:
VBA macros > Working with ranges Writing VBA > Other

This blog explains the lesser known but better Excel VBA InputBox function

Posted by Andy Brown on 17 December 2015

There are two ways you can display an input box using Excel macros: the standard VBA InputBox function, or the much better (but lesser known, at least by this blog's author) Application.InputBox function.

Tags:
VBA macros > Input/message boxes Writing VBA > Other

Disabling Screen Updates in Excel VBA

Posted by Andrew Gould on 26 November 2015

You can give your VBA code a performance boost by simply turning off screen updating while your code runs. This blog explains how to achieve this and how to create a basic timer to test the results.

Tags:
VBA macros > General Writing VBA > Other

How and when to use the Execute SQL task PARSE QUERY button in SSIS

Posted by Andy Brown on 18 September 2015

A short blog explaining how the Parse Query property and BypassPrepare property for an SSIS task are related.

Tags:
SSIS > Data flow

How to lay out diagrams in SSIS packages to look neat

Posted by Andy Brown on 04 September 2015

Arrows in your Integrated Services packages can go all over the place - learn how to control them in this short blog on formatting SSIS diagrams.

Tags:
SSIS > General SSIS

Ideas for encrypting data in transit in SSIS

Posted by Andy Brown on 08 February 2015

How can you encrypt data flowing within an Integration Services package? We don't think you can, but here are a couple of ideas.

Tags:
SSIS > Data flow

How to send an email to every person in a SQL Server table

Posted by Andy Brown on 30 January 2015

This blog explains how to send an email to every person returned from a SQL query.

Tags:
SSIS > General SSIS

How to refer to parameters by name, not number, in SSIS

Posted by Andy Brown on 30 January 2015

Referring to parameters by their numeric position in a list in SSIS is relatively easy, but there is a way to refer to them by name too, as explained in this blog.

Tags:
SSIS > Parameters

Getting at file attributes from FOREACH loop in SSIS

Posted by Andy Brown on 30 January 2015

SSIS makes it easy to loop over files, but it's less obvious how to get at file attributes such as the date created or last modified date. To do this you'll need a scripting task, as explained by this blog.

Tags:
SSIS > Files and folders

Steps to follow when creating a new flat file in SSIS

Posted by Andy Brown on 04 December 2014

Using an existing flat file in SSIS is straightforward, but creating a new one can be a pain - this blogs gives some steps to follow.

Tags:
SSIS > Data flow

Free C# training

Posted by Andrew Gould on 31 October 2014

This blog serves as the main index for our complete tutorial on programming in Visual C#. You'll find links to all of the articles, videos and files that you'll need to follow the tutorial.

Tags:
Visual C# > General

Addiction to the 2048 mobile phone app

Posted by Andy Brown on 07 July 2023

One owl's sad story of addiction to a simple computer game: a tale of lost time and lost sanity.

Tags:
Miscellaneous > Random musings

VBA code to create a chart and textbox, and copy them to Word

Posted by Andy Brown on 03 October 2014

Charts in VBA are a bit weird: this blogs highlights some of their foibles, by showing how charts are really just special shapes, which contain shapes of their own!

Tags:
VBA macros > Working with charts VBA macros > References

Programmatically searching websites using VBA

Posted by Andy Brown on 15 September 2014

I've already pinched (with permission!) the ideas of Fergus Cairns to explain ways to run automatic searches on popular websites like Google; this blog gives an update on the same topic.

Tags:
VBA macros > References Writing VBA > Other

What does the SCD transform in SSIS do, and should you use it?

Posted by Andy Brown on 05 July 2014

Integration Services include a Slowly Changing Dimension transform, which is designed to make loading dimension data easier. This blog explains how it works, and discusses whether it achieves its objectives.

Tags:
SSIS > SCD transforms

Revealing how Excel workbooks are actually stored as zipped XML files

Posted by Andy Brown on 16 May 2014

Did you know that Excel workbooks are really just a collection of XML files, all zipped together? We didn’t either, so we thought we'd tell the world.

Tags:
Excel > General Miscellaneous > Random musings

Flappy Bird in Excel VBA Part 13 - Playing Sounds

Posted by Andrew Gould on 24 April 2014

This part of the tutorial explains how to add sounds to the game using a Windows API function.

Tags:
VBA macros > Flappy Owl Writing VBA > Flappy Owl

This page has 0 threads

Add a new post

BLOGS BY TOPIC

BLOGS BY AUTHOR

Wise Owl Blogs - Home (page 22 of 25)

Common Table Expressions are even better than I'd realised, as this blog shows

A short blog listing many ways to create aliases for columns in SQL

How to create dynamic connection strings in Integration Services packages

Referring to a range using square brackets

This blog explains the lesser known but better Excel VBA InputBox function

Disabling Screen Updates in Excel VBA

How and when to use the Execute SQL task PARSE QUERY button in SSIS

How to lay out diagrams in SSIS packages to look neat

Ideas for encrypting data in transit in SSIS

How to send an email to every person in a SQL Server table

How to refer to parameters by name, not number, in SSIS

Getting at file attributes from FOREACH loop in SSIS

Steps to follow when creating a new flat file in SSIS

Free C# training

Addiction to the 2048 mobile phone app

VBA code to create a chart and textbox, and copy them to Word

Programmatically searching websites using VBA

What does the SCD transform in SSIS do, and should you use it?

Revealing how Excel workbooks are actually stored as zipped XML files

Flappy Bird in Excel VBA Part 13 - Playing Sounds

Head office

London

Manchester