Posts made in March, 2011

How to reset HP ILO (Integrated Lights Out)?

Posted by on Mar 11, 2011 in Featured, Servers | 1 comment

How to reset HP ILO (Integrated Lights Out)?

Sometimes it happened to me that the HP ILO (Integrated Lights Out) is unresponsive. Not only the remote console but the whole web interface. In the past I used to shut down the server, unplugged it, plugged it in again and booted it. Well this is pretty uncool in combination with service level agreements, he?! But here is what you can do if your ILO is unresponsive now: If you can still login to the website, you can go to the administration -> network settings pane and simply click apply. ILO will reset itself and everything should work fine after that. If installed on the servers operating...

Read More

How to disable Windows 7’s default printer management?

Posted by on Mar 11, 2011 in Group Policies, Registry | 2 comments

When working with hundreds of computers and users you may have found ‘your’ way of managing printers. But Windows 7 sometimes (may be together with its users) thwart your plans. Since there is a configuration dialog in the start menu called Devices and Printers from where you can “manage default printers” every user can manually select which printer to set as default in a certain network. Well, I don’t want my users to choose which printer they get connected. I want them to use the printer they have at their office! So what now? As far as I know, you cannot...

Read More

How to (re-)set identity column value in SQL Server?

Posted by on Mar 2, 2011 in SQL Server, Transact-SQL | 0 comments

When you use identity columns in SQL server you may have recognized that when deleting all table data your identity value stays at its latest position. Sometimes this is useful, sometimes it is not. Then you need to set this value to your preferred starting point. Another scenario would be that you need to start with a special position in a new table for example to meet naming conventions. All you need is the DBCC CHECKIDENT command. First you may want to know the value your identity column has at the moment: DBCC CHECKIDENT ('tablename', NORESEED) If you want to set the identity value to...

Read More