My articles on Microsoft Reporting Services

Review of these articles may help in understanding Microsoft SSRS (Vs 2003 & VS 2005; SQL 2000 and SQL 2005) in a reasonable amount of time.

On Importing an Access Parametric Report into SQL 2000 Reporting Services

ASP.NET and SQL 2000 Reporting Services

SQL Server 2000 Reporting Services: Creating a report from scratch

Creating a Chart with SQL 2000 Reporting Services

Building a Multi-table Report with SQL 2005 Reporting Services

Generating and Hosting a SQL Server Reporting Services Report Using SQL Server 2005 Business Intelligence Development Studio

This reader liked the article and he was kind enough to communicate to me:(name is masked)

Feedback sent from IP: 193.188.161.31
Referring URL: http://aspalliance.com/819Thankyou for providing such beautifully documented/illustrated mini tutorial on Reporting Services. Had purchased a book to learn RSS, but your tutorial although short was very precise and you spoke to the point. I really liked your method of exposing the basic intricacies in the Reporting Server. I now find it more easy to approach the Reporting Server.Thankyou once again for your efforts.Best Regards,XXXXXXX
"

About my new book on SSIS

About this book

Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 provides you with the basic knowledge that you should have before you move on to more advanced ETL [Extraction, Transformation, and Loading]. The book will also provide you with a comprehensive description of the many designer windows that you may encounter while working with the designer. A majority of SSIS tasks are covered in this book and they are described fully in the summary of table contents section. You start building packages right from Chapter 2 and continue on to Chapter 20 gathering and building upon your knowledge in each step.






The book will give you step-by-step explanation of the examples in the book. In each chapter you will get a little background of the SSIS task that you are going to create. You will then step through the numbered steps, creating, configuring, executing, and reviewing the results. The book has minimal coding (only two chapters) and exclusively uses the Visual Studio 2005 Designer.

This book is written for beginners in the developer track who are looking to get an exposure to SQL Server Integration Services; DBA's who are testing water with the Visual Studio IDE but without a wide programming experience; SQL 2000 Data Transformation Services users who are trying to move into SQL Server 2005 Integration Services; Microsoft programming professionals in Small Businesses who wear multiple hats (jack of all) - developer, programmer, and dba with a little bit of experience in each of these.

Links to my Migration articles

Here are the links:

Migrating from
Access 2000 to SQL Server 2000

Migrating from
Access to SQL Anywhere 9

Migrating from
Oracle 10G XE to SQL Anywhere 10

Configuring Web email's SMTP and POP servers

You do not have an ISP's Mail account , or you want a web based SMTP/POP access on your Laptop, but you do have a email client, no problem. You can use GMail (or Yahoo Mail) to send / receive emails provided you have a Google (Yahoo) Email account.

This is not special to Google (Yahoo), you can do this with many others. Do not configure two email accounts as you will get twice the emails, one from each account.

The following recipe (not mine, but Google's) does this set up for you. But before you do this, you need to login to your email account and once there, go to the Settings page. In Settings click on the menu item, Forwarding and POP. Now Click on the radio button, Enable POP for all mail that arrives from now. After this follow one of the following:

1. You can download Gmail's GmailConfig.exe and run it from your computer



2. You open up your email client's Account from the menu item, Tools (the following screen shots are for the email client, Microsoft Outlook Express 6) and make the appropriate entries into some of the tabbed pages. For the ones not shown here, the defaults are used.

In the page opened by your General tab you need to type in your Gmail account as shown. You can give your own name for the first box.



In the page opened by the Server's tab you type in as shown in the next figure. Do not forget the check marks.



In the page opened by the Advanced tab make these entries and click OK. The account is now ready.



This is all that is needed.

'Happy Emailing.

Here is a list of my XML / Javascript articles

Here is the list you may be intreseted in looking up:

Exporting XML from MS Access 2003
Importing XML into MS Access 2003
How to Load XML Documents in ASP.NET 2.0
Using Data Transformation Services: Can We Transfer XML Data?
XML and the SQL 2000 Server, Part 4: Introducing SqlXml 3.0
XML and the SQL 2000 Server part 3: XML Data with XPath Queries
XML and the SQL 2000 Server, Part 2
XML and the SQL 2000 Server, Part 1
Using MSXML3.0 with VB 6.0
Loading and Unloading XML Files Using Oracle 10G XE
JSON Basics
Displaying ADO Retrieved Data with XML Islands
The Why and How of XML Data Islands
CFXML: Probing XMLDOM in ColdFusion
XML Responses and AJAX
Roaming through XMLDOM: An AJAX Prerequisite
CFAjax: What it is and How to Use it
Step by Step to AJAX