(Siba Prasad) Oracle Restart is a new feature introduced to enhance the availability of Oracle database. I wasn’t aware of this till recently. It basically allows various components of Oracle to restart automatically in a stand-alone (non-clustered) installation.
Other News
Performance of PL/SQL table construct
(ss) I have collected some interesting data concerning the performance of direct access to PL/SQL tables in SQL constructs. I have collected some interesting data concerning the performance of direct access to tables PL / SQL in SQL constructs. From some tests I’ve done seems to be most efficient in
As restoring a dump table into the MySQL master – you better get some sleep
(Ilan Hazan) Restoring a dump table into the MySQL master server can lead to serious replication delay. The massive inserts commands cause the Master and slaves to use most of their resources for replication. As a result, replication lag may increase dramatically (linear to the table size).
Data Studio Standalone compared to IDE
Richie on the Data Studio team recently pointed out a great table comparing Data Studio Standalone to Data Studio IDE. The short of it is that both are great tools for administering DB2, with IDE adding some features aimed at Java developers specifically.
Running Radiant CMS on DB2 in the Cloud
(Antonio Cangiano) In this article I will show you how to set up and run Radiant CMS on DB2 Express-C in the Cloud. Before getting started, let’s define each of these components:
Third-party tool for SQL Server outshines IntelliSense in SSMS
(Roman Rehak) The autocomplete feature in development tools has been around for longer than a decade.It’s like a dishwasher — once you have it, you can’t go back. This feature predicts a word or phrase users are entering into a field and displays a list of available objects before they’ve finished
SQL Injection Hits Older SQL Server Versions, For Now
(Jabulani Leffall) Tell me if this sounds familiar: A new SQL injection attack affecting as many as 1.5 million Web address has database application and security admins talking this week. The attacks affect SQL Server versions 2003 and 2005, while SQL Server 2008-based sites are safe for now.
How To Connect to MS SQL Server 2008
(wubayou) This tutorial will teach you several methods to connect to MS SQL Server 2008, including using SQL Server Management and remote computers.
Upgrading SharePoint 2007 Projects to SharePoint 2010
(Juan Larios) I recently did some training for a client and one of the topics that came up was upgrading existing 2007 code to SharePoint 2010 Projects. I just wanted to share some of the issues that came up and the discussion that might be usefull to others.
Merge 2 XML files into single XML using C#
(Karthikeyan Anbarasan) This article shows how to merge two XML files and make use of a single XML in order to make the process simpler.