Note to self

by Damiaan Peeters 22. June 2008 15:31

Defragment from time to time your disk.

image

(22% free space)

MSSQL error message: "Property Owner is not available for Database [databaseName]"

by Damiaan Peeters 22. June 2008 10:43

Problem

When i clicked on the properties of the Database, I got this error on 2 of my Microsoft SQL Server 2005 databases.

image

TITLE: Microsoft SQL Server Management Studio

Cannot show requested dialog.

ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

Property Owner is not available for Database '[myDatabaseName]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=Owner&LinkId=20476

Cause

I have restored this databases in the past from other server's backup, and my original login is apparerently not available on target server.

image

Solution

You can fix it with 'sp_changedbowner sa'.

update:
I removed '2005' the subject of this post because you can have this error message on the Newer SQL Server 2008 also.

update 2:
The syntax to use in SQL Server Management Studio is:

use myDBName
EXEC sp_changedbowner 'sa'

NDepend

by Damiaan Peeters 21. June 2008 08:58

A few days ago I received my NDepend license. 

What is NDepend

On their web site (http://www.ndepend.com), it states that :

NDepend is a tool that simplifies managing a complex .NET code base.

So in other words, (also on the web site)

Architects and developers can analyze code structure, specify design rules, plan massive refactoring, do effective code reviews and master evolution by comparing different versions of the code.

Out of my experience, I know - I really know - that bad designed software is a nightmare to maintain.  Worsted of all is that most of the time is it horribly coded and badly documented.  I've done seen in the past, and I am still struggling today.  It's easy to guess where the problems are, or how you could make the application better.  Because guessing is most of the time not the proven to be good, scientists created something like "metrics". 

Metrics measure your software, code base or even your software design.  NDepend uses these metrics and also the dependencies between your assemblies to tell you more about your application.

More about NDepend later!

Defragmentation

by Damiaan Peeters 20. June 2008 15:28

Everyone knows that I am a "defragmentation-tool user".  Yes, I defragment my drives regularly.  And yes, I am convinced that it helps to keep my PC up and running.  (No, I do not want to reinstall my PC every few months.)

You should definitely check out the new tool from Piriform (the company that created CCleaner and Recuva...), it is called Defraggler!

It doesn't seem the fastest tool on the market, but it has a nice features.

E.g.  You can defragment a file or all files in a Folder.  How cool is that?  I always wondered if deframentation of one file would speed up its loading time.  Or image you have a folder with files that are regularly updated, you might be interested in defragmenting this folder, but leaving the rest of your disk alone.  Of course you can defragment your freespace too.

image

Altough it is a release candidate, it seems a very decent and stable tool.  And the best of all, it is free for personal and corporate use.  (yes, defragmentaion runs on Windows Server 2003) . 

Hooray!

Font with special zero

by Damiaan Peeters 13. June 2008 14:21

I know that IT people and programmers struggle searching fonts with a zero (0) that differs from a 'o' (or O).  Very handy to show license key's with 0 (zeroes).

What would you think of this font?

The Raize Font is a clean, crisp, fixed-pitched sans serif screen font that is much easier to read than the fixed pitched fonts that come with Windows. Ideally suited for programming, scripting, html writing, etc., the Raize Font can be used in any IDE or text editor.

image

Oh by the way, it's free!

http://www.raize.com/DevTools/Tools/RzFont.asp

Tags: ,

General

Who.I.am

Certified Umbraco, .net and Azure developer, seo lover. Magician in my spare time.

Month List