Example of a class for solving quadratic equations in C#

Wrote a small class in C# for solving quadratic equations. Feel free to use or modify as you please 🙂

Read more No Comments »

Making text subscript or superscript in Word

Keyboard shortcuts to make text subscript or superscript in Microsoft Word 2007.

Read more No Comments »

Division symbol keyboard shortcut / HTML escape on Windows

Found this shortcut completely by accident today while I was attempting to use superscript in a Word document.

Read more No Comments »

Proving a square root is irrational

As part of my Open University degree I am studying MS221. I was interested in how it can be proven that a number is irrational. After much reading I thought I’d submit this article which explains hows to prove √3 is irrational in simple steps.

Read more No Comments »

NewID() within a user defined function in SQL Server

You try to use NEWID() in a UDF in SQL Server 2008 but you get an error that stops you.

Read more No Comments »

Get table size in KB in a single resultset

I’ve written a script that will tell you how much space each table in your database is using up.

Read more No Comments »

Move database file to a new location

Moving a database file to a new location is a common task that if done incorrectly can cause massive headaches. Here is a quick overview of how to perform this task.

Read more No Comments »

Move an existing table to a new filegroup

Sometimes you want to download a table from your live system into a testing environment, but don’t want to have to pull the whole database down. Moving a single table to a new filegroup makes this sort of task much easier as you can just backup and restore the filegroup into an existing database. Here is the script to move a table to a new filegroup.

Read more No Comments »

SQL Server changes varbinary and adds a zero

Wierd problem that has a very simple fix.

Read more No Comments »

Trigger recursion – Prevent triggers firing themselves in SQL Server 2008 R2

Trigger recursion can be the cause of very hard to find bugs. Luckily it is easily prevented.

Read more 4 Comments »

© 2017 Garry Passarella. All Rights Reserved. Facebook Twitter Twitter