SQL Server blogs from Wise Owl (page 1 of 5)

Showing blogs 1-20 (out of 90)

What's new in Analysis Services 2012 versus 2008 R2

Posted by Andy Brown on 19 December 2014 | no comments

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.

Tags:   SQL Server 2012 | SSAS 2012    |    SSAS | General

Steps to follow when creating a new flat file in SSIS

Posted by Andy Brown on 04 December 2014 | no comments

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

A short blog showing that SSIS 2014 is the same as 2012

Posted by Andy Brown on 27 November 2014 | no comments

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 | no comments

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!

Tags:   SSIS | General SSIS    |    SQL Server 2012 | SSIS 2012

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

Posted by Andy Brown on 05 July 2014 | no comments

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

Pivoting Data in SQL Server

Posted by Andrew Gould on 09 June 2014 | no comments

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.

Tags:   SQL | Dynamic SQL    |    SQL | CTEs, subqueries

Thoughts on working with SSIS 2008 and SSIS 2012

Posted by Andy Brown on 12 March 2014 | no comments

Some thoughts and advice to those who have to shuffle between versions 2012 and 2008 of Integration Services.

Tags:   SSIS | General SSIS

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

Posted by Andy Brown on 19 February 2014 | no comments

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

Tags:   SSIS | Scripting

Triggers in SQL Server

Posted by Andrew Gould on 27 November 2013 | no comments

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.

Tags:   SQL | General

Transactions in SQL Server

Posted by Andrew Gould on 11 October 2013 | no comments

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.

Tags:   SQL | Transactions

How to use the LAG and LEAD functions included in SQL Server 2012

Posted by Andy Brown on 20 September 2013 | no comments

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.

Tags:   SQL | Calculations    |    SQL Server 2012 | SQL 2012

Wise Owl suggestions for new features for SQL Server Management Studio

Posted by Andy Brown on 09 September 2013 | no comments

Writing SQL in Management Studio could, Wise Owl feel, be made a little easier: here are 10 practical suggestions for how!

Tags:   SQL | General

Differences between SSRS 2008 R2 and 2012 for Excel render format

Posted by Andy Brown on 17 June 2013 | no comments

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.

Tags:   SSRS | Expressions    |    SQL Server 2012 | SSRS 2012

How to debug T-SQL queries and stored procedures

Posted by Andy Brown on 06 June 2013 | no comments

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.

Tags:   SQL | Errors, debugging

Deleting and Updating Records in SQL

Posted by Andrew Gould on 08 May 2013 | no comments

This blog teaches you how to modify existing data in your database by either deleting records or updating them.

Tags:   SQL | Transactions

How error messages work in SQL (including TRY, CATCH, RAISERROR and THROW)

Posted by Andy Brown on 03 May 2013 | no comments

You can use BEGIN TRY to trap errors from SQL Server 2005 onwards, and also raise your own errors using RAISERROR or THROW - this blog explains all!

Tags:   SQL | Errors, debugging

Using OUTER and CROSS APPLY joins to link to table-valued functions

Posted by Andy Brown on 03 May 2013 | no comments

For the sake of completeness, this blog explains how to join to the results of table-valued functions (like a correlated subquery on steroids).

Tags:   SQL | Joins    |    SQL | Functions

Output Parameters and Return Codes in SQL Server

Posted by Andrew Gould on 26 April 2013 | no comments

This blog teaches you how to return values from your SQL stored procedures using two different techniques: return codes, and output parameters.

Tags:   SQL | Stored procedures

Problems with Shared Datasets and Subreports in SSRS

Posted by Andrew Gould on 23 April 2013 | no comments

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

Dynamic SQL

Posted by Andrew Gould on 22 April 2013 | no comments

Dynamic SQL is a technique for building valid SQL statements from separate pieces of text. You can use this technique to create remarkably flexible and useful queries, as long as you're aware of the potential danger of SQL injection attacks.

Tags:   SQL | Dynamic SQL