Database
http://www.bytebang.at/Blog/Database
Most recent blog posts in the Database category(c) $datetool.get('yyyy'), by bytebang e.U. - <a href="http://www.bytebang.at/About+us/Impressum">Impressum</a> - <a href="http://www.bytebang.at/About+us/PrivacyAndTermsOfUsage">Datenschutz / Nutzungsbedingungen</a>Reset GLPI passwords in the database
http://www.bytebang.at/Blog/Reset+GLPI+passwords+in+the+database?language=en
<p>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. <span class="wikilink"><a title="Kompletten Eintrag lesen" href="/Blog/Reset+GLPI+passwords+in+the+database">...</a></span></p>Blog categories > Database2020-12-02T05:55:30+01:00Guenther HutterSqlServer CPU utilization
http://www.bytebang.at/Blog/SqlServer+CPU+utilization?language=en
<p>Have you ever wondered how much CPU your MS-SQL Server uses - here is how to find it out. <span class="wikilink"><a title="Kompletten Eintrag lesen" href="/Blog/SqlServer+CPU+utilization">...</a></span></p>Blog categories > Database2015-07-21T11:41:08+02:00Guenther HutterTruncate a MSSQL Server Database Logfile
http://www.bytebang.at/Blog/Truncate+a+MSSQL+Server+Database+Logfile?language=en
<p>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. <span class="wikilink"><a title="Kompletten Eintrag lesen" href="/Blog/Truncate+a+MSSQL+Server+Database+Logfile">...</a></span></p>Blog categories > Database2015-01-13T11:02:16+01:00Guenther HutterMSSQL 2012 - Database in Recovery Pending State
http://www.bytebang.at/Blog/MSSQL+2012+-+Database+in+Recovery+Pending+State?language=en
<p>What to do if your MSSQL2012 database is in a "Recovery Pending" state. <span class="wikilink"><a title="Kompletten Eintrag lesen" href="/Blog/MSSQL+2012+%2D+Database+in+Recovery+Pending+State">...</a></span></p>Blog categories > Database2014-09-01T07:43:56+02:00Guenther HutterEfficient CSV analysis with H2
http://www.bytebang.at/Blog/Efficient+CSV+analysis+with+H2?language=en
<p>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 ! <span class="wikilink"><a title="Kompletten Eintrag lesen" href="/Blog/Efficient+CSV+analysis+with+H2">...</a></span></p>Blog categories > Database2014-10-29T02:02:46+01:00Guenther Hutter{{html clean="false" wiki="false"}}Lazy mans oracle update guide (10g -> 11g){{/html}}
http://www.bytebang.at/Blog/Lazy+mans+oracle+update+guide+%2810g+-%3E+11g%29?language=en
<p>Oracle updates can be very tricky. Here is a small solution how to upgrade a single database form Oracle 10g to 11g. <span class="wikilink"><a title="Kompletten Eintrag lesen" href="/Blog/Lazy+mans+oracle+update+guide+%2810g+%2D%3E+11g%29">...</a></span></p>Blog categories > Database2014-09-02T09:22:46+02:00Guenther Hutter