From time to time users are forgetting their passwords for webapplications. Normally there is a "forgot password" link to reset it. If this is not the case then you can reset passwords of webapplication directly in the database. This article shows how to do this with GPLI. ...
Have you ever wondered how much CPU your MS-SQL Server uses - here is how to find it out. ...
Are you running out of disksapce again because MSSQL Server is eating all your diskspace? ... Well then its propably time to truncate the logfile -> Here is a simple solution to this problem. ...
What to do if your MSSQL2012 database is in a "Recovery Pending" state. ...
From time to tome i get a huge csv file (200k+ Lines with 60 columns) form one of our customers. These monsters are pretty hard to handle / analyze within Excel or OpenOffice but luckliy there is another solution for all of you who can write SQL statements ! ...
Oracle updates can be very tricky. Here is a small solution how to upgrade a single database form Oracle 10g to 11g. ...