A T-SQL Regular Expression Library for SQL Server 2005
This article shows the reader how to construct a library of scalar and table valued functions for SQL Server 2005 to perform regular expression analysis.
ADO.NET Entity Framework Overview
ADO.NET in the next release of Visual Studio® code-named "Orcas" features the new Entity Framework.
Searching Words and Phrases in a Rich Text Field
Searching for data in a database is something we all do constantly, but few of us use the Full-Text Search features of SQL Server. Yousef Ekhtiari brings us a look at how you can get around some of the limitations of this feature and possibly use it in your application.
Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4
Part 3 of this series discussed how to script PowerShell and connect to SQL Server. This installment illustrates how to use a PowerShell script to loop through the content of a file and connect to different servers.
SQL Server 2005 Express Edition - Part 2
Express Edition remains the primary choice for deployments of a full-fledged database engine in less demanding environments. Part two of this series explores its features in more detail in order to better understand its unique role in SQL Server 2005 portfolio.
A Love Hate Affair with User Defined Types
Many new DBAs think that User-defined types are a very cool feature in SQL Server when they first encounter them. However many experienced DBAs soon realize that UDTs can be a pain to work with and longtime SQL Server guru David Poole discusses his experiences
Centralized Asynchronous Auditing with Service Broker
Service Broker is a new feature in SQL Server 2005. It is an integrated part of the database engine and it provides queuing and reliable direct asynchronous messaging between SQL Server 2005 instances only. In the future this is planned to be extended to non-SQL Server instances. This article shows how to use Service Broker and triggers to capture data changes.
Using BCP to export the contents of MAX datatypes to a file
Phil Factor presents a poetic stored procedure for storing any VARCHAR(MAX) to file.
CLR: Reflections on Reflection
Do you wish callers of your library could describe their types to you programmatically? Read a little about reflection in CLR Programming.
Microsoft Indexing Service HOW-TO
This article describes how to provide full text search using Microsoft Indexing Service in .NET applications.
Blogs
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Streamlining Azure VM Moves Into Availability Zones
By John
One of the more frustrating aspects about creating an Azure virtual machine is that...
Monday Monitor Tips: Native Replication Monitoring
By Steve Jones
Redgate Monitor has been able to monitor replication for a long term, but it...
Forums
Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
The Challenge of AI
Comments posted to this topic are about the item The Challenge of AI, which...
Deprecated Feature Tracking
Comments posted to this topic are about the item Deprecated Feature Tracking
Question of the Day
Deprecated Feature Tracking
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers