BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Wise Owl blogs written in 2012 (page 1 of 5)
Showing blogs 1-20 (out of 81)
Creating views in T-SQL or in the view designer
Posted by Andy Brown on 17 December 2012
Views are queries that you can save and reuse; but you can also use them as a basis for further queries. They do have their foibles too, as this blog explores.
Use the GROUP BY clause in SQL for statistics
Posted by Andy Brown on 14 December 2012
If you want to average, count, sum or perform any other statistic on values in SQL, you need to learn the GROUP BY and HAVING parts of a SQL statement. That's where this online tutorial comes in!
How to do calculations and expressions in T-SQL
Posted by Andy Brown on 11 December 2012
You can use SQL to do everything from simple arithmetic through to complicated functions - this blog gives you the low-down!
Creating computed columns in SQL tables
Posted by Andy Brown on 10 December 2012
This short blog explains how you can create calculated formulae for fields in an SQL table (known as "computed columns").
Writing inner joins and outer joins in SQL
Posted by Andy Brown on 30 November 2012
An in-depth SQL tutorial on how to create inner joins, left outer joins, right outer joins, full outer joins, cross joins and self-joins!
SQL Server - create databases, tables and relationships
Posted by Andy Brown on 19 November 2012
A guide to how to create databases in SQL Server Management Studio, including creating tables, indexing columns and using database diagrams to create relationships between tables.
Setting SQL criteria using the WHERE clause
Posted by Andy Brown on 08 November 2012
If you don't want to see a full set of records from a table in SQL, you can use a WHERE statement to filter out unwanted rows, as shown in this blog.
KB2716442 SQL Server 2012 Windows Update fails
Posted by Andy Brown on 02 November 2012
One idea for what to do if you continually get one Windows Update appearing when you shut down your computer.
Write a macro in VBA to fill in an IE form (Internet Explorer)
Posted by Andy Brown on 02 November 2012
You can use VBA to talk to Internet Explorer, providing that you understand the structure of the web page you're talking to. This blog shows how to do this!
Posted by Michael Allsop on 23 October 2012
Up, down, ceiling, floor or multiples… and you thought rounding numbers was simple!
Why is raising event from C# User Controls so hard?
Posted by Andy Brown on 17 October 2012
Raising events from user controls is straightforward in VB; this blog asks why it should be so much harder using C#.
Using SELECT INTO and INSERT to insert SQL rows
Posted by Andy Brown on 12 October 2012
There are various ways to insert data into new or existing tables in T-SQL - this blog gives examples of each.
Using T-SQL to create tables programmatically
Posted by Andy Brown on 05 October 2012
SQL doesn’t just select data; you can also use it to create tables and link them together with relationships. This blog shows you how!
T-SQL data types - int, float, decimal, varchar, etc.
Posted by Andy Brown on 05 October 2012
Whether you're creating tables in SQL Server, using SQL variables or passing parameters to stored procedures, you'll need to understand what the possible data types that you can use are.
Prevent Reporting Services from caching data
Posted by Andy Brown on 01 October 2012
By default SSRS will create files with extension .rdl.data to cache data. This blog gives two and a half ways to ensure you're always seeing the latest data in a report.
IE compatibility view stops embedded videos running
Posted by Andy Brown on 01 October 2012
If you're trying to run a YouTube video within a website and nothing happens, maybe you're using compatibility view in Internet Explorer?
Highlighting negative columns in Excel charts
Posted by Michael Allsop on 01 October 2012
Ever wondered if you can make negative columns automatically turn red in an Excel chart? Well now you can in Excel 2010!
Why you should develop systems in WPF, not WinForms
Posted by Andy Brown on 25 September 2012
We think - cautiously - that WPF is a better platform for client tool development than Windows Forms. This blog gives 10 reasons why.
The Scratch programming language and Code Clubs
Posted by Andy Brown on 24 September 2012
Volunteers throughout the UK are helping to run code clubs, teaching 9-11 year olds the basics of programming. Find out more!
Some ideas for new features for Microsoft Excel 20xx
Posted by Andy Brown on 24 September 2012
Excel is a great product, but there is always room for improvement. Here Andy Brown considers 12 possible new features for Excel 2020.