(harryteck) This article describes how to switch data sources (datasets) when working with a report using Microsoft Reporting Services with SQL Server Business Intelligence Development Studio. This is important when your report may utilize different data sources, for example, one for test and one fo
Other News
Avoiding Blocking Issues in ASP.NET Session State Databases
(Greg Low) As soon as ASP.NET systems grow to the point that more than a single web server needs to be deployed, decisions need to be taken about where the session state will be held. By default, ASP.NET session state lives in the memory of the server hosting the application. The problem with this i
SQL Server Maintenance: I Just Do Not Get It
Last Day to Catch the Current SelectViews Our next weekly SQL Server show will post tomorrow – catch the current episode here. Please be sure to check out the SQL Server challenge – we need your help! Also, by taking a stab at the challenge, you could win $200. Need I say more? > Watch the show here Sometimes There […]
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 […]
Compression Chat with the lab
(Chris Eaton) The next live chat with the lab is schedule for this Thursday, September 27, 2007 at 8 AM PST, 10 AM Central, 11 AM Eastern, 4 PM London, 5 PM Paris. This session is titled Deep Dive into Deep Compression – a look into Compression in Viper and Viper 2 with the compression features lead
Histogram Statistics [DB2 9 for z/OS]
(Craig Mullins) Another utility upgrade that has found its way into DB2 9 for z/OS is the ability to gather histogram statistics. This feature is already available in DB2 for Linux, Unix, and Windows… and after you migrate to DB2 V9 it will be available to you on z/OS.
FOR XML
(Johnny Methane) People often say to me “Johnny, why use FOR XML in SELECTS, when you can be better occupied pulling your knickers over your trousers in a phonebox somewhere?”. And I repy that the work of a superhero involves more than just outrageous fashion statements. Sometimes I want to serial
XML-Enabled Applications – Part 2
(Yuli Vasiliev) The preceding example shows how you might move the XML processing performed by your PHP/Oracle application from PHP to Oracle, thus taking advantage of the optimizations provided by the Oracle database server. In particular, you saw how to generate an XML document from scratch and ap
How Far Has XML Come?
(Joe McKendrick) It was well over a decade ago that XML was first introduced as a lingua franca that could bring together even the most disparate data environments. While it has become a fairly ubiquitous part of the enterprise landscape, has it lived up to its promises? A mixed picture emerges. M
Access and Oracle Part I
(Howard Rogers) I’m not entirely certain whether anybody develops client-server applications any more! These days, it seems to be all about SOA and J2EE and a bunch of other abbreviations for exotic n-tier/middleware/application server technologies I don’t even pretend to understand.