Helaas...deze pagina is niet beschikbaar in het Nederlands. Klik hier om terug te gaan of lees verder in het Engels.

Resources

This section of the site is devoted to providing useful tips, scripts, instructions, examples and links to handy external sites.

Article: Transaction and Error Handling Basics in SQL Server

Getting transaction handling right is one of the most important things you need to learn when writing scripts or developing code for SQL Server, but it's an area where experienced SQL coders still get caught out. This article (PDF, 252KB) explains the basics of error trapping, error handling, transaction handling and what's happening behind the scenes as your code executes...or not, as the case may be.

Added 28.05.09

Article: Converting non-Latin characters for a SQL 2005 Unicode database

International database applications need to be able to work with, display and support more than just the 26 letters of the Latin alphabet. SQL Server makes it easy to set up a new database with full support for practically every known language and character system, but how do you go about converting text entered in different languages and from mixed code pages in an existing database to a new Unicode-compliant database?

Read about a practical example of how 360Data went about converting a SQL 2000 database with mixed Western European and Polish text to a new SQL 2005 Unicode database.

Added 15.02.09

Article: Real World Foreach Loop Container example

The Foreach Loop Container control makes it possible to loop and repeat sections of control flow in an SSIS package, but the real beauty of the control lies in the huge variety of different enumeration types you can use when defining loops. A couple of examples used in a production scenario are described in the article .

This article was first published on SQLServerCentral.com in February 2008.

Added 07.07.08

Article: Sending scheduled SQL query results via HTML e-mail using SQL Server Integration Services

Our newest submission to SQLServerCentral.com has already received several extremely positive comments. The article gives a step-by-step guide to creating an Integration Services package that automatically takes the result set of a SQL query, reformats it as HTML and sends the data as an e-mail to interested parties.

(Links to an external site. Free, but one-time registration is required to read articles on SQLServerCentral.com).

Added 23.04.08

Article: Consuming a SQL 2005 Native Web Service from an ASP.NET application

SQL Server 2005 allows you to publish data via web services without using a separate web server or installing IIS on your database server. This article is the second in a series documenting SQL 2005 Native Web Services and explains how to call a Windows-authenticated SQL Native Web Service from a simple ASP.NET application, and how to create and call a parameterized SQL web service.

Added 05.03.08

Article: Providing SQL data as a web service using SQL Server 2005 Native Web Services

SQL Server 2005 allows you to publish data via web services without using a separate web server. This article is the first in a series explaining how to get started with SQL Native Web Services.

Added 15.02.08

Article: Real World XML processing in SQL Server 2005

XML data capabilities are tightly integrated in SQL Server 2005. This article explains how to parse typed XML data in SQL 2005.

Added 23.01.08

Article: Troubleshooting Connecting to a Remote SQL Server in SQL Management Studio

This article explains the steps to take if a SQL server won't respond in the SQL Management Studio.

Added 16.01.08