Accepted to BizSpark

Just this week HawkeSoft was accepted into Microsoft's BizSpark program! To learn more about BizSpark check out http://www.microsoft.com/bizspark/.

New web sites are up

The new www.hawkesoft.net and www.ezsqlrestore.com are now live. Check them out!

Echoes of Eternus

A whisper from those thought lost,
Awakened,
A new mother's cry,
Reborn,
The Echoes of Eternus haunt the winds again.

www.echoesofeternus.com

EZ SQL Restore is getting a new home

Starting this week I will be migrating the EZ SQL Restore product page to its new home, www.ezsqlrestore.com. This is in preparation for a new version of EZ SQL Restore that HawkeSoft will be releasing soon. The new version will launch with an all-new lower price and SQL Server 2008 support.

Stay tuned for more updates coming soon...

Big changes are coming...

... and new ideas are brewing. HawkeSoft is changing its focus to a whole new market. More details are coming soon.

New, LOW Price for EZ SQL Restore

We have just announced an all new, lower price for EZ SQL Restore. This makes our powerful drag and drop database utility even more affordable! Check out the new prices here: http://www.hawkesoft.net/Purchase.aspx

HawkeSoft SQL Tips and Tricks - Part 6 - The Power of OBJECTPROPERTY

OBJECTPROPERTY is your one-stop shopping function for finding out all kinds of system information on database objects. It is especially powerful for triggers, contraints, and indexes. The sample code below shows one of my favorite uses for this function, finding disabled and untrusted constraints. This can be extremely useful when bad data has been introducted into a system, or to check clean up code after a data migration/conversion. (SQL 2000/2005)

SELECT name, tbl = object_name(parent_obj)
FROM sysobjects
WHERE objectproperty(id, 'CnstIsDisabled') = 1

SELECT name, tbl = object_name(parent_obj)
FROM sysobjects
WHERE objectproperty(id, 'CnstIsNotTrusted') = 1

To read more check out http://msdn.microsoft.com/en-us/library/ms176105.aspx.