(Bobby Curtis) With Oracle Real Application Clusters the Oracle database can be configured to restart as each node in the cluster is restarted. For single instance databases that are on a standalone server, often times the database is not configured to restart on a server bounce.
Author: SSWUG Research
#Oracle SQL Tuning Advisor on the Command Line
(Uwe Hesse) This post will show a brief example how to use the SQL Tuning Advisor on the Command Line. The documentation is very verbose about it, but maybe you’ll find it a bit hard to dig through and prefer to start easy.
SQL Server Reporting Services Advanced Charting
(Scott Murray) First released as an “add-on” in SQL Server 2000, and fully integrated into SQL Server since version 2005, SQL Server Reporting Services (SSRS) is now a well-established web-based, self-service, reporting solution.
SSIS and Stored Procedure OUTPUT Parameters
(David Dye) I was recently asked to help configure an execute SQL task that would call a stored procedure and capture an output parameter in an SSIS variable.
UNTIL CANCEL UNTIL CANCEL UNTIL CANCEL
(Don Seiler) Yesterday I was creating a new Oracle 11.2.0.3 database from a copy of datafiles and archivelogs taken from our standby. I was sure to include archivelogs from just prior to well after the span of the datafile backup time.
SQL Server – Understanding Allocation Units – In Row Data, LOB Data & Row Overflow Data
(Venkata Suresh Raavi) Before we get started on this topic, here is a quick fact..in SQL Server 2000, there used to be hard limit on the data that can be stored in a single row, which is 8,060 bytes. So, if the data exceeds this limit, the update or insert operation would fail!
Why PSD to XHTML Conversion is Necessary?
(Sunny Sharma) XHTML was actually developed by the W3C in order to enable the developers to make the transition from the HTML to XML. There are different advantages that can be enjoyed with the migration of the file to XHTML and web developers have the opportunity to enter into the world of XML.
SQL Server Reporting Services Report Manager Tips and Tricks
(Dattatrey Sindol) I am new to SQL Server Reporting Services Report Manager. I need information on customizations. I have also heard about the My Reports Feature. Can you please explain that as well? Check out this tip to learn a few SQL Server Reporting Services (SSRS) Tips and Tricks on Report
Developing a distributed WS-AT transaction using an IBM BPM Advanced Integration Service, Part 3: Defining the business process
(Carlo Randone and Marco Antonioni) Leveraging the capabilities of the Advanced Integration Services (AIS) in IBM Business Process Manager V8.0.1 Advanced, this series describes the implementation of a distributed WS-AT scenario involving two databases (Microsoft SQL Server and IBM DB2) installed on
MySQL 5.7 multi-source replication
(Miguel Angel Nieto) Recently Oracle announced several new features for the latest available development version of MySQL that is 5.7.2 at the time of writing this article. Most of them are performance and replication related that show us how incredible the new release will be.