This page has 0 threads | Add post

Blogs

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

SQL and SQL Server blogs from Wise Owl (page 3 of 4)

Showing blogs 41-60 (out of 62)

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

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

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

A blog to accompany our YouTube tutorial on script components in SSIS

Posted by Andy Brown on 19 February 2014

This blog provides the SQL, C# and VB script needed for the Integration Services script components tutorial.

Tags:
SSIS > Scripting

Problems with Shared Datasets and Subreports in SSRS

Posted by Andrew Gould on 23 April 2013

If you're using shared datasets to populate subreports in Reporting Services you might have encountered an error when you preview your reports. This short blog explains what the problem is and offers a few simple suggestions to work around the issue.

Tags:
SSRS > Lists, subreports

SSIS: Executing SQL statement for each file

Posted by Andy Brown on 05 April 2013

How to store the name of each file in a folder in a SQL Server table using an Integration Services package.

Tags:
SSIS > Files and folders SSIS > Variables, expressions

Prevent Reporting Services from caching data

Posted by Andy Brown on 01 October 2012

By default SSRS will create files with extension .rdl.data to cache data. This blog gives two and a half ways to ensure you're always seeing the latest data in a report.

Tags:
SSRS > General

Use SQL, parameters and bookmarks to create a grid of clickable links

Posted by Andy Brown on 06 August 2012

To make report navigation easier, you can create a 2-dimensional matrix of clickable links at the top of a report. This blog shows you how!

Tags:
SSRS > Matrices SQL > Stored procedures T-SQL > Other

Make an SSRS matrix dynamic, like a pivot table

Posted by Andy Brown on 06 August 2012

Create a matrix whose row, column and data fields are all selectable from dropdown lists.

Tags:
SSRS > Matrices

Using a Parameter to set the Data Source for a Report

Posted by Andy Brown on 06 August 2012

A single report in Reporting Services can serve many masters. This blog shows how to allow a user to choose which data a report should display, using a dropdown parameter.

Tags:
SSRS > Parameters SSRS > Linking to data

Reporting Services - report and group variables

Posted by Andy Brown on 21 June 2012

If you're not sure when - or whether - you should be using report or group variables in SSRS, read this blog to find out how to speed up your reports and solve other problems.

Tags:
SSRS > Variables

Controlling the number of rows per page in Reporting Services

Posted by Andrew Gould on 11 May 2012

Unfortunately, Reporting Services doesn't have a simple setting that allows you to control the number of rows you see on each page. However, you can control this using a clever combination of an expression with a grouping level. Read this blog to find out how!

Tags:
SSRS > Tables SSRS > Designing reports

This page has 0 threads

Add a new post

BY TOPIC