Tomorrow’s the Day! Tomorrow we kick off the three-day virtual SQL Server conference, direct to your computer. We have a huge number of people registered already and we’re ready to go with more content than you can find anywhere else online, period. We’ve even opened up our webcast archives – you can watch past webcasts on-demand during the conference. From […]
Other News
Using a Custom Ribbon in Your .NET Applications
(John Mueller) Anyone who’s seen the Ribbon (also known as the Office Fluent User Interface) in Office knows that it’s completely different from the menu and toolbar interface used by applications in the past. After using it for a few hours, you may have even decided that the Ribbon was just a passi
XQuery Update and Node Identity
(Michael Kay) An interesting little spat on the XQuery internal mailing list over the last couple of days on the question of whether or not XQuery Update guarantees to preserve node identity. The spec says that it does. Someone remarked during a telcon that there were difficulties meeting this requi
The SQL Programming Language?
(Robert Catterall) During the mid-1990s, when I was with IBM, I did some consulting work for a large media company. These folks had a very sophisticated data warehouse set up, with DB2 for z/OS being at the heart of it all. One day, a person on the company’s data warehouse team asked me if I wanted
The information perspective of an SOA design, Part 2: The value of applying the business glossary pattern in SOA
(Brian Byrne, John Kling, Dr. Guenter Sauter and Peter Worcester) Do you find it challenging when simple terms cause your ideas about data integration to come across as confusing and ambiguous? This second article in the series "The information perspective of SOA design" helps you eliminate these mi
Saving (XML) data directly to disk
(Marco Gralike) I was asked, also after the former post “Selecting (XML) data directly from disk”, what the best way would be to save data directly (locally) to disk via XMLDB methods. I proposed a simple solution based on DBMS_XMLDOM.WRITETOFILE, I will demonstrate this below. My colleague Anton ca
ASP.NET’s New LinqDataSource Control Simplifies Data Access
(Thiru Thangarathinam) Any user-centric application you write will require some sort of data integration—at minimum, you’ll need to retrieve some data and display it in the user interface. Often, applications must retrieve data from multiple sources, such as memory collections, relational databases,
Prefetch on, prefetch off, prefetch on, prefetch off, prefetch….
(Willie Favero) Sequential prefetch has been a part of DB2 since Version 1.2. In fact, it’s hard to imagine getting along without. Even when the “R” in the plan table column ACCESSTYPE gets misinterpreted sometimes as a bad thing, if you’ve been around DB2 long enough you learn that an access using
Using ASP.NET 3.5’s ListView and DataPager Controls: Paging Through Data with the ListView and DataPager Controls
(Scott Mitchell) The GridView, DetailsView, and FormView controls all support out of the box paging support that can be enabled at the tick of a checkbox. When configured to enable paging, these controls automatically render a paging interface comprised of LinkButtons, Buttons, or ImageButtons. The
Adding RDL-Resident Code to Reporting Services Reports
(William R. Vaughn) When using the ReportViewer control in Visual Studio (2005 or 2008), you have ample opportunities to craft logic-driven SQL to build the rowset passed to the report or even munge the data values returned. Often, all you need to do is generate a string that’s based on input parame