(Eric Johnson) SQL Server Reporting Services (SSRS) is an extremely handy tool in the SQL Server 2005 suite. You can use it to easily create, deploy and manage reports for your entire organization. Its simplicity, however, can lead to a less then optimal configuration. You set it up, toss in some re
Other News
MySQL and VS 2005, New Webcasts Coming Up
Have You Seen the Latest SQL Server Weekly Show? Check out SelectViews – from SSWUG.ORG. The show is posted now and available for watching online. We cover a lot of different things in this episode – from working with management to our minicast about variables and stored procedures to updated software and much more. Check it out here. > Watch […]
More XML than code?
(Gavin King) In this article on JavaLobby, Daniel Spiewak, the creator of something called ActiveObjects takes some pot shots at Hibernate, and compares Hibernate negatively with Ruby’s ActiveRecord and ActiveObjects. Now, I’m always interested to read informed criticism, but in this case, Daniel se
Introducing ADO.NET with ASP.NET 2.0
(Michael Youssef) This is the first article in a series that I have written for anyone who wants to learn how to use ADO.NET technology, with an ASP.NET 2.0 page, to retrieve and update data. I assume that you have knowledge of C#, ASP.NET and Visual Studio.NET 2005.
Using RPG in SQL
(Paul Tuohy) You are well aware that you may use embedded SQL in RPG programs, but did you know that you can use RPG in SQL? Just as RPG allows you to define your own built-in functions (BIFs) by writing subprocedures, SQL allows you to define your own functions. But even more powerful is the fa
What’s worse than finding a NULL in a NUMBER column?
(Andrew Clarke) Finding half a worm! Oops, wrong punchline. No, the worst thing is finding a zero. Twice in the last week I have had to rewrite some code to handle an application which was using zero as a magic value instead of populating a numeric column with null.
How do I… Stress test MySQL with mysqlslap?
(Melonfire) One of the interesting new tools in MySQL 5.1.4 is mysqlslap, a load emulator that lets you see how well a particular query set or table engine performs under high-load conditions.
SQL Server 2005 Performance Audit : Introduction
(Brad McGehee) As a SQL Server consultant, I often get requests to “look over” a SQL Server and to offer suggestions on how to boost its performance. Sometimes this task is easy, and other times it is difficult. Based on experience, I have discovered that my time is best spent looking first for the
‘IBM Master the Mainframe Contest’ is back
(Willie Favero) For its third year, the “IBM Master the Mainframe Contest” is back. And this time we are including high school students. The timing is perfect for this because it goes along so well with the post I made a few days ago ( 09/12/2007 in a post titled Who’ll carry on when I’m gone?) abo
CodeSnip: Generic Lists, not just a .NET thing
(Ryan Estes) The Generic class is a strongly typed list of objects that can be easily referenced by index. Many .NET developers benefit from the Generic class because they are easily searched, sorted, and manipulated.