Programming blogs from Wise Owl (page 5 of 7)

Showing blogs 81-100 (out of 133)

Introduction to SQL Server Management Studio

Posted by Andrew Gould on 30 April 2012

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.

Tags:   SQL | Tables and columns    |    T-SQL | SQL Tutorial

Designing databases for SQL Server and Access

Posted by Andy Brown on 23 April 2012

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!

Tags:   Access | Designing databases    |    SQL | Tables and columns    |    T-SQL | SQL Tutorial

Why VB trumps C#, and how trolls don't agree!

Posted by Andy Brown on 15 March 2012

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.

Tags:   Musings | Random musings    |    Visual Basic | General coding    |    Visual C# | General

Capture Excel application events - event sinks

Posted by Andy Brown on 06 March 2012

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.

Tags:   VBA macros | Classes    |    Writing VBA | VBA tutorial

How to Delete Digital Certificates from your Computer

Posted by Andrew Gould on 06 March 2012

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.

Tags:   VBA macros | General    |    Writing VBA | Other

Collections of class object using Excel VBA

Posted by Andy Brown on 05 March 2012

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.

Tags:   VBA macros | Classes    |    Writing VBA | VBA tutorial

Creating classes in VBA - class modules

Posted by Andy Brown on 05 March 2012

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.

Tags:   VBA macros | Classes    |    Writing VBA | VBA tutorial

Using Excel Add-Ins to Share VBA Code

Posted by Andy Brown on 05 March 2012

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.

Tags:   VBA macros | References    |    Writing VBA | VBA tutorial

Advanced controls in userforms with VBA macros

Posted by Andy Brown on 28 February 2012

The two previous parts of this mini-blog have shown how to draw forms and how to write code to handle form events. This final part shows how to add some of the more exotic controls to user forms, like combo boxes, list boxes, multipage controls, spinners and option buttons.

Tags:   VBA macros | User forms    |    Writing VBA | VBA tutorial

Writing VBA macros to work with user forms

Posted by Andy Brown on 28 February 2012

The previous part of this three-part series showed how to draw user forms; this part shows how to write macros to get them to work (the final part shows how to use some of the more advanced controls, such as combo boxes and MultiPages).

Tags:   VBA macros | User forms    |    Writing VBA | VBA tutorial

Drawing UserForms in the VBA code editor

Posted by Andy Brown on 28 February 2012

Learn how to create your own custom dialog boxes in VBA, using UserForms. This is the first part of a three-part series (the other parts are on Writing Code for UserForms and Creating Advanced Controls).

Tags:   VBA macros | User forms    |    Writing VBA | VBA tutorial

Scheduling Data Imports in SQL Server

Posted by Andrew Gould on 27 February 2012

If you frequently import data into a SQL Server database from the same source you'll probably be sick of going through the import wizard again and again. So why not learn how to schedule an automatic import of your data using SSIS packages and the SQL Server Agent? This blog explains how to do exactly that!

Tags:   SQL | Tables and columns    |    T-SQL | Other

Writing functions for Excel using VBA

Posted by Andy Brown on 24 February 2012

On-line training in writing functions using VBA, for use either within other VBA programs or within Excel itself.

Arrays in Visual Basic for Applications macros

Posted by Andy Brown on 24 February 2012

You can use arrays (multiple variables) in VBA to speed up code - and they are also invaluable for processing CSV files and the like.

Using enumerations in VBA

Posted by Andy Brown on 24 February 2012

Excel and other MS Office applications make extensive use of enumerations - and you should too!

Tags:   Writing VBA | VBA tutorial    |    VBA macros | Enumerations

Writing recursive programs in VBA

Posted by Andy Brown on 20 February 2012

In certain cases in VBA (displaying the contents of folders, listing hierarchical data) writing a program which calls itself is by far the easiest way to go - this blog gives worked examples of 3 such recursive programs.

Tags:   VBA macros | General    |    Writing VBA | VBA tutorial

How to Edit all Records in a SQL Server 2008 Table

Posted by Andrew Gould on 16 February 2012

This blog explains how you can get access to all of the records in a SQL Server 2008 table when you try to edit them, rather than just the top 200.

Tags:   SQL | Tables and columns    |    T-SQL | Other

Calculating Age in SQL with a User-Defined Function

Posted by Andrew Gould on 16 February 2012

A common requirement in SQL queries is calculating a person's age. The expression you need to do this accurately is relatively long, so why not replace it with a user-defined function? This blog shows you how!

Tags:   SQL | Calculations    |    SQL | Functions    |    T-SQL | SQL Tutorial

Changing Settings in SQL Server Management Studio

Posted by Andrew Gould on 16 February 2012

If you've spent time in the SQL Server Management Studio application you'll probably have noticed that it's not the most user-friendly environment for writing SQL queries. This blog explains how to change a few settings to make your query writing just a little easier.

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

Free SQL training

Posted by Andrew Gould on 13 February 2012

This article provides a comprehensive tutorial in Microsoft SQL Server, taking you from the basics of writing SELECT statements all the way through to creating complex stored procedures.

Tags:   SQL | Selecting data    |    SQL | WHERE criteria    |    SQL | Calculations    |    SQL | Joins    |    SQL | Grouping    |    SQL | Stored procedures    |    SQL | Transactions    |    SQL | CTEs, subqueries    |    T-SQL | SQL Tutorial
This page has 0 threads Add post