(Jayadev D) When you use an XML data provider as a data source in SSRS, the query text generally consists of mainly of SOAPAction or MethodName tags. This also allows you to add an ElementPath tag which precisely filters the data you need to build a report.
Author: SSWUG Research
Using a Web User Control inside the GridView control
(Michael Livshitz) Developing some web site we often should use some control in the GridView control. In this case we have to create the GridView control with TemplateField columns and use some special methods to access needed data. Inside the GridView control we can use both standard server control
CLR Integration in SQL Server 2005 Using Visual Studio 2005 – Part 2
(Soyuj Kumar Sahoo) As I discussed in my previous article, CLR is the heart of Microsoft .Net framework. In SQL Server 2005 we can create a database object inside an instance of SQL Server that programmed in an assembly created by .Net framework. Assemblies are DLL files used in an instance of SQL S
Using the FILLBY Method to Filter DB2 9 Data Sets…with a Twist
(Paul Zikopoulos) Since the middle of 2006, I’ve been writing about all the great integration features in IBM DB2 9 for the Microsoft Visual Studio 2005 integrated development environment (IDE) and the accompanying ADO.NET 2.0 API.
Database Independent Development using ASP.NET 2.0: Dealing with Stored Procedures
(Jagadish Chaterjee) This is the second part of a two-part article. In the previous part we focused on developing database independent applications using ASP.NET 2.0. In this part, we will extend the functionality of the data access layer to the stored procedure level.
Building an Inexpensive Oracle10g Release 2 RAC on Linux – (RHEL 4.4 / iSCSI)
(Jeff Hunter) One of the most efficient ways to become familiar with Oracle10g Real Application Cluster (RAC) technology is to have access to an actual Oracle10g RAC cluster. In learning this new technology, you will soon start to realize the benefits Oracle10g RAC has to offer like fault tolerance,
The Seven Deadly Habits of a DBA
(Paul Vallee) Calling widespread bad habits in database administration “deadly” may seem extreme. However, when you consider the critical nature of most data, and just how damaging data loss or corruption can be to a corporation, “deadly” seems pretty dead-on.
MySQL: Transactions and Autocommit
(Roland Bouman) Some people believe that the ability to commit or rollback multiple statements as a single unit is a defining characteristic of the concept of transactions. They draw the -false- conclusion that enabling autocommit is the same as disabling transactions. It is easy to demonstrate why
Update all database statistics with a single command
(David) As with all RDBMS implementation, DB2 UDB uses the statistics information in the catalog table to derive the best execution plan. We, as DBAs, should regularly run the RUNSTATS command to keep our database statistics updated for optimal query performance.
Table partitioning with SQL Server 2005
(Baya Pavliashvili) Performance tuning is the ultimate responsibility of every valuable SQL Server administrators. Although ensuring data security and availability are our topmost goals, if the applications don’t perform to the users’ expectations, DBAs often get the credit, or blame, for poor desig