(Buck Woody) More than any other tuning you can perform; creating efficient queries will always give you the most return for your time and effort. I’ve managed to squeeze a few more percentage points of performance by adding more memory and processors to a system, and I’ve been able to gain a few mo
Other News
SQLonCall: Managing DBA Team Morale
New SQLonCall Show Posted Working with teams, paying attention to Team Morale. How do you find the right players, provide the right training, and make sure you have the right environment? How do you make sure your team is working well together and is as productive and satisfied as possible? This show explores this and much more. > Click Here […]
SQLonCall: Team Morale. How do you find the right players, provide the right training, and make sure you have the right environment?
Pro-Center Video Programming for IT Professionals
SQL Server Ongoing Maintenance Best Practices
Last Day to Catch SQLonCall Tomorrow we’ll be posting the next SQLonCall show – now’s the time to catch the current show, all about things to think about when you’re considering and buying "black-box software" – those packaged solutions that work with your SQL Servers. > Watch the show here Work With Standards… Cross-Platform Part of the battle with teams […]
DB2 9 for z/OS Performance Summary
(Akira Shibamiya and Roger Miller) The key DB2 9 performance improvements are reduced CPU time in many utilities, deep synergy with System z hardware and z/OS software, improved performance and scalability for inserts and LOBs, improved SQL optimization, zIIP processing for remote native SQL procedu
TechTip: Accessing XML Data Sources from JavaScript
(Mike Faust) The JavaScript language has become a popular scripting language because it gives programmers the ability to enhance a static Web browser interface. One of the few shortcomings of JavaScript, however, is its lack of support for standardized data-access APIs like ODBC or JDBC. Fortuna
Apply Visual Studio Code Analysis to Beef Up Security
(Jason Schmitt) Source code reviews and inspections have long been considered economical methods for rooting out functional and design flaws in code even before applications make their way to testing. As security has grown in importance, and with the advent of web applications and professional hacke
Working with ASP.NET AJAX UpdateProgress Control- Part 2
(Nidal Arabi) This article is the second one in a series of articles about Microsoft AJAX Extensions (previously named ATLAS, I like the old name better). The first one did speak about the UpdatePanel. So keep coming back for more.
Working with Predicates in Collections
(Jim Mischel) Among the many interesting and useful things added in version 2.0 of the .NET Framework was the Predicate generic delegate. It’s not especially exciting by itself, but when you combine it with new methods in the Array and List classes, it becomes quite useful.
.NET Tip: Throwing Exceptions: Will You be Able to Catch What You Expect?
(Jay Miller) You know you should use try/catch blocks so that you can handle any exceptions that may occur, but are you sure you have the correct information in the exception? If you catch exceptions and then bubble them up to other parts of your application, you need to ensure that you maintain the