(Michael Blaha) Referential integrity is a database constraint that ensures that references between data are indeed valid and intact. Referential integrity is a fundamental principle of database theory and arises from the notion that a database should not only store data, but should actively seek to
Author: SSWUG Research
Reliably making a web-request from the database
(Rushi Desai) One of the prime use cases of the CLR integration in SQL Server 2005 is to make outbound HTTP requests to web applications or web services. But how do you do that reliably given the large number of failures that need to be handled ranging from network unavailability, server timeouts,
Caching for XMLPerformance
(Tom Yohe) Highly scalable implementations of service-oriented architectures (SOAs) always include heavy doses of caching. A guided tour through the SOA tiers, describing the caching and XML acceleration techniques employed along the way, provides the SOA enterprise architect with an awareness of op
Understanding error handling in SQL Server 2000
(Tim Chapman) Most iterative language compilers have built-in error handling routines (e.g., TRY…CATCH statements) that developers can leverage when designing their code. Although SQL Server 2000 developers don’t enjoy the luxury that iterative language developers do when it comes to built-in tools,
Relationships: modeling relational data in XML, part 3
(Kevin Williams) In this series, we’ll take a look at how relationships (in the relational database sense) are modeled in XML. Armed with this information and the information from the articles one and two in this series, you’ll be able to dive in and get started modeling your relational data in XML
Learn the best way to combine strings in VB.NET
(Irina Medvinskaya) Combining strings in VB.NET is a simple operation. You can utilize the & operator to add a string to the end of another string, or use the Insert method of a String object to insert a string within another string. While both & and + operators allow you to combine the strings, it’
ASP.NET Tip: Responding to the Repeater Control’s ItemCommand Event
(Eric Smith) I’m a bit of an HTML purist, so I love the Repeater control. It allows me to specify exactly which HTML ASP.NET uses to create a table, list, etc. without it adding a bunch of extra junk. The Repeater, like other data-bound controls, contains some events to help you respond to the actio
Patterns for smart devices: Solving the multiple resolution/orientation problem
(Daniel Cazzulino) The reality of mobile development (especially if you’re creating a product) is not so different to that of Web development: the clients that will be using the application may not be under your control, and they may support different sets of features and capabilities. In the ASP.NE
IBM DB2 Universal Database and the Java Developer? Absolutely! – Part 5
(Paul C. Zikopoulos) Part 5 and 6 of this series focus on the built-in SQL Builder and SQL Editor (here-in referred to as the SQL Builder) in Rational AD. Here in Part 5 I will show you how to use it to build SQL statements that you can use in your Java programs, Web services, routines, or just stan
Integer Arrays Using T-SQL
(Chris Martinez) Anyone that has worked with SQL Server for a while undoubtedly has come across a scenario where they needed a way to pass an array as a parameter to a stored procedure. One of the most common of these scenarios involves a stored procedure that must be executed passing numerous prima