(Susan Visser) A few weeks ago, I started a discussion in the DB2 Professional LinkedIn group that turned out to be quite popular. Request to join the group so you can take part in this and other discussions.
Other News
Unit test SQL PL routines by using db2unit framework in DB2 LUW
(Andres Gomez Casanova) SQL PL routines stored in DB2 databases contain business logic that can be used by all applications that access the database. However, these routines are not always completely tested. Until now, no standard procedure existed to perform automatic tests against them.
Parsing XML File in Windows Phone in No Time
(Saad Mahmood) In this article you will learn how to Parsing XML File in Windows Phone in NO TIME.
Stopping one ASM listener in Flex ASM environment takes down ASM instance
(John Hallas) Stopping one ASM listener in Flex ASM environment takes down ASM instance
Access Oracle GoldenGate JAgent XML from browser
(Bobby Curtis) There are many different ways of monitoirng Oracle GoldenGate; I have posted about many of these in earlier blog posts. Additionally, I have talked about the different ways of monitoring Oracle GoldenGate at a few conferences as well.
Checking the alert log – the easy way
(Neil Chandler) Do you check the alert log of your databases every day? In the morning when you get in? But what about the alerts which happen during the day? How do you spot them – especially if you don’t have Grid Control or Cloud Control configured. Even if you do have a full monitoring solution,
SYS Schema First Steps
(Dave Stokes) Oracle DBAs have has the luxury of their V$ variables for a long time while we MySQL DBAs pretended we were not envious. With MySQL 5.6 and 5.7 we were gifted with the PERFORMANCE_SCHEMA tables.
Checking SQL Server Database Backups When You Don’t Have Access
(Bernard Black) Due to HIPAA, (I work for a hospital) a vendor who has installed SQL Server along with an application on a hospital system, will not give you a login to the SQL Server. “It is mandated by HIPAA”, he asserts. He further states “Only we and our application can connect to the database”.
SQL SERVER – UNION With TEXT DataType Returns Error but and UNION ALL Works – Reasons
(Pinal Dave) Earlier I demonstrated a very interesting behavior in my blog post – UNION and UNION ALL with TEXT DataType – Observation, where we see that UNION clause with TEXT datatype returns Error but with UNION ALL it does not return an error.
Understanding SQL Server on Windows Azure VS Azure SQL database
(Vinoth N Manoharan) Often people get confused with the two different types of SQL Server service available on Azure or Microsoft cloud services,