- Keeping up with High Availability - Automating MySQL Failovers
- Automating failover situations can benefit an organization along with the database administrator who is on call. This article discusses how to setup Keepalived and how it may help in automated failovers for a Multi-Master MySQL cluster.
- Synchronizing SQL Server and SQL Azure
- SQL Azure Data Sync provides data synchronization between the cloud and local SQL Server databases. Learn how SQL Azure Data Sync allows you to keep the most concurrent information in the cloud while allowing mobile users, businesses, and enterprise data sources all to have access to this data.
- Identifying and Eliminating the Dreaded Cartesian Product
- Cartesian Products usually don't provide useful information and often result in mistakes that can hurt your database developer career. Learn to spot Cartesian Joins and banish them from your SELECT queries forever.
- Top 9 SQL Server Developer Interview Questions
- The questions you may wish to ask or that will be asked during a SQL Server Developer interview will vary. Deanna Dicken shares the top 9 interview questions she asks when interviewing a potential SQL Server developer.
- Working with ADO.NET Data Service in a .NET Framework Client Application
- Learn how to consume and make use of the ADO.NET Data Service in a .NET Framework Client Application. This article demonstrates the process by creating a simple web application that uses an existing ADO.NET Data Service.
- Introduction to SQL Server Proactive Caching
- Arshad Ali explores Proactive Caching, available in SQL Server Analysis Services 2005 and later versions. Proactive Caching helps DBAs to better control the cube data automatic refresh frequency. Proactive Caching offers near real time data for reports, while at same time providing a query performance similar to MOLAP storage mode.
- Oracle Database 11g New Features for Table Partitioning
- Table partitioning is an option available to DBAs that can help them manage key database performance areas including i/o balancing, contention reduction, SQL statement performance improvements and even data availability. Oracle Database 11g adds some very powerful new table partitioning methods that can be implemented to help to achieve some of these goals.
- Top 5 Oracle Database PL/SQL Job Interview Questions
- It would be smart to brush up on your SQL when interviewing for a PL/SQL developer position. James Koopmann shares five questions that he has been asked when interviewing for both a DBA position and a PL/SQL developer position.
- Microsoft Sync Framework Beefs Up Collaboration
- There is a growing trend to access applications that are not just confined to just the PC but also extend to the other usually connected devices such as mobile phones and Point-of-Sale terminals. Keeping data synchronized across different platforms is a difficult problem to solve and the Microsoft Sync Framework is Microsoft's solution to the problem.
- Book Review: Access 2010 Programmer's Reference
- Back in June we evaluated four great Access 2010 books that had just been
released. There's now another volume available written especially for
programmers. Danny Lesandrini peeks inside to see if this book lives up to its
name.
© 2003-2010.
Directory-Base.