(Patrick Roozen) I’ve been using RAC (10gR2) for years now and I was wondering how RAC One Node differs from RAC. That’s why I used a few ‘old’ RAC servers that we had ‘laying’ around to install a RAC One Node Cluster. I also used that cluster to get some hands on experience with ASM but that is not
Other News
Find Violating SQL Server Foreign Key Values
(Eli Leiba) In many databases, foreign key constraints are not used initially and then later created on tables after data already exists. If data already exists and there are possible foreign key violations the constraint may be created using the NOCHECK option.
How to: Connect to SQL Azure Using PHP
You can connect to Microsoft SQL Azure Database by using PHP and the SQL Server Driver for PHP starting with version 1.1. This topic shows how to create a PHP application within a Windows Azure Web CGI Role that connects to SQL Azure Database.
Setting up Multi-master and read slaves using Severalnines
(Johan Andersson) This tutorial shows how you can use the Severalnines Configurator for MySQL Replication to deploy a Multi-master replication setup, and install ClusterControl.
Instance Caging
(Siba Prasad) Many of you would already be aware of this one while I discover it now but still putting down my thoughts on this 11g new feature.
Installing and Configuring Extended Insight for Optim Performance Manager 4.1.0.1
(Thuan Bui) This is the second part of the two-part video demo for installing Optim Performance Manager and Extended Insight 4.1.0.1.
Gridviews in ASP.Net and VB.Net
In this introductory tutorial, we will take a look at Gridviews in ASP.NET. This web control is often the most important web control for developing ASP.NET websites. They are mostly used for dynamically presenting database information to the browser in the form of HTML tables and can even interact w
Fluent CSV/XML Exporter For List
(Sacha Barber) I don’t know about you but I work with lots and lots of lists at work, and from time to time I have the requirement to export some List to a CSV file, and I used to just write a little helper method that use a bit of reflection that got out all the public properties of the […]
Do You Write SOLID Code – Day 3
Do You Write SOLID Code – Day 3 We have been discussing the different components of the SOLID acronym from Robert Martin, defining five basic principles of object oriented programming. As stated previously, these principles apply to any object oriented language, and even to some that are hybrid or non-object oriented languages. The five principles of SOLID are: • Single […]
Move a Partition to a Different File Group Efficiently
(Dan Guzman) SQL Server table partitioning can reduce storage costs associated with large tables while maintaining performance SLAs. Table partitioning, available in Enterprise and above SKUs, allows you to keep frequently used current data on fast storage while storing infrequently accessed older