Wise Owl Blog - Home Page
Showing blogs 1-20 (out of 223)
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.
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.
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.
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.
Ever had the feeling that you're missing something obvious? This blog highlights one particular chart option that you may well have overlooked.
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!
This blog teaches you how to modify existing data in your database by either deleting records or updating them.
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).
This blog teaches you how to return values from your SQL stored procedures using two different techniques: return codes, and output parameters.