News

Technical Article

Upcoming SQL Server SP3 Beta Program

  • Article

It’s almost time for the newest Service Pack for SQL Server 2000, and you don’t want to be caught unprepared for this one. In addition to the normal QFE fixes, the top service pack requests from our PSS organization and the latest security fixes, this service pack will be shipping with MDAC version 2.7 SP1. You’re going to want to be involved in this service pack beta! This beta is scheduled to start in mid to late September.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2002-08-19

3,325 reads

Technical Article

SQLClean 2.0 Released

  • Article

SQLClean is a SQL Tool that automatically creates a dependancy analysis of your SQL Server Database including tables, views, triggers, defaults, procedures etc. SQLClean will also analyze a client application for depenandies on SQL Objects allowing you to detect and eliminate unused SQL objects that are unreferenced by either the client app. or database itself.

2002-07-26

3,537 reads

Technical Article

The Microsoft SQL Server™ Accelerator for BI Launched

  • Article

The Microsoft SQL Server™ Accelerator for Business Intelligence (SQL Server Accelerator for BI) makes it easy to build a customizable business intelligence solution from your operational data, enabling your organization to realize the power of business analytics.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2002-06-19

4,470 reads

SQLServerCentral Article

2002 SQL Server Best of Breed Product Nominations

  • Article

Welcome to the first SQLServerCentral.com SQL Server Best of Breed Product Awards. These awards allow you to reward the products that you feel are the best in the SQL Server industry. These awards are user nominated and users vote for the winners.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2002-06-10

28 reads

Technical Article

Auto-Audit 2.0 Release Announcement

  • Article

LockwoodTech announces release of Auto-Audit 2.0, an entirely redesigned upgrade to it's popular SQL Auditing tool. Version 2.0 supports plug-in, customized audit architectures, scriptable trigger templates, a trigger and data management module, real data reports, and online analysis of audit data with grouping analysis.

2002-06-04

3,524 reads

Blogs

Goodbye, Microsoft

By

A few years ago I took a new job at Microsoft, working as a...

The SUM of Nothing: #SQLNewBlogger

By

I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...

How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections

By

I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...

Read the latest Blogs

Forums

Building a SQL Server Fleet Audit That Leadership Actually Reads

By Mayank Sethi

Comments posted to this topic are about the item Building a SQL Server Fleet...

Smart AI Agents and Data Security

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Smart AI Agents and Data...

RegEx Functions IV

By Steve Jones - SSC Editor

Comments posted to this topic are about the item RegEx Functions IV

Visit the forum

Question of the Day

RegEx Functions IV

I have this data in a table in a SQL Server 2025 database:

EmailAddressID EmailAddress
7              dylan0@ADVENTURE-WORKS.COM
8              Diane1@ADVENTURE-WORKS.COM
If I run this query, which row(s) are returned?
SELECT top 10
 *
 FROM person.EmailAddress
 WHERE REGEXP_LIKE(EmailAddress, '^D', 'i')
 AND BusinessEntityID IN (7,8)

See possible answers