Wise Owl blogs written by Andy Brown (page 11 of 16)

Showing blogs 201-220 (out of 317)

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.

Tags:   SQL | Calculations    |    T-SQL | New features    |    SQL Server versions | SQL Server 2012

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!

Tags:   SQL | General    |    T-SQL | New features

How to get Excel to speak to you in a female voice, or slower/faster!

Posted by Andy Brown on 13 August 2013

A previous blog showed how to get Excel to speak to you; this one shows how to change the voice in which it does it!

Tags:   Excel | General

How to get Excel to speak to you - reading out the contents of cells

Posted by Andy Brown on 12 August 2013

Deep within its bowels Excel contains a feature allowing it to read out the contents of cells (you can also get your VBA macros to talk to users). This blog goes to those deep places hidden within Excel!

Tags:   Excel | General

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.

Tags:   SSRS | Expressions    |    SQL Server versions | SQL Server 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.

Tags:   SQL | Errors, debugging    |    T-SQL | SQL Tutorial

Want to wind up your neighbour? Try this annoying Excel VBA code!

Posted by Andy Brown on 14 May 2013

If you have a colleague who trusts you, you could always betray this trust by sending them a workbook which misbehaves: it won't close and you can't leave it!

Tags:   Writing VBA | Other    |    VBA macros | Events

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

Posted by Andy Brown on 03 May 2013

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    |    T-SQL | SQL Tutorial

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

Posted by Andy Brown on 03 May 2013

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    |    T-SQL | SQL Tutorial

Variable Scope in Integration Services 2012

Posted by Andy Brown on 16 April 2013

A quick blog on how to change the scope of any variable in SQL Server Integration Services 2012.

Problems connecting to Excel workbook from SSIS

Posted by Andy Brown on 16 April 2013

A short blog explaining why you might have problems connecting to an Excel workbook from SSIS.

Tags:   SSIS | Data flow

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

Problem with using VBA to create chart labels

Posted by Andy Brown on 04 April 2013

If your chart has more than a thousand data labels, this blog explains why you may experience problems.

Tags:   Excel | Charts    |    Writing VBA | Other    |    VBA macros | Working with charts

How to use the RANKX function in PowerPivot

Posted by Andy Brown on 20 March 2013

This blog shows how to use each of the 5 arguments of the RANKX function to rank rows in PowerPivot.

Tags:   PowerPivot 2010 | DAX

Inline and multi-statement table-valued functions

Posted by Andy Brown on 08 February 2013

This blog shows you how to create table-valued functions in SQL (ie functions which return a table of data!).

Tags:   SQL | Programming tables    |    T-SQL | SQL Tutorial

How to create and use table variables in T-SQL

Posted by Andy Brown on 08 February 2013

Table variables allow you to hold rows of data in temporary storage, without any processing overhead. Read this blog to add this technique to your SQL armoury!

Tags:   SQL | Programming tables    |    T-SQL | SQL Tutorial

An overview of PowerPivot for Excel 2010

Posted by Andy Brown on 31 January 2013

PowerPivot is a superb addition to Excel: it allows you to create pivot tables based on multiple tables taken from a variety of data sources, and its DAX language lets you report any statistic you want. This overview summarises how to get started with PowerPivot, and what it does.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | General

What's new in Excel 2013

Posted by Andy Brown on 30 January 2013

Excel 2013 contains radical changes to charts, pivot tables and the user interface. This review explains all the new features of Excel 2013

Tags:   Excel | General

Writing IF and ELSE conditions in SQL

Posted by Andy Brown on 29 January 2013

You can use the IF statement to test conditions in SQL - this blog explains how, and also explains why you might prefer to use CASE WHEN instead.

Tags:   SQL | SQL programming    |    T-SQL | SQL Tutorial

Using @@rowcount and other global variables

Posted by Andy Brown on 28 January 2013

SQL comes complete with a few useful global variables, giving you information such as the row number of the record just inserted, or the number of rows affected by a query. Here's how to use them!

Tags:   SQL | SQL programming    |    T-SQL | SQL Tutorial
This page has 0 threads Add post