Fast-Start Failover in Oracle 11g Data Guard11/20 Learn how to set up and control automatic failover using the Fast-Start Failover Observer, so that DBA intervention is no longer required during a disaster recovery scenario.
Data Formatting, Working with XML Data in MySQL11/19 Today's article continues to explore XML support in MySQL. Specifically, we'll look at a nicer way to format our resultset. We'll also discuss how to retrieve all of the records from the XML document, using a stored procedure.
Securing Client Connections: OS Authentication11/17 Connection
to an Oracle database, using operating system authentication has come under
fire for providing loopholes in security. You be the judge.
Intro to Windows Azure By Kurt Claeys
Published November 11, 2009
Kurt Claeys introduces us to Microsoft's new cloud operating system, Windows Azure.
Why Sharepoint? By Joe Mack
Published October 28, 2009
SharePoint is the fastest growing product in Microsoft history and according to Forrester the number 1 portal product in use today. Let Joe Mack show you some of the ways Sharepoint can make your workers and your company more efficient and profitable.
Win 7 Code Pack for Visual Studio By Jani Jarvinen
Published October 13, 2009
Use Windows 7 Code Pack to boost your .NET development inside VisualStudio.
Drill Down Charts in Silverlight By Chad Campbell
Published September 29, 2009
Learn how to deliver drill down charting functionality using the Silverlight toolkit.
Oracle Gets a One-Week Extension on Sun Deal11/20 Oracle gets more time from the EU to defend its purchase of Sun Microsystems, while some are calling on the company to sell off MySQL.
Installing SQL Server 200811/20 Need your server and your site up and running quick? Let Greg Larsen show
you what you need to know to get SQL Server running and configured.
Is SQL Server 2008 R2 For You?11/20 With SQL Server 2008 R2 just around the corner how do you decide if this upgrade is for you?
Find SQL Server Authentication Mode This script can be used on both SQL 2000 and SQL 2005 to find the Authentication mode set for the sql instance.
Stored Procedure NetSend This stored procedure can be used by database administrators to inform users, prior to breaking the user's connection to the database.
Track Table Fragmentation A diagnostic table and stored procedure to track the fragmentation of large tables within databases. The user passes the database name and the table name as parameters to the SP. The SP can be set up to run as a scheduled job every few hours to produce a historical trend of fragmentation.
