(Pinal Dave) Building a solution for some sort of disaster site is critical for every organization that thinks about business continuity. One of the proven for ages is a solution around Log Shipping. Though one of the oldest, it is one of the most sought after solution inside SQL Server.
Author: SSWUG Research
A Look at DB2 for z/OS OLAP Functions
(Troy L Coleman) I was recently asked how to calculate the moving average for a given metric. To be honest, I’ve only done minimal work with OLAP functions, so I consulted the SQL Reference guide for help. I need to see examples to get an understanding of how things work; unfortunately, those were l
Parallel Execution — 5 Parallel INSERT
(Hemant K Chitale) Oracle permits Parallel DML (as with Parallel Query, this requires the Enterprise Edition).
SSMS regular expressions: format text into a block
(Jen McCown) Sean’s RegEx for DBAs class must be finally sinking in for me. Today I was able to figure out a RegEx thing in SQL Server Management Studio.
How to move Resource DB in SQL Server ?
(Rohit Garg) The Resource database is a read-only database that contains all the system objects. This DB included with SQL Server 2005 to increase security of system metadata. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear
What stopped MySQL? Tracing back signals sent to MySQL
(Robert Barabas) Have you ever had a case where you needed to find a process which sent a HUP/KILL/TERM or other signal to your database? Let me rephrase. Did you ever have to find which process messed up your night? 😉 If so, you might want to read on. I’m going to tell you how you can find
Oracle system V shared memory indicated deleted
(Frits Hoogland) This article is written with examples taken from an (virtualised) Oracle Linux 6u6 X86_64 operating system, and Oracle database version 12.1.0.2.1. However, I think the same behaviour is true for Oracle 11 and 10 and earlier versions.
Excel Add-in for Exporting Data to XML
(Syed Umar Anis) ExcelExportXML is a Microsoft Excel 2010/2015 Add-in that generates XML data from an Excel sheet. It is developed in Visual Studio using C#.
Integration architecture: Comparing web APIs with service-oriented architecture and enterprise application integration
(Kim J. Clark) At a high level, both SOA and web APIs seem to solve the same problem – expose business function in real-time and in a reusable way. This tutorial looks at how these initiatives are different and how they align into an evolving integration architecture. It discusses how API Management
Video: Java Reflection Tutorial: Accessing Array Elements
(Paul Anderson) In this video excerpt from Java Reflection LiveLessons (Video Training), Paul Anderson talks about accessing Array elements using setters and getters.