(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?
Other News
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?
WPF ComboBox doesn’t bind correctly – Binding to Nullable Ints
(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?).
How To Protect Yourself From Fat-Finger Sally, Crazy Bosses and Other SQL Villains
(Denis Gobo) You all have been through this at least once in your life. In your shop there is this one person who likes to use Enterprise Manager as their Rapid Data Entry Application. We all know how these people operate; they delete rows, drop tables and all kinds of other funky stuff. SQL Server
Personalizing RSS Feeds with ASP.NET 2.0
(Erich Peterson) Really Simple Syndication (RSS) is a common XML standard for syndaicating web content. It is typically used by content-producing sites to offer a machine-readable version of the latest headlines. For example, news sites like CNN.com and MSNBC.com offer RSS feeds for breaking news; m
Security and Compliance: Bringing Order to Information Chaos
(Mark Leon) Governing data is a little like governing people. Left to themselves, people will devolve into a “state of nature” in which civilization as we know it cannot exist.
ASP.NET Complete Life Cycle
(Srinivas Jadhav) Since too many resources are shared on the process level (i.e. IIS, inetinfo.exe) and it is too easy for an error to bring down the entire server process, ASP.NET provides an out-of-process execution model, which protects the server process from user code.
Convert XML to JSON in PHP
(Senthil Nathan, Edward J Pring and John Morar) With the growing popularity of Web 2.0, a new data interchange format called JavaScript Object Notation (JSON) is emerging as a useful way to represent data in the business logic running on browsers. Learn how PHP-based server programs can convert XML-
Project Management Requirements Unique to Data Warehousing
(Alan Schlukbier) Recently, several project managers approached me about some common misconceptions about data warehousing. Knowing that I had worked for over 15 years as a consultant and completed over 100 data warehouse contracts, they urged me to publicize what is unique to data warehouse project
ObjectDataSource in ASP.NET 2.0
(Kuldeep Deokule) A new data bound control integrated in ASP.NET version 2.0 allows for a 3-layer architecture. Using ObjectDataSource control, you can separate the presentation layer, business layer and database layer. Presentation layer contains the web page (UI) while the business layer incorpora