(Rachel Baker) Data synchronization for occasionally connected applications is no easy task. Smart Client applications represent a highly responsive, rich user interface, but they can lose something when it comes to managing the flow of information across a distributed system. Data synchronization i
Other News
Asynchronous Execution in ADO.NET 2.0
(Satheesh Babu) ADO.NET 2.0 is packed with many new features that make the developers’ life easier. One such feature is executing bulk database operations asynchronously against a database. This article will help a developer to start programming asynchronous commands in ADO.NET 2.0. In previous vers
‘Going Open’ – Why & How? Part 1/2
(Mikko Puhakka) There is a going trend among companies not just supporting and appreciating open source, but also ‘’going open’’ by releasing their new development efforts as open source or converting their formerly proprietary offerings open source by releasing the source code under some open sourc
The IBM DB2 Detective Game
(Joanna Kubasta, Joanne Moore and Matthew Bennett) Here’s a fun way to learn about IBM DB2! Learn or teach the basics of DB2 and relational database with an interactive game called The DB2 Detective Game. The game teaches relational database concepts and shows how technology can be applied to solvin
Oracle Grid Control: The Importance of Deleting the emkey
(Grégory Guillou) Oracle Grid Control documentation warns against leaving the emkey in the Grid Control repository. It says here: After the emkey has been copied, you must remove it from the Management Repository as it is not considered secure. If it is not removed, data such as database password
Rebuild indexes online with SQL Server 2005
(Tim Chapman) Indexes are specialized data structures that operate on tables (and sometimes views) in the database engine used to aid in the searching for and sorting of data. Indexes are vital to the database engine returning results quickly. As data is modified in the underlying tables that the in
SQL Server 2005 Express Edition – Part 12 – ClickOnce Deployment and Updates
(Marcin Policht) In the previous installment of our series dedicated to SQL Server 2005 Express Edition, we presented the publishing options of ClickOnce-capable applications (leveraging functionality built into .NET 2.0 Framework) that involve User Instance-based databases, by reviewing the interfa
Owner/schema qualifying object names
(Tibor Karaszi) It isn’t easy to remember all the details regarding object/schema qualifying object names. There are many variables involved, such as: –Version of SQL Server –Qualifying the owner when you call the proc (EXEC dbo.procname) –Qualifying object references inside the proc code
SQL Server 2005 cannot index some 2007 Office document formats
This problem occurs because SQL Server 2005 does not contain the 2007 Office IFilter.
DB2 LUW: Security Vulnerability Alert
(Scott Hayes) A lot of attention is being paid these days to database security and auditing. IBM has made great improvements in security and auditing with DB2 9.5 (Viper 2). Still, there remains a security vulnerability that many auditors and security administrators are not aware of, and I doubt tha