You may have faced situations when you need to restore a SQL Server database, but the restoration fails because a connected user prevents SQL Server from acquiring the required exclusive mode.
The T-SQL script below will kill all active sessions by switching immediately to exclusive mode. you’ll then be able to restore the db (or perform any other operation requiring exclusive mode), before switching back to multi-user mode. Continue reading
You need a JComboBox whose width doesn’t depend on the widest of its items, but you still want the dropdown list to be wider than the JComboBox, wide enough to display properly the widest item. For example :
“Refactoring is the process of taking a running program and adding to its value, not by changing its behavior but by giving it more of these qualities that enable us to continue developing at speed.” – Kent Beck
A new developer gets his hands on an existing source code, and soon your hear this complaint : “Code is a mess, it must be refactored !” Sometimes, that’s true, and some other times, that’s a great recipe to end up with a code as bad as – or even worse than – the initial code. To decide if a refactoring is required, here are ten questions you should ask yourself (or the developer asking for the refactoring): Continue reading
Project postmortems help improving a development process. But before planning one, ask yourself why you need it, and what will be the consequences of doing it or not. There’s nothing worse than collecting people’s feedback, and then ignoring it. If you are not ready to take actions to improve things, just don’t do a postmortem. Else, the following tips may help you get the most from your project postmortem : Continue reading