While SQL Server doesn’t provide native support for hierarchical data, it’s not that hard to add. R.L. Parker explains.

by Kathleen Wheatley – Companies talk all the time about their data and information being “mission-critical,” “strategic” and “available 24/7,” but reality often doesn’t match the claims. SyZLaB, a Norwegian company that develops and sells web publishing and content management systems, doesn’t have

(Madeline Bennett) Microsoft will next month begin beta testing its new patch installer, which promises automatic updates for a number of products. Microsoft Installer 3.0 is a unified update tool for several products, including Office, Excel and SQL Server. It will be followed by an installer fo

By Paul Roberts – A scheduled denial of service attack against Microsoft Corp.’s main software update Web site did not materialize Saturday, as computers infected with the W32.Blaster worm failed to find their target.

Book by Sharon Allen – Data Modeling is about gathering, documenting and communicating the elements and structure of business information. What begins as a conceptual interplay of logical data units, through the application of rational theory, becomes the basis for creating a physical database desig

By Ron Ben-Natan – Well-written code, intrusion-detection systems, and traditional firewalls guard different aspects of your application systems. But how do you protect your data? Consider an SQL content firewall as your next security layer.(R, $)

By Lance Ulanoff – What’s more important than figuring out how to get uninfected? Avoiding infection in the first place. Here are some simple steps you can take to safeguard your systems.

To be an effective database programmer, you need to master SQL for the database you’re going to be using. This book will teach you the concepts, terms, and skills you need for designing and working with any database.

From SQLSecurity.com – For any of you that have spent the better part of today patching machines that STILL haven’t got the MS03-026 patch installed, I recommend you take a look at HFNetChkLT at www.shavlik.com. It’s been a lifesaver for me (I actually use the Pro version for sending out SQL Server

By Russ Whitney – Member properties let you store additional information about dimension members, but they can do much more. Are you getting all you can from your member properties? Here are 10 ways to pump up member-property effectiveness. (R, $)