Playing with the .NET Jigsaw - So what can this thing do?

SQL Notes

Make sure you check out the Vistual Studio express range of tools from microsoft, If you are starting out in ASP.Net then make sure you have a copy of Visual Web Developer Express Edition and remember its free!

This page is still under development, sorry for any problems will be fixed soon.

General Relational Databases

Relational model

Relational Database


Back to Top

Getting Started

Wiki SQL Page

SQL Tutorial

Getting Started with Data Access

Back to Top

MS SQL Server

Resolving the ASP.NET Database Security Dilemma Make sure to read it


Back to Top


Back to Top

SQL 2005

SQL Server 2005 Express Edition

SQL Server 2005 Tools and Utilities

Microsoft Releases SQL Server 2005 Service Pack 2

The SQLServerBlog today posted that Microsoft have released Service Pack 2 (SP2) for download. SQLServerBlog outlines the following as some of the key enhancements to SQL server SP2:
Data Mining Add-ins for the 2007 Microsoft Office system enable data mining functionality from SQL Server Analysis Services (SSAS) to be used directly within Excel® 2007 and Visio® 2007.

SQL Server Reporting Services (SSRS) compatibility with Microsoft Office SharePoint® Server 2007 provides integration with the Report Center in SharePoint, enabling the seamless consumption and management of SSRS reports within SharePoint.

SQL Server Analysis Services improvements for Excel 2007 and Excel Services relate to performance and functionality.

Data compression (varDecimal) is an important feature for data warehousing scenarios, requiring less disk storage of decimal data and increasing overall performance.

Manageability enhancements, based on customer feedback, provide management capabilities for database administrators such as improvements in database maintenance plans, enhanced management reports and a new copy database wizard.

Management reports added to SQL Server Express Edition enable customers to get insights into the performance of their Express Edition and SQL Server Compact Edition databases.

Interoperability improvements including Oracle support in the Report Builder feature enable customers to use its functionality on top of Oracle data sources. Customers also have access to SQL Server Reporting Services to build reports on top of Hyperion’s Essbase cubes.

SP2 can be downloaded from Microsoft here


Microsoft SQL Server 2005 Books Online

Back to Top


Some good tips here

Back to Top