Building Data Mining Solutions with OLE DB for DM and XML for Analysis
This article, published in the June 2005 issue of SIGMOD Record, provides an overview of SQL Server Data Mining from a standards perspective.
2006-05-24
2,097 reads
Additional Articles
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.
2006-05-23
3,059 reads
2006-05-22
2,852 reads
Using SQL Server 2005 to document Sarbanes-Oxley compliance
My CIO and I have looked at a number of commercial solutions for documenting Sarbanes-Oxley compliance. However, we decided to use SQL Server 2005's built-in tools to create our own "home-grown" auditing system.
2006-05-19
3,877 reads
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.
2006-05-18
3,096 reads
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.
2006-05-17
2,125 reads
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
Fast Text Processing in SQL Server
Processing text or long strings usually reduces SQL to a prosaic procedural language. Learn a few techniques for facilitating speedy text processing in SQL.
2006-05-10
5,032 reads
Scaling Out SQL Server 2005
This article explains the different technologies that are available for scaling out a SQL Server 2005 database application, focusing on the factors that go into deciding which solution(s) to use in your application.
2006-05-09
2,685 reads
Using XQuery, New Large DataTypes, and More
SQL Server 2005 introduces a lot of new features, but it also enhances the popular and oft-used Transact-SQL (T-SQL) language. Changes include the introduction of new datatypes to store large values using the MAX indicator, the integration of enhanced XML querying and data modification with XQuery, and the new XML datatype.
2006-05-08
2,508 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers