(Brian Eastwood) As Visual Basic 9 nears its year-end release, Microsoft is making a concerted effort to introduce developers to its new features — notably the Language Integrated Query, or LINQ, but also improved XML support and more intuitive IntelliSense. (R)
Author: SSWUG Research
(67) SelectViews: Interviews with Stephen Walther, Kat Meadows, Brian Dawson and great solutions profiles.
Video Programming for IT Professionals
QA Strategy and Tactics in a BI Project, Part 2
(Arup Duttaroy) Part 1 detailed the foundational elements of quality assurance (QA) and discussed the importance of documentation in change management and quality reviews. Part 2 is an in-depth discussion of the QA organization.
MySQL Test Case Creation Tool
(Charles Cahoon) The MySQL test framework needs a tool that will increase the production of test cases. The proposed tool will be a command line client that records queries and responses to then create the .test and .result files. There were a couple of proposed options that would also achieve a sim
System Administration Certification exam 918 for IBM Informix Dynamic Server 11 prep, Part 3: System activity monitoring
(Joseph W. Baric, Jr.) Explore the topic of troubleshooting for IBM Informix Dynamic Server. After a brief overview, you’ll learn about the various tools that are available for troubleshooting, and then look at examples of how to examine the database server to solve problems. The third in a series o
Transformations
(Joseph Fuda) This tutorial demonstrates how to transform numbers like 1, 12, and 123 into English words like “ONE”, “TWELVE”, and “ONE HUNDRED TWENTY-THREE”. This transformation is a common requirement for cheque printing applications.
Top 5 Myths About Patching Apps Environments
(Steven Chan) A rational person might contend that actions follow attitudes which follow beliefs. Bad news: there’s a substantial amount of psychological literature that suggests that this isn’t how we really tick.
Something old, something new, something DB2 9, something blue
(Willie Favero) Yes, I know that’s extremely corny. However, for this particular post it’s actually fairly accurate. We’re going to talk about how a bind parameter is switching back to its old original default, how one of the oldest bind parameters is taking on a new default, we are talking about DB
Returning Complex Data from User-Defined Functions with CROSS APPLY
(Jeff Smith) SQL Server User-Defined Functions (UDFs) can return either a single value or virtual tables. However, sometimes we might like for a User-Defined Function to simply return more than 1 piece of information, but an entire table is more than what we need. For example, suppose we want a func
Generate SQL Statements with objects, Attributes and Reflection
(Edmund H Smith) Many developers hate one thing about software development, writing SQL Statements. SQL is a language on its own and it is ubiquitous in today’s development environment. When there are changes made to the tables, we have to modify the affected SQL statements, be it in the application