Sometimes when we create a table or a stored procedure it is created as [databasename].[username].[tablename] instead of [databasename].[dbo].[tablename] To change the schema (owner) back to dbo, use the following snippet EXEC(‘sp_changeobjectowner @objname = ”username.tablename”, @newowner = dbo’)

ZiX is the Content Management System (CMS) used for this site. ZiX uses PHP5 and MySQL5, is completely template based and programmed in fairly clean OOP style. At this point in time ZiX is not open source.

My NIC (Network Interface Card) does not come back to life after my computer has been in standby. I have to disable and enable it to get my connection working again. A little batch file helps to get this done nice and easy.I created a file (nic.cmd) with the following 2 lines: netsh interface set [...]

A nifty, little known feature of .NET 2.0 is app_offline.htm. When IIS finds this file in the root of an application, it shuts down .NET. All requests are instead served with the app_offline file. Very neat when you need to update an application.Before I knew about app_offline.htm, I had a second web site configured in [...]

Per HTML and XHTML standards, a DOCTYPE (short for “document type declaration”) informs the validator which version of (X)HTML you’re using, and must appear at the very top of every web page. DOCTYPEs are a key component of compliant web pages: your markup and CSS won’t validate without them. HTML 4.01 Strict, Transitional, Frameset <!DOCTYPE [...]