Featured Article(s) Why Use Foreign keys and Referential Integrity Why would you implement referential integrity? Is it beneficial to implement it all the time? When to make the most of it in your applications. Would You Be Interested in Participating in the April vConference? We’d love to hear from you – bright lights, stardom, great opportunities to reach 1000’s of […]

Webcast – Register Now Manage Space and Maximize Your Hardware Resources with Capacity Manager Todays SQL Server environments are growing faster and are more essential to your organization than ever before. But tight IT budgets mean you’ve got to use your resources to manage your environment as efficiently as possible. What if you had a powerful tool for effectively controlling […]

Featured Article(s) SQL Server 2005 Linked Servers Optimization Tips Here you can find some useful tips to use SQL Server 2005 linked servers. Change, Updates and Proactive Review of SQL Server Installations, Applications David wrote in with some feedback on the question of proactive review – I think probably this approach applies to a huge number of SSWUG readers. I […]

Out Looking for Trouble I talked yesterday about going back and revisiting systems that are up, running and don’t have known issues. I asked about your experiences – and one of the responses was from Clayton – thought I’d pass it along. "As part of creating Data Warehouse solutions for clients, I typically perform a data quality check. This includes: […]

Legacy App Review Cycles Do you go back and review the schemas, design and maintenance for legacy applications, or are you more of an "if it ain’t broke, don’t fix it" type of DBA? So many of us support legacy applications – systems that were perhaps even built on prior releases of SQL Server, using the tools and features that […]

Troubleshooting Performance with Your SQL Server Non-intrusive ZERO Impact SQL capture allows every production server SQL statement with it’s performance to be captured 24×7. Requires no intrusive server profiles or traces that degrade the server performance by 25% to 60% (SQL Server Magazine, August 2008). Since 80% of database server performance problems are due to SQL, knowing the current and […]

Part of Database Recovery… … is the time it takes to actually do the recovery. Make sure you can recover specific items as you need to, and make sure it can be done accurately and in as little time as possible. If you’re not sure how to attack this and get your systems finely tuned to have things like recovering […]

Featured Article(s) SQL Server 2005 Transact-SQL Optimization Tips (Part 2) Here are some helpful SQL Server 2005 Transact-SQL tips. Building Reports Can Be A Time Black Hole… …but doesn’t have to be. Have you ever beat your head against the wall trying to get yet another report built for users – or, if you’re using a report, trying to get […]

"Enterprise Software" Seems that the definition is pretty varied from those that have had a chance to write in about what, exactly, is "Enterprise" software. Specifically, I was curious what this target was that keeps coming up when describing SQL Server – getting it "Enterprise-Ready." Ben: "Thanks, for the thought-provoking questions. Here are my three cents on this one. Being […]

Featured Article(s) XML Data Islands – What are they? [In this fourth tutorial of the series, we shall learn how to create these Islands of code and insert them into a HTML file. We shall also learn how to dynamically update the contents of controls within a HTML page.] What, Exactly, Makes "Enterprise" Software? The next version of SQL Server […]