|
Database Management & Programming News, Articles & Tutorials for Database Administrators
4/30
Having a good set of indexes on your SQL Server database is critical to performance. Efficient indexes don't happen by accident; they are designed to be efficient. Greg Larsen discusses whether primary keys should be clustered, when to use filtered indexes and what to consider when using the Fill Factor.
4/29
The usefulness and utility of the SQL Server Agent cannot be overstated. Oracle Database supports the automatic starting of an instance, so whatever is associated with the Oracle instance can also be started along with the instance. The same holds true with the SQL Server instance and its agent service. 4/28
How do you, as a database administrator, display the
wealth of knowledge in your Database to the organization in a meaningful way -- Business Intelligence. 4/27
A healthy database saves money, seriously!
What do database administrators that are advocates of database assessment and database monitoring know that you don't know? Isn't it time you found out?
4/26
The open source Apache Cassandra database used by Twitter, Digg, Facebook and other big online properties is making a move into the enterprise thanks to new startup Riptano. 4/26
Despite its benefits, SQL Server Integration Services Import Export Wizard has a number of limitations, resulting in part from a new set of rules that eliminate implicit data type conversion mechanisms present in Data Transformation Services. This article discusses a method that addresses such limitations, focusing in particular on importing the content of Excel spreadsheets into SQL Server.
Oracle Database, SQL Server and Other Databases are aided with a server-based data distribution, ETL, and application integration solution.
Oracle database with Oracle Weblogic Server and Oracle Coherence support the performance demands of media-rich social network applications.
The Oracle database, according to Gartner, maintains a stronghold on the DBMS market while Oracle is continuing to fill out its data warehouse offerings.
SQL Server 2008 users can now easily repair corrupted SQL databases with 4.7 of SysTools SQL Recovery tool.
Database administration on the cloud with NetDBAs.
The Oracle Database Enterprise Edition with Diagnostic and Tuning packs, Oracle Mobile Lite Server, and Oracle Database Lite Client improve productivity for CBL’s manufacturing businesses’ sales infrastructure.
A database security webinar, put on by AppSec, will address industry best practices for auditing database systems.
MySQL and other open source software helps to power Trove, a newly unveiled search engine for 90 million items about Australians and Australia.
More Database News...
Many applications today were not built with the idea of sharing data. In order to grow your business and make good business decisions you need to start thinking about integrating your corporate data. By making Data Integration a priority, you can reduce your storage costs and accelerate application delivery.
Data Recovery of your critical business information is important. Not only that, but customers are starting to expect zero downtime and 24X7 support. Read about how EchoStream for AIX can improve your Data Recovery strategy.
Are you having a hard time understanding the value of upgrading to SQL Server 2008? If so, then you should read this white paper. In this paper, you will find seven different compelling reasons why you should upgrade to SQL Server 2008.
In order to keep your business going you need to analyze and understand your customers. Gaining a good understanding of your current customers, and why they keep coming back provides you with valuable insight. This knowledge can then be used to keep current customers and attract additional customers. Read this white paper to find out how to get a 360-degree view of your customers.
Having a robust Enterprise Security Architect is at the heart of making sure your data is secure. This research paper looks at the different components of developing and maintaining an Enterprise Security Architecture. Keeping your data accessible and secure is the key to providing your data to those that need it and restricting data from those that should not have access to it.
Data Recovery is important. You need to consider how to support short-term data recovery situations, but also long-term situations. Having adequate backups and managing those backups is critical to successfully recovering data when recovery is needed. Read this white paper to understand the key considerations for long-term storage.
More Market Research...
More Whitepapers...
DBA Videos
 |
By Jason Gilmore
Published April 27, 2010
This video introduces you to EXPLAIN, guiding you through two examples explaining how this powerful feature can be used to boost MySQL database performance.
|
 |
By Jani Jarvinen
Published April 16, 2010
Watch this screencast to learn how to build a Silverlight 4 application that uses WCF Data Services to retrieve data using drag-and-drop database connectivity in Microsoft Visual Studio 2010.
|
 |
By Jason Gilmore
Published March 30, 2010
Learn how to create a variety of powerful and visually appealing dialog windows using jQuery.
|
 |
By Jani Jarvinen
Published March 17, 2010
Learn how to use Windows Server's Performance Monitor utility to monitor performance of ASP.NET Web applications on IIS 7. This screencast talks about different performance counters and shows .NET developers how to select different ones.
|
(More Videos)
Receive news via our XML/RSS
feed
 
ARMS is a fully featured graphical database management suite that operates entirely from any modern javascript-enabled web browser.
Provides access to the Sphinx full-text search engine from any .NET application. Supports all major Sphinx versions (0.9.8, 0.9.9) and the upcoming 1.10.1.
Schema Visualizer allows you to create fully featured ERD.
|
Search Database Journal:
