Mining in-memory data
This article explains how desktop applications can use SQL Server 2005 Data Mining to analyze in-memory data.
2006-10-03
2,504 reads
Additional Articles
SQL Server 2005 Integration Services - Lookup Transformation - Part 33
Continuing the overview of Data Flow components in SQL Server 2005 Integration Services, this installment focuses on the Lookup transformation.
2006-10-02
1,785 reads
Ownership chaining in SQL Server 2005
Ownership chains have unique permissions' issues in SQL Server 2005. Contributor Serdar Yegulalp explains the access levels of ownership chains, and the benefits of "EXECUTE AS."
2006-09-29
1,943 reads
File Watcher Task
The File Watcher Task does what it says really, it watches a folder waiting for files. When an available file is found the task completes, returning the name of the file for later use.
2006-09-28
2,425 reads
Upload multiple files to VarBinary column in SQL Server 2005
This article discusses how to upload multiple image or text files to the SQL Server database varbinary column.
2006-09-26
1,885 reads
Business Intelligence in SQL Server 2005, Part 1
This article takes a look at SQL Server 2005 Reporting Solutions as applied to Business Intelligence systems.
2006-09-20
2,868 reads
Demo of Visual Studio Team Edition for Database Professionals
In this video by the product's Program Manager, Sachin shows you a "whistle-stop" tour of the features of Visual Studio Team Edition for Database Professionals. This is the first part in a large series all on Microsoft's new development and administration platform for SQL Server.
2006-09-19
2,904 reads
SQL Server 2005 – DML Usage on an untyped XML column
Learn how to use Data Manipulation Language, a set of statements used to store, retrieve, modify, and erase data from a database, for untyped XML columns.
2006-09-18
1,895 reads
Using and Monitoring SQL 2005 Query Notification
The aim of this article is to show you how to make full use of SQL 2005 query notification with ASP.NET 2.0. It tackles the implementation details largely from SQL Server's perspective and includes many DBA tips and tricks for troubleshooting query notification.
2006-09-15
2,087 reads
Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Se
This article discusses: Extensibility in SQL Server 2005 Reporting Services, Creating and debugging custom report items, The ProgressTracker CRI sample.
2006-09-13
2,458 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers