Skip to main content


Query to Set MSSQL Database Owner

This resolves an error encountered disabling the ability to view database properties via SQL Management Studio:  "Property Owner is not available for Database '[DB_name]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)"  And a related error:  "The database owner SID recorded in the master database differs from the database owner SID recorded in database 'XYZ'. You should correct this situation by resetting the owner of database 'XYZ' using the ALTER AUTHORIZATION statement." Where !DBNAME= database name, and the default System Administrator remains 'sa':  use !DBNAME EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false GO

Remove Single User Mode From Your MSSQL Database

***This guide is valid for MSSQL 2000, MSSQL 2005, MSSQL 2008 and MSSQL 2012.  Is your database stuck in single user mode? Irritating isn't it? Use the following command to restore it to normal service, where DBNAME is the name of the database: exec sp_dboption 'DBNAME', 'single user', 'FALSE' go

MSSQL .NET sysobjects Cheatsheet - Viewing and Creating Sysobjects

The following in formation should be valid for MSSQL 2005 and 2008. Sysobject creation is best handled using the GUI available at $WINDOWS\Microsoft.NET\Framework\$version_number\aspnet_regsql.exe. Under some circumstances, this may not be possible or preferable. In those circumstances, the following queries can assist you. To view all installed sysobjects for the database, run the following query, replacing DBNAME with the name of the relevant database: use DBNAME go select * from sysobjects where xtype ='P' and name like 'aspnet_%' Sysobject creation scripts are specific to the object. The script below will create aspnet_SchemaVersions: CREATE PROCEDURE [dbo].aspnet_CheckSchemaVersion    @Feature                   nvarchar(128),    @CompatibleSchemaVersion   nvarchar(128) AS BEGIN IF (EXISTS( SELECT  *                FROM dbo.aspnet_SchemaVersions                WHERE   Feature = LOWER( @Feature ) AND                        CompatibleSchemaVersion =

For Your Consideration, Neutron the Atomic Superman vs. the Death Robots

DIY Boards

I may be a bit late to this party, but I am excited to get my hands on the Arduino Board , a small, open-source everything hardware hacking platform (psst I get no kickbacks from these people and have no relationship with the corporation I just think you might like it). The only downer is, I have 0 experience with Arduino. They are going for about $10-$15 though, which is cheaper than your average programming language manual, so this would be a cool way to learn. This reminds me of the time I set a server on fire trying to attempt power conversion for a very unique SCSI hard drive while attempting forensics without proper tools (remember before SAS became cool and how every SCSI device seemed to have its own pinout?). I may have to post about that soon.

Google's Disavow Links Function

I am still doing a bit of research on this function (and have plans to update this page appropriately), but this should be of considerable interest if you are anything like me and have a website that is somewhat frequently the target of hackers and spammers. The Google Disavow Links tool, part of their Webmaster Tools, will allow you to remove links from Google's algorithm, and hopefully you can successfully strike back at spammers and link farmers who would damage your website's rep.

What Math Can Teach Us About Juggling, and What The Math of Juggling Can Teach Us About Everything Else

Computers represent humanity's greatest achievement along the border of the analytic and the pragmatic. I have always been interested in where mathematics and the 'real world' meet. The question that seems to drive the latest heights of human understanding wherever I turn is - how can we use mathematics to better understand our environment, more efficiently complete tasks or provide more sophisticated and beautiful solutions to problems that are half-understood but widely believed to be resolved? This interest has informed my career, from an amateur interest in cryptography and network security as a youngster, to the study of logic at university, and now to networking and administration (I also think its why I've had more of a capacity for the discrete side of things and have floundered in calculus). This intersection in computing is widely accepted, but in more common tasks the mathematical approach to problem solving is often discarded for the obscurantism of 'c