BY TOPIC▼
SQL SERVER BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
SQL Server blogs from Wise Owl (page 5 of 9)
Showing blogs 81-100 (out of 175)
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.
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.
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.
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.
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.
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.
What's new in Analysis Services 2012 versus 2008 R2
Posted by Andy Brown on 19 December 2014
If you're creating multidimensional models (as you probably will be), Analysis Services has barely changed between versions 2008 R2 and 2012 - and the small differences are mostly in the favour of the older version. This blog plays spot-the-difference between Analysis Services 2008 R2 and 2012.
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.
A short blog showing that SSIS 2014 is the same as 2012
Posted by Andy Brown on 27 November 2014
Possibly the shortest Wise Owl blog, listing the changes between Integration Services 2012 and 2014 (there aren't any!).
A detailed blog exploring what's new in SSIS 2012
Posted by Andy Brown on 27 November 2014
If you're wondering whether to upgrade to Integration Services 2012, or just want to know what differences there are between SSIS 2008 R2 and 2012, this blog should help you!
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.
Posted by Andrew Gould on 09 June 2014
Using the Pivot operator in SQL Server allows you to create basic pivot tables from your query results. This blog teaches you how to create simple, static pivots, crosstab-style tables and exciting, dynamic pivot tables.
Thoughts on working with SSIS 2008 and SSIS 2012
Posted by Andy Brown on 12 March 2014
Some thoughts and advice to those who have to shuffle between versions 2012 and 2008 of Integration Services.
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.
Posted by Andrew Gould on 27 November 2013
Triggers are special stored procedures that execute automatically in response to certain events in a database. This blog explains how to create three types of trigger in SQL Server: DML, DDL and Logon triggers.
Posted by Andrew Gould on 11 October 2013
This blog examines how to use Transactions in Microsoft SQL Server to allow you to control when data changes are committed to the database. You'll also discover how you can rollback transactions, effectively giving you the chance to undo changes to your data.
How to use the LAG and LEAD functions included in SQL Server 2012
Posted by Andy Brown on 20 September 2013
SQL Server 2012 introduces new functions to find the previous or subsequent value for a row, without using a complicated self-join. This blog explains how to use LAG and LEAD, including partitioning row sets.
Wise Owl suggestions for new features for SQL Server Management Studio
Posted by Andy Brown on 09 September 2013
Writing SQL in Management Studio could, Wise Owl feel, be made a little easier: here are 10 practical suggestions for how!
Differences between SSRS 2008 R2 and 2012 for Excel render format
Posted by Andy Brown on 17 June 2013
This blog shows how to conditionally hide, display or format parts of a report according to its render format (ie whether you're viewing it in Excel or not). The method used is slightly different between 2008 R2 and 2012.
How to debug T-SQL queries and stored procedures
Posted by Andy Brown on 06 June 2013
This blog gives the low-down on how to start and use the debugger included in SQL Server Management Studio 2008 R2 and SSMS 2012.