(Tim Soderstrom) So last week MySQL was on site at work for MySQL DBA Certification prep. class (which was very awesome and highly recommended, by the way) and one of the things that came up was how much faster enumerated types would be over using JOINs, say to store things like the categories of a
Other News
SQL stored procedure profiling in DB2 Developer Workbench
(Cliff Chu) In a complex application or batch processing environment where many SQL procedures and SQL statements are executed, it can be difficult for a DBA to monitor and tune the SQL using traditional methods. Use IBM DB2 Developer Workbench (DWB) to profile SQL stored procedures deployed on DB2
5 things every SQL developer should know like the back of their hand…
(James Luetkehoelter) Since I had a post on 5 things a DBA should know, I thought I’d follow-up with a quick post about what *I* think any developer should know…
Report Execution Caching II: Report Manager Perspective
(William Pearson) Report Execution caching, one of three caching options within Reporting Services 2005, is turned off by default, as we learned in Report Execution Caching I. Therefore, the most basic difference between Report Execution caching and Report Session caching (the subject the first arti
Enhance Your Web Apps with T-SQL Tricks
(Andrew Bonslater) With all of the new functionality that’s been released with T-SQL for SQL Server 2005, you now have more options that make performing complex tasks very simple with very few lines of code. Explore a couple of tasks that are becoming quite common in many development tasks and learn
The Challenge of New Systems
New SQLonCall Show Live Now Basic Security Practices – Learn about mistakes commonly made when working with security and SQL Server. Lost consumer data, encryption, hacker attacks and much more – find out where to start looking and what to consider. > Watch The Show Here Featured Article(s) Troubleshooting SQL Server 2005 Snapshot Replication In this article, Alexander Chigrik explains […]
SQLonCall: Basic Security Practices – Learn about mistakes commonly made when working with security and SQL Server.
Pro-Center Video Programming for IT Professionals
Optimizing Infrastructure for your SQL Server Environment
Watch the Latest SQLonCall All about your first month on the job – things to think about, things to consider, key points to address. A great show with lots of positive feedback! An all-new show will post tomorrow – catch the current show today! > Watch Here Featured Article(s) SQLCMD — Part III (Vadivel Mohanakrishnan) This is the last part […]
Picture Your Code With Metrics
(Jeff Levinson) Visual Studio 2008 introduces new features in each edition. In the coming months, this column will examine these features and demonstrate how you can benefit from them in your development process. This column focuses on the addition of the code metrics feature in the Team Edition for
ASP.NET AJAX and Sys.Webforms.PageRequestManagerServerErrorException
(Ted Jardine) Using ASP.NET AJAX extensively in my latest project I’ve been sporadically running into the Sys.WebForms.PageRequestManagerParserErrorException. It got to the point that I was contemplating ripping out ASP.NET AJAX completely until this known issue had been ironed out. The various caus