Wise Owl Blog - Home Page
Showing blogs 81-100 (out of 208)
SQL Server Reporting Services 2012 (SSRS 2012) has been completely rewritten (it's now called SQL Server Data Tools), and yet looks strangely familiar. This blog explains the new features introduced.
PowerPivot for Excel allows you to crunch very large amounts of data quickly, using pivot tables and slicers and other familiar Excel concepts. It also includes the DAX language, allowing you to create complex calculations.
How to create the perfect ASP.NET website, including using master pages, CSS style sheets, and whether to use skins and themes or not.
Before you get into writing SQL Queries you should take some time to familiarise yourself with the application in which you'll be spending most of your time. This blog shows you the basics of SQL Server Management Studio.
This free online tutorial shows how to create the perfect website using ASP.NET using Visual Basic or Visual C#, user controls, styles, master pages, gridviews, data classes and stored procedures.
To celebrate our 21st birthday, we thought we'd look back on how software training has changed over the last 21 years.
Designing relational databases is easy once you learn the few basic rules, and the procedure is identical whether you're using SQL Server or Access. This blog illuminates the subject!
The Easter Bunny stores his distribution data in SQL Server, not Access; read why!
Sometimes the tool you need for a window isn't in the All WPF tools section of the toolbox - here's how to add it.
If you're developing software, should you use old-fashioned but reliable WinForms, or the exciting new concept, WPF?
I recently wrote a blog on why (I believe) VB is a better programming language than C# - I wasn't prepared for the flames this would unleash.
It's not for the faint-hearted, but there is a way to capture application events (such as someone trying to create a new workbook) in Excel, using something called an event sink. This blog explains how you might go about creating an event sink.
Creating a digital certificate for your VBA projects is easy, but deleting them is somewhat less obvious. This blog shows you how to use the certificate manager to remove certificates that you no longer need.
Understanding macro security is essential if you want the code you've written to run when it's supposed to, and at the same time protect yourself from potentially malicious code. This blog explains how to change your security settings to an appropriate level and discusses the ins and outs of digital certification.
If you've learnt how to create your own objects using classes in Excel VBA, the next step is to learn how to group them together into collections. This on-line tutorial will show you how.
Those who want to add spice to their VBA programming can learn how to create classes, or class modules, and become object-orientated programmers. It's difficult, but fun - and this multi-part blog will guide you along the way.
If you've written a killer function, you'll want to be able to share it between workbooks. The best way to do this is using an add-in.
You can't do much in Microsoft Project without understanding how calendars work. Calendars control when work is allowed to happen, so it's important to set them up properly before you start planning your tasks. This blog teaches you how.
If you've ever been annoyed by somebody else changing parts of your Excel workbooks it's a good idea to learn about protection to prevent them from doing it again!
If you're constantly frustrated by other people entering the wrong values in your spreadsheets why not learn how to use data validation to prevent them? This blog series explains how you can control what other people can do to your spreadsheet.