- Top 10 Security Tips for MySQL
- Security is a crucial part of any database system and MySQL is no different! There are very specific techniques a database administrator can use to protect their MySQL installation. Read on to learn the TOP 10 security tips for MySQL database administrators.
- Oracle Database: Flashback Vs. Recovery
- Don't limit yourself when it comes to database recovery. Recovery isn't just recovery anymore; it's more like recovery plus various flashback options.
Read on to learn the positive and negative options you have when it comes time to flash back some object.
- Configuring Proactive Caching in SQL Server
- Proactive caching helps DBAs to better control
the cube data automatic refresh frequency, offering near real-time data for
reports. This article covers the settings for HOLAP and ROLAP, and configuring
proactive caching.
- 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.
© 2003-2010.
Directory-Base.