Ponderings about the Tech Ed 2007 Keynote
Rating: none
Bradley Jones - 06/12/2007
The people at Microsoft are busy with lots of products. Did someone forget that they should be excited about them?

Temporary Tables vs. Table Variables and Their Effect on SQL Server Performance
Rating: none
Dmitry Tsuranoff - 05/31/2007
Follow an experiment and draw interesting conclusions on where and when to use temporary tables or table variables.

Report Solution Patterns and Recipes: Creating Sparklines
Rating:
Paul Turley - 05/15/2007
In the last of this three-part SQL Server Reporting Services recipe series, Wrox author Paul Turley shows how to create the graphics for word-size graphics that visualization pioneer Edward Tufte dubbed sparklines.

Forging Transact SQL Code with CodeSmith
Rating: none
Jeffrey Juday - 02/28/2007
If you're haven't used CodeSmith for your TSQL coding yet, now's the time. This template-based code generator enables you to add fire-and-forget programming to your TSQL development.

SQL Server 2005 Compact Edition: The Little Engine That Can
Rating:
Josh Fitzgerald - 01/16/2007
Microsoft SQL Server 2005 Compact Edition provides relational database functionality for mobile and desktop applications through a lightweight and easily distributable engine. Take a look under the hood.

Tip: SQL Express Configuration Issue
Rating: none
Sushankar layak - 12/14/2006
Learn how to conquer a SQL Express 2005 remote connection issue.

News: Don't Embed That Database!
Rating:
Bradley Jones - 11/09/2006
Did you replace MSDE with SQL Server 2005 Express Edition? Did you make the wrong move?

Getting Started with SQL Server Service Broker
Rating: none
Mike Gunderloy - 10/31/2006
Learn how the Service Broker provides the "plumbing" to let you pass messages between applications, using SQL Server as the transport mechanism.

Designing a SQL Service Broker Control Bus
Rating: none
Jeffrey Juday - 10/02/2006
SQL Server Management Studio just doesn't cut it for complicated configuration and monitoring implementations. Learn how to implement your own SQL Service Broker (SSB) control bus solution to serve the needs of complex SQL Server-based messaging solutions.

SQL Server 2005 Service Broker Plays Well with Older Relatives
Rating: none
Jeffrey Juday - 09/08/2006
You can leverage SQL 2005 Server Service Broker with existing technologies such as SQL Server 2000 and MSMQ. BizTalk and SSB external activation are viable options, but a simple polling solution is easier.

Using SQL Server to Implement the Publish-Subscribe Integration Pattern
Rating: none
Jeffrey Juday - 07/31/2006
Utilizing design patterns with SQL Server 2005 Service Broker enables you to assess and select appropriate solutions for all of your SQL Server 2005 asynchronous messaging needs.

Incorporate Data Warehouse QA Checks into MOM 2005
Rating: none
Jeffrey Juday - 06/12/2006
Microsoft Operations Manager 2005 (MOM) is a very capable monitoring tool, but it's limited when it comes to quality assurance. Learn how to use WMI and MOM's rules and notification capabilities to run automated data warehouse QA checks.

Database Visualization
Rating: none
VGirish - 06/07/2006
When handling a project with hundreds of tables, it takes some time to understand the flows. Learn how to create a simple tool for Visualizing database tables and relations.

SQL Server 2005 Programmability Enhancements — Common Table Expressions
Rating: none
Scott Klein - 05/16/2006
There is a plethora of new T-SQL features and enhancements in SQL Server 2005. Learn about one of them — specifically, Common Table Expressions (CTE), because they often come in handy.

User-Defined Functions: Powerful Alternatives to Views and Stored Procedures
Rating:
Jeffrey Juday - 04/14/2006
Table-valued user-defined functions (UDFs) are functionally similar to views but structurally similar to stored procedures, giving them all the important features of views and stored procedures and some additional functionality that they lack.

Storing Session State in a SQL Server Database
Rating:
Bipin Joshi - 04/05/2006
In ASP.NET 2.0, you can customize the session state store as per your requirement. Explore one of the scalable and reliable approaches for storing session variables—SQL Server.

Put Some "BAM" in Your Next BizTalk 2004 Project
Rating: none
Jeffrey Juday - 02/24/2006
Need to gather some metrics on the steps within your BizTalk 2004 Orchestration? Check out Business Activity Monitoring (BAM).

Using the SQL Server 2005 Integration Services Class Library
Rating:
Jeffrey Juday - 12/02/2005
Learn how to extend SQL Server 2005 Integration Services (SSIS), the new ETL tool that ships with SQL Server 2005, to perform operations that aren't already bundled with the product.

Solving the Mysteries of SQLCLR and System.Transactions
Rating: none
Sahil Malik - 10/17/2005
When you write to an underlying table via a CLR database object, a number of questions come up. Get the answers—along with a breakdown of how System.Transactions, a new .NET namespace, can help.

Writing Database Objects in CLR: Advanced Scenarios
Rating: none
Sahil Malik - 09/21/2005
When you write code to be run inside SQL Server 2005, you usually want to deal with other database objects. Learn how to write a CLR-stored procedure that uses a simple table valued function to handle that scenario in a couple of ways.

Writing Database Objects in CLR
Rating:
Sahil Malik - 09/14/2005
You can use CRL to author a number of database objects. Follow a canonical example that explains the main steps involved in using and creating a CLR object inside SQL Server 2005.

An Intro to CLR Integration in SQL Server 2005
Rating:
Sahil Malik - 08/19/2005
Learn all you need to know about the CLR integration available in SQL Server 2005. Get a high-level introduction, followed by a discussion of the implications of writing database objects in CLR code and a comparison with existing alternatives such as T-SQL or extended stored procedures.

Introduction to SQL Server Report Builder
Rating: none
Mike Gunderloy - 07/15/2005
SQL Server 2005 is the first version to include end user reporting capabilities. See how the new Report Builder makes it easy for analysts to generate reports while avoiding the performance pitfalls of completely ad hoc reporting.

Understanding Hibernate ORM for Java/J2EE
Rating:
Saritha S.V - 07/12/2005
Hibernate is the most popular and most complete open source object/relational mapping solution for Java environments. Learn Hibernate by using a simple Java application.

Explore SQL Server 2000 DTS Packages Using .NET and the DTS Class Library
Rating: none
Jeffrey Juday - 05/03/2005
Before embarking a major database change such as upgrading to SQL Server 2005, how do you assess the scope of the change on your DTS packages? Use the DTS class library and .NET Interop.

SQL Server Integration Services: SQL Server 2005's New ETL Platform
Rating: none
Thiru Thangarathinam - 04/14/2005
Learn how to create and execute packages using SQL Server 2005's new ETL platform SQL Server Integration Services and its integrated development environment, Business Intelligent Development Studio.

Managing the "Surface Area" of SQL Server 2005
Rating: none
Mike Gunderloy - 04/12/2005
Learn about the new security feature Microsoft is focusing on with SQL Server 2005.

What's New in ADO.NET 2.0 for SQL Developers
Rating: none
Dino Esposito - 04/04/2005
ADO.NET 2.0 introduces enhancements to the .NET provider model and SQL Server managed provider, which go a long way towards getting better support for specific database features within the boundaries of a common object model.

Implement User-Defined Functions in SQL Server 2005 with Managed Code
Rating:
Thiru Thangarathinam - 08/26/2004
SQL Server 2005's integration with the .NET common language runtime enables developers to create database objects such as user-defined functions using languages such as VB.NET and C#.

New HTTP Endpoints Create SQL Server 2005 Web Services
Rating: none
Peter DeBetta - 08/05/2004
SQL Server 2005 supports native HTTP SOAP via a feature known as HTTP Endpoints. Find out how this new feature makes the creation of Web services a snap.

Accessing The Registry From SQL Server
Rating:
dinesh123 - 07/02/2004
Learn how to find the country list from a computer's registry. You see how to read and write to the directory from SQLServer.

Generate Complex Next Numbers with SQL Server
Rating:
dinesh123 - 07/01/2004
Generating 'next numbers' numbers in SQLServer should not be a problem. But problema arise when a customer asks for different types of next numbers that you cannot generate directly from SQL Server. Learn how to tackle this problem in different scenarios.

Cursors
Rating:
Ali Sufyan - 05/14/2004
An explanatory article on cursors in SQL Server.

Sample Chapter: Efficient PL/SQL
02/05/2004
When used intelligently, PL/SQL can build applications that perform well, are resilient to change over time, and scale to large user populations.

User Management in Software Systems Using a SQL Server Database
Rating: none
Dinesh Asanka - 12/19/2003
How to manage user privileges in a SQL Server database system.

SQLServer Search Dialog Class
Rating: none
Marcos Lima - 02/11/2001
You simply add your search fields to a dialog resource and this class does the rest to give your users a great SQL Server search dialog!

Enumerate, Detach and Copy SQL Server Databases
Rating:
Mark McGinty - 12/20/1999
Very advanced functions for use with SQL Server databases

Stored Procedures

Hierarchical TableAdapters 301
Rating: none
William R. Vaughn - 08/08/2007
Are you having problems setting up a TableAdapter that can be fed from stored procedures instead of base tables? Here is a road map to guide you to success.

[Updated] Extracting/Copying Users and Permissions Between Databases
Rating:
Mark McGinty - 08/17/2006
Learn about a pair of stored procedures that can dump all users, role memberships, and permissions in a database, or copy them from one database to another.

WinFS Basics: Working with a Data Store
Rating: none
Sahil Malik - 01/30/2006
Introducing the next step in information storage on the Windows platform: WinFS, an active storage platform. Learn the basic operations that you can perform on a WinFS data store.

The Anatomy of a CE Database Record
Rating: none
Nancy Nicolaisen - 12/17/2004
Discover how to interpret retrieved records from a remote database and format them for display.

Using Stored Procedures with ATL
Rating: none
Chris Davis - 07/25/1999
Using Stored Procedures with ATL

A class to call stored procedures that do not return records
Rating: none
Jorge Lodos - 03/01/1999
A class to call stored procedures that do not return records

Calling Stored Procedures
Rating: none
Craig Lucas - 03/01/1999
Calling Stored Procedures

Using stored procedures with ADO
Rating: none
Chakrapani Ramachandran - 03/01/1999
Using stored procedures with ADO

XML

---

A Kick-Start to SAX with C++, Part 1
Rating:
Marius Bancila - 03/10/2006
Learn how to process XML documents' content with the Microsoft COM implementation of Simple API for XML (SAX).

Using DDL Triggers to Manage SQL Server 2005
Rating: none
Jeffrey Juday - 09/28/2005
Get an introduction to the extended SQL Server 2005 trigger functionality that Data Definition Language (DDL) triggers provide for both databases and servers.

The Fundamentals of the SQL Server 2005 XML Datatype
Rating:
Jeffrey Juday - 08/31/2005
SQL Server 2000 developers and DBAs who've been yearning for better XML support in SQL Server will be pleased with the new XML datatype in SQL Server 2005. If you're one of them, learn the fundamentals of the datatype so you can get going.

Loading Blowfish-Encrypted Data Into an MSXML2 DOM Object
Rating:
Tom Archer - MSFT - 06/15/2005
Learn how to use helper functions that (by utilizing a popular Blowfish class) open and decrypt an XML file in memory and then load that memory—without writing it to disk—into a DOM object.

[Updated] XmlSS.NET Spreadsheet Component
Rating: none
gianca - 10/15/2004
Learn new ways to work with Excel spreadsheets through the use of XML.

.NET and XML: Part 1—XPath Queries
Rating:
Klaus Salchner - 07/19/2004
This is the first of a series of articles that evaluates how well .NET supports XML and its surrounding standards. This article provides a good overview of the power of XPath queries.

Enterprise Application Integration (EAI) Using XML
Rating:
Syed Hameed - 03/26/2004
Best Practices and Standards in EAI must be practiced for reducing costs and increasing the effeciency for any EAI application.

Creating XML files from C++ programs
Rating: none
Petko Popov - 09/28/2001
Sometimes it is necessary to create XML files from a program in C++...