Blogs by Andy Brown
Showing blogs 1-20 (out of 144)
You can get at all sorts of system information within Visual Basic for Applications by using environment variables - this blog shows you how to get at your user's name, computer name and much more besides.
A short blog explaining how to use Visual Basic for Applications to loop over enumerations.
The RANKX function works out where a measure lies in order for any dimension, but it has a couple of gotchas to watch out for, as this blog explains.
Range names can have either worksheet or workbook scope - this blog shows how to make sure that you're referring to the right range names!
A short blog showing how to stop Excel hiding duplicate values for pivot table groups.
The SUMPRODUCT function is one of the hardest ones to understand in Excel, but it's also pretty useful. This blog gives clear examples of how to use SUMPRODUCT for conditional sums, weighted averages and the like.
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.
Writing SQL in Management Studio could, Wise Owl feel, be made a little easier: here are 10 practical suggestions for how!
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!
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!
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.
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.
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!
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!
For the sake of completeness, this blog explains how to join to the results of table-valued functions (like a correlated subquery on steroids).
A quick blog on how to change the scope of any variable in SQL Server Integration Services 2012.
A short blog explaining why you might have problems connecting to an Excel workbook from SSIS.
How to store the name of each file in a folder in a SQL Server table using an Integration Services package.
SEO may not be rocket science, but it shares a big principle with theoretical physics, as this blog explains.
If your chart has more than a thousand data labels, this blog explains why you may experience problems.