(Jeff Langr) Some developers hold design patterns up as a lofty standard, an ideal. I’ve even seen some developers worship patterns so much that they were lax to use them on anything but a high-visibility implementation. On the contrary, many design patterns should really be used fairly frequently,
Author: SSWUG Research
SQL Myth: Truncate Cannot Be Rolled Back Because It Is Not Logged
(Denis Gobo) I am still amazed at how many people still think that TRUNCATE TABLE is not logged. There is some logging going on but it is minimal, here is what Books On Line says: TRUNCATE TABLE removes the data by deallocating the data pages used to store the table’s data, and only the page dea
Clustering – How many servers should I use?
(Szymon Machajewski) In this article we will discuss some of the challenges of estimating cluster sizes in high availability systems.
Protect sensitive data with .NET 2.0’s SecureString class
(Tony Patton) One of the trickier aspects of development is working with sensitive data such as social security numbers, employee identification numbers, and so forth. The .NET Framework includes cryptography functionality, but it is often overkill for smaller applications. Beginning with .NET Frame
Do You Want to Ignore Clustering? [DB2 9 for z/OS]
(Craig Mullins) DB2 9 for z/OS offers a new DDL parameter for your tables: APPEND. If you specify APPEND NO, which is the default, DB2 will operate as you are accustomed to it operating. That is, when rows are inserted or loaded DB2 will attempt to sequence them based on the clustering index key.
ASP.NET Master Pages Tips and Tricks
(Dan Wahlin) With the release of ASP.NET 2.0, developers were given a simple and effective way to apply a consistent layout across multiple pages in a website. By creating a file with a .master extension that defined a website’s overall layout template and referencing it with the Page directive’s Ma
Achieving Openness: A Closer Look at ODF and OOXML
(Sam Hiser) An open, XML-based standard for displaying and storing data files (text documents, spreadsheets, and presentations) offers a new and promising approach to data storage and document exchange among office applications.
What You Need to Know about REST
(Loraine Lawson) I’m seeing a lot of information these days about using REST – representational state transfer – and its use within service-oriented architecture.
Changing Dimensions in Parent Child Hierarchies
(Richard Tkachuk) A changing dimension is a common issue in many OLAP applications. The problem is pretty broad: – Members moving around. For example, after a company reorganization a sales region can be moved from one area to another. – Characteristics of a dimension member change, For example,
MySQL and the The Death of RAID
(Kevin Burton) RAID is dying. Shocked? The prediction might be a bit early for some folks. It’s still somewhat conventional for some people to think that RAID is a conservative way to scale your IO.