This page has 0 threads | Add post

Blogs

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

Wise Owl blogs written by Andy Brown (page 18 of 20)

Showing blogs 341-360 (out of 383)

A summary of the Power BI Updates going back to November 2016

Posted by Andy Brown on 19 December 2016

This blog differs from the Microsoft update summary in two ways: it omits preview and obscure changes, but goes into more detail (and gives practical examples) on mainstream updates.

Tags:
Power BI > Updates

How to create running totals or cumulative figures in Power BI Desktop

Posted by Andy Brown on 19 December 2016

There are a host of date-based functions in Power BI Desktop for producing cumulative figures, but how do you get running totals for non-date columns? This blog explains!

Tags:
Power BI > Measures / DAX

Passing parameters to SQL stored procedures in Power BI Desktop

Posted by Andy Brown on 30 November 2016

This blog summarises how to run SQL statements in a Power BI Desktop query, using dynamic SQL to pass in parameter values

Tags:
Power BI > Parameters

How to use the FOR XML keywords in SQL to concatenate ids

Posted by Andy Brown on 27 September 2016

If you want to group items in a SQL query, showing a comma-delimited list of ids for each, generating an XML file is not the obvious place to start - but it should be.

Tags:
SQL > General

How to get Excel to read out cell values on calculation

Posted by Andy Brown on 26 September 2016

A short blog explaining how you can get Excel to read out values in cells every time that you recalculate a worksheet.

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

How to post comments onto the Wise Owl website

Posted by Andy Brown on 09 September 2016

If you want to initiate (or take part in) a discussion on our website, you'll first need to create a post - and to do that, you'll need to register on our site. This blog explains how to do both these things!

Tags:
Miscellaneous > Random musings

Using SSIS to loop over the worksheets in an Excel workbook, importing each

Posted by Andy Brown on 07 April 2016

Looping over Excel workbooks is one thing, but how can you loop over all of the worksheets in a single workbook, importing the contents of each? This blog explains the steps you need to follow.

Tags:
SSIS > Files and folders

Unpivoting data in SSIS using the Unpivot transformation

Posted by Andy Brown on 07 April 2016

If you've been given the output from a pivot table or a cube, you can collapse it back into its original state using the UNPIVOT transform in Integration Services.

Tags:
SSIS > Data flow

In SSMS, how to add multiple aliases to tables using the ALT key

Posted by Andy Brown on 23 March 2016

It's only a small thing, but … this blog shows how you can click and drag with the ALT key held down, then type to apply a table alias to lots of tables simultaneously.

Tags:
SQL > Tables and columns T-SQL > Other

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

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

This page has 0 threads

Add a new post

BLOGS BY TOPIC

BLOGS BY AUTHOR

Wise Owl blogs written by Andy Brown (page 18 of 20)

A summary of the Power BI Updates going back to November 2016

How to create running totals or cumulative figures in Power BI Desktop

Passing parameters to SQL stored procedures in Power BI Desktop

How to use the FOR XML keywords in SQL to concatenate ids

How to get Excel to read out cell values on calculation

How to post comments onto the Wise Owl website

Using SSIS to loop over the worksheets in an Excel workbook, importing each

Unpivoting data in SSIS using the Unpivot transformation

In SSMS, how to add multiple aliases to tables using the ALT key

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

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

Head office

London

Manchester