Accidental DBA Tip – Manage Transaction Logs Transaction logs are a key utility for managing the recovery and performance of your database. In most engines, a transaction log maintains a copy of the data being written to your database to assure the integrity of the data. If you want to do more research about what I mean about the Integrity […]
Other News
Dynamic XPATH in XSLT using C#
(Rajavel JP) Recently I had a task of converting a flat XML to hierarchical XML deserializable to .NET entities. Everything was smooth until I got into a situation where-in I had some elements like shown below
ADF Page Template Refresh From ADF Page Fragment
(Andrejus Baranovskis) I would like to describe how to refresh dynamic content available in ADF Page Template from consuming ADF Page Fragment. This is not always obvious, because physically ADF Page Template and ADF Page Fragment are two different files.
Using basic IO with .NET Microframework
(Laurent Ellerbach) Here is the code from my first French TechDays demo. The video will be available soon (I’ll edit this post as soon as it will be available). During this first demo, I explained how to use the IO in a simple way: OutputPort, InterruptPort, InputPort and Analogic input ports.
Optimize Your SQL With Percona’s Online Query Advisor!
(Baron Schwartz) Wouldn’t it be nice if you could get expert advice on your SQL queries to find problems in them, the same way that programmers can use lint-check tools to warn about bugs in their C?
A new DB2 clock has started: End of Service for DB2 9
(Willie Favero) That’s right. If you’ve been keeping score you know that we had already announced End of Marketing (EoM) for DB2 9 last year. That happens on December 10, 2012. When I discussed that date in this blog I did mention that it won’t be long until we hear something about End of Servi
Steps to restore a database that has a SQL Server Audit defined
(Matteo Lorini) When restoring a database, that has audit specifications defined, on a different server, the audit events are defined but the audit mechanism is not able to capture audit data. In this tip we walk through the steps you need to take to enable capturing of audit data for the database.
#0136 – SQL Server – SSMS – Slow load times – Improving launch performance in 2 simple steps
(Nakul Vachhrajani) As you know, I recently completed a 10-part tutorial series on the SQL Server Management Studio (SSMS). As I finished writing the tutorial, I remembered that one of the issues most SQL Server developers encounter are the slow load times of the SSMS. Sometimes, SSMS is just not fa
ADRCI and listener purging
(Neil Johnson) I won’t go into any details on ADRCI as others have already done a better job than I could. The key piece of information for this post is that the MMON process shoulders the responsibility for ADR purging. So what if there isn’t an MMON process?
More on database consistency
(Anders Karlsson) I’ve written a few times about database consistency before, mainly in conjunction with NoSQL and the concept of Eventual consistency. Now, I’m about to do an update on the subject, as I have come to realize a few things.