(Matthias Nicola) DB2 9 introduces pureXML support, which means that XML data is stored and queried in its inherent hierarchical format. To query XML data, DB2 offers two languages, SQL/XML and XQuery. Additionally, DB2 9 has sophisticated XML indexing capabilities and support for XML Schema validat
Other News
Administering MySQL Using Flex
(Jack Herrington) PHPMyAdmin rocks. Of that there can be no question. It’s easily one of the best PHP-based applications, because it trades the clunky command-line interface for MySQL administration for the web browser. But while it’s very powerful, it’s not very friendly to use or easy on the eyes.
Create dynamic Firefox user interfaces
(Adam Pilkington) When you create browser-based applications that display XML data feeds, you often need to code the data-retrieval mechanism and the user interface. Mozilla Firefox provides an infrastructure that frees you from these tasks, so you can concentrate on your application’s functionality
Working with LINQ in Visual Studio 2008
(Tony Patton) Last week, I introduced the basics about the .NET Language-Integrated Query (LINQ) technology. Now I’ll cover how the O/R Designer feature in Visual Studio 2008 allows you to use LINQ to access SQL Server.
Onchanged Event for Composite User Controls
(Michael Livshitz) In a previous article we discussed some ways to create composite user controls with OnChanged events. Our goal was to catch any data changes, which could occur on some form with many controls, and then to react to these changes by starting some process, prompting with a question o
Changing The Background Color of a TabControl’s Tab
(Ged Mead) I’ve noticed a couple of questions in the VB.NET forums recently where someone wants to change the BackColor of the Tab Header on TabPages. As far as I know, in VB2005 and earlier you have to either use OwnerDraw techniques or subclass your own version of a TabControl.
Creating Composite Controls
(Bipin Joshi) So far in this series you developed controls by emitting raw HTML markup. As you will agree with me this can be tedious at times. Won’t it be nice if you can assemble existing controls of ASP.NET and render them as a part of your control? In fact this is a common requirement in many ca
Microsoft SQL Server 2008 – Change Data Capture – Part I
(Muthusamy Anantha Kumar) One of the new features in Microsoft SQL Server 2008 is the ability to track changes on a table. You can enable change tracking on a table using the Change Data Capture feature.
SQL Server 2005 – Backup, Integrity Check and Index Optimization
(Ola Hallengren) I have made a solution for backup, integrity check and index optimization in SQL Server 2005. The solution is based on stored procedures, functions, sqlcmd and SQL Server Agent jobs.
New Best Practices Whitepaper published: ‘Database Mirroring and Log Shipping Working Together’
(Sanjay Mishra) Log shipping and database mirroring can work together to provide solutions for high availability and disaster recovery. You can convert an existing log shipping configuration to a database mirroring configuration. Although Microsoft only supports a single mirror database, you can set