Additional Articles


Technical Article

SQL Server 2005 Integration Services - Package Execution - Part 24

Continuing our coverage of topics dealing with various aspects of managing SQL Server 2005 Integration Services packages, which we started with an overview of their storage and deployment, we now turn our focus to their execution.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2006-05-25

1,816 reads

Technical Article

Creating a Simple SQL Server 2005 Notification Application: Stock Quot

In this chapter, you'll see your first SQL-NS application: a stock notification service similar to those offered by many real-world stockbrokers. The application allows subscribers to enter subscriptions for stocks in which they are interested and notifies them when those stocks cross the price targets they specify.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2006-05-23

3,059 reads

Technical Article

Using XQuery to Manage XML with SQL Server 2005

XML is now becoming more widely used as wireless devices are becoming more secure, and new technologies such as XQuery for SQL Server 2005 are making it much easier to handle XML more efficiently at the server level. Jesse Smith gives you a crash course on XQuery methods and how you can use them in certain situations to retrieve and update XML data stored in your SQL Server 2005 database.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2006-05-18

3,096 reads

Technical Article

Review - Professional SQL Server 2005 Integration Services

Data Transformation Services morphed a bit in SQL Server 2000 but nothing compared to what SQL Server Integration Services is today. When I found out Professional SQL Server 2005 Integration Services was coming out, I decided to put it on my list of books to have.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2006-05-17

2,125 reads

Technical Article

Password cracking tools for SQL Server

If you're performing a penetration test or higher-level security audit of your SQL Server systems, there's one test you must not miss. It seems obvious, but many people overlook it: SQL Server password testing. Given the inherent weaknesses compared with more secure Windows authentication, you should especially test for password flaws if you're using SQL Server authentication in mixed mode. Password testing will help you determine how easily others can break into your database and help you ensure SQL Server users are being responsible with their accounts.

2006-05-16

4,339 reads

Blogs

DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods

By

Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...

T-SQL Tuesday #203: Risk and Reward

By

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By

You can find the slides and SQL scripts for my session “Spice up your...

Read the latest Blogs

Forums

Training the next generation

By Pat Wright

Comments posted to this topic are about the item Training the next generation

Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)

By Imran2629

Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...

PostgreSQL psql Meta Commands: Databases

By Grant Fritchey

Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases

Visit the forum

Question of the Day

PostgreSQL psql Meta Commands: Databases

Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?

See possible answers