A Guide to Microsoft SQL Server Replication9/02 Replication
is the technique of keeping the database between various SQL Server instances
up-to-date as the database changes. There are different replication
technologies available in SQL Server, one of which uses different techniques of
providing various levels of currency in the data.
Introduction to SQL Server Proactive Caching9/02 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 Partitioning9/01 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 Questions9/01 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 Collaboration9/01 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 Reference8/31 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.
Secrets of SQL Server Webcast Series from Idera
Idera will share SQL Server BI best practices; demonstrating how to build a data mart and use analysis and reporting services to improve BI.
Developing iPhone/iPad Apps with MonoTouch By Chris Bennett
Published September 1, 2010
Developing for the iPhone/iPad usually means you will need to learn Objective-C; however, with MonoTouch, we can leverage the Mono Framework and make it possible to create C# applications that run on the iOS platform. Come along as Chris Bennett demonstrates how to get started building iOS applications using MonoTouch.
Processing HTML Form Input with PHP By Jason Gilmore
Published August 3, 2010
In this Internet.com screencast you'll learn how to process data submitted through an HTML form using PHP.
WP7 and Isolated Storage By Jani Jarvinen
Published August 20, 2010
Learn how Windows Phone 7 allows applications to use files and persistent storage when no direct file system access is allowed. You will learn how to do this using the Isolated Storage classes available on Windows Phone 7.
Connecting to Twitter Using Zend By Jason Gilmore
Published July 22, 2010
This screencast introduces you to the Zend Framework's Twitter component, which makes it trivial to perform tasks such as posting updates to your Twitter account and retrieving the latest updates from your contacts.
AnyDAC for Delphi (DA-SOFT Technologies) AnyDAC is the Universal Data Access Components for developing Delphi applications. AnyDAC powerful common architecture enables high-speed direct access to major DBMS.
SQL BakPack (Open Source SQL) SQL BakPack utilized the Microsoft SQL Virtual Backup Device API to stream backup data directly into the standard WinZip64 compression algorithms.
