Don Schlichting

Introduction The previous article began with the benefits of utilizing Microsoft SQL Server for Internet Information Service (IIS) web log analysis. While there are many third party packages on the market for web log analysis, sometimes you may need highly specific information derived from the logs, in these cases, SQL Server is a very good […]

Introduction This article explores the benefits and various methods of using Microsoft SQL Server to analyze IIS Web Server log files. The web server included with Microsoft’s Internet Information Services (IIS) can be configured to keep detailed logs of web visits. There are many advantages to keeping web logs, including the ability to detect growth […]

Introduction In Part 1 of this series, the new SQL Server 2005 Management Studio was introduced. The new studio combines many of the features found in SQL 2000 Enterprise Manager and Query Analyzer, in addition to many new additional features. Some of the topics covered in the previous article included using the Studio for Registering […]

Introduction Included with SQL 2005 is the new Management Studio graphical interface. This tool combines many of the features that were previously found in the SQL Sever 2000 Enterprise Manager and Query Analyzer. Those features are now combined into one interface along with a high number of enhancements. This article will introduce many of the […]

Introduction The purpose of a Join is to combine query results from two or more related tables into one logical result set. If a database is designed for OLTP (Online Transaction Processing) or data entry, then many related tables will be used in the design rather than one large all encompassing table. By using many […]

Introduction In Part 1 of this series, the purposes and reasons for using Joins were explored. The advantages and disadvantages of Joins were also discussed. The conclusion was that SQL Server transactions will perform well when the database is designed with multiple related tables, as opposed to a single, large, multi-field table. If this design […]

Introduction This article explores various methods of Joining, where data from multiple tables are returned in one record set by defining logical relationships. Microsoft SQL Server, being designed as a relational database, offers performance and integrity gains if data is organized into related tables, as opposed to placing all the data into one large table. […]

Introduction This article, the last in the Stored Procedure series, will focus on RETURN parameters. The first article in this series explained the benefits of using stored procedures as well as an example demonstrating a data grid being populated from one. The DOT NET aspx web page developed in C#. The second article covered INPUT […]

Introduction This article focuses on using a stored procedure to insert a new record from data collected on a web page, then passing an identity value created from that row back to the web page. In the previous articles in this series, Part One described the benefits of using stored procedures along with an example […]

How to pass parameters (variables) IN, OUT, and RETURN error codes from a Stored Procedure to a Web Page. Introduction In the first article of this series, the reasons for using stored procedures as well as the relatively easy learning curve involved were discussed. In addition, an example involving a stored procedure being executed from […]

This article will explore the hows and whys of executing SQL Stored Procedures from inside a web application. Introduction There are so many good reasons to use SQL Stored Procedures from inside web applications (as opposed to passing a query string), that the benefits of working with them will far outweigh any learning curve required. […]

Introduction SQL Server 2005 includes a banded reporting tool and engine called SQL Server Reporting Service (SSRS). Developing reports in SSRS is similar to report building in Crystal or Microsoft Access. Reports can be viewed in a web browser, exported to a file, or embedded into a Windows form application. Last month’s article covered SQL […]