(Michelle A. Poolet) Traditional database design techniques such as the Systems Design Life Cycle (SDLC), also known as the Yourdon Waterfall method, and Information Engineering (IE) were created to make design a manageable process, complete with tools, milestones, and reviews. A design-testing
Other News
Tame Those Strings! Part 7 – Proper Casing Strings
(Steve Jones) I recently saw someone ask a question about how to proper case a field of data. I thought this would be a simple update statement, but when I actually tried it, I realized there was a bit more work involved. In the instance that I saw, the person wanted to handle a field that conta
SQL Server Contention: Diagnosing and Resolving Blocking Problems
(John Theron) As we develop SQL Server applications with more and more concurrent users, there is inevitable contention as users compete for data resources. They are either forced to wait for each other or face the risk of reading inconsistent data due to in-progress changes. This trade-off bet
Monitoring and Troubleshooting Transactional Replication
(Baya Pavliashvili) This article shows you how to check replication functionality and how to troubleshoot errors. As you might imagine, it is impossible to predict every error that you might encounter. Instead, I will show you how to detect errors and where to look for clues to troubleshoot repl
FIX: You receive an exception when you call an extended stored procedure from an ASP.NET Web application
When you call an extended stored procedure that raises an error that has a low severity of less than 10 from a Microsoft .NET Framework Web application, you may receive one of the following exception error messages: Error message 1 A severe error occurred on the current command. The results, if
Play It Safe – Security and ASP.NET Applications
(Don Kiely) By default, all ASP.NET applications run with full trust. But “full trust” essentially tells the Common Language Runtime (CLR), “Trust this code. Don’t check for permissions. Even if the code tells you to turn off security features that you normally use to maintain tight protection again
TechTip: New Tool for Analyzing DB2 Performance
(Kent Milligan) If you’re looking for a reason to upgrade to V5R3 or if you’re wondering how to get more out of the latest release, then look no further than the new Index Evaluator. This new function makes it easier to analyze which indexes (and keyed logical files) are helping your SQL and query p
IBM Updates Application Development Life-Cycle Management Tools
(Barbara Darrow) IBM updated several of its application development life-cycle management tools recently as part of its never-ending On Demand marketing campaign.
MDX Essentials: Logical Functions: The IsEmpty() Function
(William Pearson) In this lesson, we will introduce a function that assists us in the handling of empty cells. In multidimensional data sets, we are often confronted with empty cells – data is often sparse in these sets by their very physical nature. Because, as a simple example, every product might
Render dynamic graphs in SVG
(Brian Venn) Scalable Vector Graphics (SVG) is an XML-based language for drawing two-dimensional graphics. The ability to render graphics on the fly lends itself naturally to using it for representing data such as graphs. But suppose the data being represented varies in its magnitude. You may want t