(Dinesh Asanka) SQL Server Reporting Services (SSRS) in SQL Server 2005 has given users many options to on how to create a report. This article describes several methods that can be used to develop the same report. In addition, we will analyse the performance of each method so that we know the pros
Other News
Using Design Time Attributes
(Bipin Joshi) Developing a nice custom control is just one part of the story. As a control author you should also pay attention about the experience of other developers who will be using your control. In most of the real world cases developers use Visual Studio as the IDE for developing .NET applica
Using the event scheduler with OS commands
(Giuseppe Maxia) One of the major additions to MySQL 5.1 is the the event scheduler. It is an internal scheduler, which does not need any help from the operating system. As such, it works independently in every platform.
TSQL String Array Workbench
(Robyn Page and Phil Factor) Arrays aren’t difficult in SQL Server 2005. Here’s a very simple technique that can be extended to do some remarkably complex string processing.
SSIS: Execute SQL Task
In one of our previous blog posts, we had covered the basics of SSIS and had also given a comparison between DTS and SSIS. We had also covered Business Intelligence Development Studio (BIDS) and the different features of BIDS. We also discussed about the various design panes available in BIDS. We ha
Practical Applications
(Buck Woody) SQL Server runs on several platforms, from handheld devices to multiprocessor servers. Its versions include everything from personal to enterprise editions, and it supports several access interfaces including application programming interfaces and remote data access methods.
Oracle BI EE 10.1.3.3/2 – Rolling Year,Month and Date filters – Moving Window Filters
(Venkatakrishnan J) I have received this question a couple of times before and this also came up in the forums today. Lets look at the question first (modified version of the original question to make it more clearer). “I have a dashboard prompt wherein the user can choose any year (using a dropdown
Distributed DBA: DB2 Deep Compression, Part 2
(Roger E. Sanders) In my previous column, I mentioned that the enterprise database growth rate is about 125 percent annually. As databases grow, so does the need to preserve, protect, distribute, and derive value from the data stored in them. To help minimize storage requirements for growing databas
SQL Server Community Survey
> Watch SelectViews, the SQL Server Show, Here. Featured Article(s) Increasing Query Performance Using Oracle 11gs SQL Query Result Cache Oracle 11g has a new feature called the SQL Query Result Cache. This feature is useful when a query returns large amounts of data that is fairly static. When this situation occurs, the feature may improve query performance. This article […]
New IBM Software Brings Web 2.0 to Mobile Phones
IBM announced that the Lotus Expeditor software platform is extending desktop computing and Web 2.0 capabilities to mobile phones.