(Tony Davis and Grant Fritchey) Any SQL Server monitoring tool must gather the metrics that will allow a DBAs to diagnose CPU, memory or I/O issues on their SQL Servers. It should also provide a set of accurate, reliable, configurable alerts that will inform the DBA of any abnormal or undesirable co
Other News
How to Manage Microsoft Azure SQL Database Using PowerShell with REST APIs
(Marcin Policht) In our previous article published on this forum, we have presented a somewhat unorthodox (from the perspective of a typical DBA or IT Pro – but certainly not that of a developer) method of managing Azure SQL Database that involves directly invoking REST APIs, providing an alternativ
DB2 10.5 ‘Cancun Release’ Additional Monitoring Capabilities
(Dave Beulke) DB2 10.5 “Cancun Release” was recently released as DB2 LUW Version 10.5 Fix Pak 4. As I wrote about last week, IBM has put a number of impressive features in this new update.
Tracking Table Activity using Triggers
(Ember Crooks) There are a number of situations in which a DBA may need to deterimine when data in a table is being inserted or changed. The most obvious tool for tracking this may be using the db2 auditing facility. If you haven’t looked at audit for a while, it has been significantly improved in m
Prevent the JDeveloper XSL mapper from breaking
(Patrick Sinke) Who has worked with the Design view of the XSL mapper in Oracle JDeveloper, knows that it works nice for simple mappings and drawing lines from one end to the other. However, when adding more complicated transformations, the moment arrives one has to modify the source.
Read Data From XML in ASP.Net MVC 5
(Christian Felix) This article shows how to use XML in a project and also use the basic Class Library helper.
Achieve improved database interoperability with SQL and RDB aliases
(Nathan Skalsky) In today’s complex environments, where data is spread across numerous homogeneous and heterogeneous databases, simplification is a necessity. Three-part naming offers that simplification for database connectivity by allowing skilled data architects, programmers, and system administr
Don’t go directly to Maximum Protection!
(Uwe Hesse) With a Data Guard Configuration in Maximum Performance protection mode, don’t go to Maximum Protection directly, because that leads to a restart of the primary database:
Crossplatform transportable tablespaces – part 2
(Marcin Przepiorowski) It took some time since I wrote a first post about TTS migration but I finished that project literally hours before my summer break. Now after couple of days while I enjoyed thermal waters and good wine of Hungary it’s time to write next post.
Tweaking MySQL Galera Cluster to handle large databases – open_files_limit
Galera Cluster is a popular choice for achieving high availability using synchronous replication. Though if you are planning to run huge sites with many DB objects (tables), a few tweaks are necessary.