|
Database Management & Programming News, Articles & Tutorials for Database Administrators
4/09
Microsoft Access Small Business Solutions, published by Wiley, proves that Microsoft Access can be used to create valuable business solutions in theory and in practice by providing both the reasoning for the database design and the databases themselves in the CD that accompanies the book.
4/09
Before SQL Server 2008, you had to build a custom solution if you wanted to keep track of the changes to the data in your tables. SQL Server 2008 has a new offering called Change Tracking that keeps track of each DML event type and the keys of the row that was affected.
4/08
MySQL has an interesting architecture that allows you to plug in different modules to handle storage. What that means is that it's quite flexible, offering an interesting array of different storage engines with different features, strengths, and tradeoffs. Sean Hull presents some of the newest and more exotic storage engines, and even some that are still in development. 4/07
When generating a result set where the query contains an unknown number of column and/or row values we can use a combination of Prepared Statements, which allows us to tailor the output based on the number of data values. We can also add input parameters to a procedure to assign the field names, aliases, and even the aggregate function! 4/06
Robert Schneider spotlights capabilities present in Sybase Adaptive Server Enterprise (ASE) 15.5, paying particular attention to the new enhancements that help support better performance (via lower latency and very high transactional throughput), augment efficiency, and increased availability. 4/05
In this economy, IT professionals have to make smart choices when it comes to spending money on developer tools. Does the new Intellisense feature of SQL Server 2008 Management Studio make third party intelligent code completion tools like Red Gate SQL Prompt obsolete?
Database Development training series for FileMaker contains detailed, step-by-step instructions on key FileMaker development topics.
MySQL administration for the real world.
The O’Reilly MySQL Conference & Expo will have keynote address by Edward Screven, Oracle’s chief corporate architect.
Powerful MySQL database management tool to remotely manage multiple MySQL servers.
Exploring SQL Server 2008 R2 Reporting Services, the second segment of the "Secrets of SQL Server" webcast series announced.
The new SQL Server 2008 R2 PowerPivot for Excel resolves issue with expiration of the extension.
SQL Server on Intel Itanium not an issue even though development and maintenance of the processor will cease.
IBM's DB2 will be showcased as developers learn how to build applications in the cloud.
More Database News...
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.
Do you need more justification on why your organization should migrate to SQL Server 2008? This white paper describes some of the new features of SQL Server 2008, and how they can be leveraged to add value to your migration.
Master Data Management can make sure good business decisions are made based on accurate data. Read this white paper to learn more about how seven different cost saving steps can save your company money.
We have grown accustom to storing more and more data in our Data Warehouse. We are also looking at faster and faster hardware as a way to speed up these mammoth size Data Warehouses. New hardware is not the only solution for speeding up your warehouse. Now you can look at storing your data in a new database architecture that has been designed from the ground up to support Data Warehouses and Business Intelligence applications.
Organizations are saving more and more data every day. This has lead companies to consider a tiered storage solution to minimize their storage costs. Read this white paper to learn more about the different kinds of storage. Also, learn how you can exploit these different storage technologies to create a storage hierarchy that can reduce your overall costs for storing your corporate data.
Having clean data helps organizations make good business decisions. If your data contains errors then than any decision made using the bad data are suspect to also being bad decisions. You need to understand what causes poor data quality and the steps you should take to improve your organizations data quality.
More Market Research...
More Whitepapers...
DBA Videos
 |
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.
|
 |
By Dan Rigsby
Published March 2, 2010
Get a jumpstart on using Windows Communication Foundation (WCF) RIA Services to easily build robust and secure data driven Silverlight applications.
|
 |
By Jason Gilmore
Published February 17, 2010
Learn how to add Google Maps markers and store their coordinates in a database using a blend of jQuery, PHP and MySQL
|
(More Videos)
Receive news via our XML/RSS
feed
 
Reporting solutions for IT service management of large distributed business environments in an autonomous manner.
integration suite, integration tools, integration software
etl tools, etl suite, etl software
|
Search Database Journal:
