(Justin Finch) If you have been working with WPF and have had issues with your ComboBox or any list control binding then you can stop pulling your hair out. The problem occurs when you try to bind the SelectedValue property of the control to a Nullable Int (int?).
Author: SSWUG Research
What happens to non-clustered indexes when the table structure is changed?
(Paul Randal) Here’s a topic that’s cropped up several times during Q&As at TechEd this year – what happens to non-clustered indexes when changes are made to the underlying table? Are they always rebuilt or not?
Load a Spreadsheet from a DB2/400 Database
(Ted) I know from my reading that it is possible to make an Excel spreadsheet read from an iSeries database. I’ve been an RPG programmer for years, and I don’t know where to start. Can you point me in the right direction?
XQuery, the Server Language
(Kurt Cagle) Over the years, I’ve had the chance to program in a lot of different server-side scripting languages–C, Perl, ASP, JSP, PHP, ASP.NET, Python, Ruby, among others. It seems every few years that we programmers decide that we’re bored with the current language and would like to try somethi
DB2 and Ruby on Rails, Part 2: DB2 and pureXML with Ruby on Rails
(John Chun, Christine Law, Salvador Ledezma and Alex Pitigoi) XML is one of the most common data interchange formats on the Web today. DB2 support for pureXML, combined with the parsing and generating XML APIs (REXML) available to Ruby on Rails, provides a powerful combination for Web application de
Piecemeal restore with SQL Server 2005
(Baya Pavliashvili) With each release of the software Microsoft has made great strides in improving their primary database platform. SQL Server 2005 is a true enterprise class database platform capable of supporting scalability and availability needs of the largest and most complex databases. Not th
SQL Server Management Objects
(John Papa) Not only must database developers query and manipulate data, but they must also perform administrative tasks on a regular basis. SQL Server™ Management Objects (SMO) offer developers a robust toolset for operations such as backing up and restoring databases, and issuing Data Definition L
Find size occupied by millions of rows without VSIZE function
(Brian Peasland) I am working on Oracle 9i. One of my tables contains around 10 million records. I want to find out the size occupied (in MB) by the first 8.5 million rows. I cannot possibly use the VSIZE function because my table contains 136 columns (which means writing 136 queries). (R)
Improving the MySQL Test Framework
(Charles Cahoon) In my last post I reviewed how to create a test case using multiple connections and it is quickly apparent that keeping track of concurrent connections within test cases is difficult and error prone. Creating a tool to make test case writing easier and more automated is the goal of
Customizing the Login Page in SharePoint 2007
(Damon Armstrong) Microsoft SharePoint 2007 gives you the option of using forms authentication, but the out-of-the-box forms-based login experience is fairly bland. It’s not bad if you’re doing something for internal use, but if you’re doing something for internal use then you’re probably using Wind