Additional Articles


Technical Article

Lumigent Technologies Delivers Data Auditing Solution for Microsoft SQ

Lumigent Technologies today announced that they are a recommended supplier to provide data auditing solutions for risk management to customers of Microsoft SQL Server 2000 through their Entegra product. Enterprises that depend on SQL Server databases can now rely on Entegra as a trusted auditing solution to enable compliance with regulatory requirements.

2004-04-22

540 reads

SQLServerCentral Article

Beginning ADO.NET

One of the strengths of Visual Studio .NET is its features for rapid application development, or prototyping. If, for example, you want to develop a Windows form that lets you maintain the data in one table of a database, you can usually do that in 20 minutes or less. This article will show you how.

2004-04-01

303 reads

Technical Article

Microsoft Action Pack Subscription

One of the biggest hurdles people new to the IT field face is getting access to all the software they need so they can learn. This new program from Microsoft offers a TON of software for under $400. Caveats apply (don't they always?) but it's worth the 5 minutes to read what it takes.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-03-01

862 reads

Technical Article

Regular Expression Library

This isn't a SQL site nor can you easily do regular expressions from SQL. That said, sometimes regular expressions are EXACTLY what you need to solve a problem. The downside? They're tricky! This is a great resource to pass on to your development team.

2004-02-26

653 reads

Technical Article

What is the difference between SET and SELECT?

Both SET and SELECT can be used to assign values to variables. But when to or when not to use SET or SELECT? Or does it matter? This articles shows you how SET and SELECT are different in various scenarios, along with examples. You will also find a test script that you can run, to identify the performance differences between SET and SELECT

2004-02-25

344 reads

Technical Article

SQL Server Web Data Administrator

The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL Server data wherever you are. Using its built-in features, you can do the following from Internet Explorer or your favorite Web browser:

Create and edit databases in Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (MSDE)
Perform ad-hoc queries against databases and save them to your file system
Export and import database schema and data

2004-02-24

277 reads

Blogs

Lift and shift vs modernizing your data warehouse

By

If you are migrating a data warehouse, there is a question worth asking before...

Power BI Fun With Travels

By

I’m back from a great vacation. I had the chance to visit two new...

DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods

By

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

Read the latest Blogs

Forums

DML Trigger Types

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DML Trigger Types

PostgreSQL in action with Opensearch

By sabyda

Comments posted to this topic are about the item PostgreSQL in action with Opensearch

Choose the Second One

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Choose the Second One

Visit the forum

Question of the Day

DML Trigger Types

How many types of DML triggers are there?

See possible answers