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.

Typed Data Objects

This is a tool to generate C# code based on a sql script. Source code is also available for download. It's free! One caveat is that the site is in Italian.

Optimizing Your Application - Part 2

This article is for developers (and is in C#), looks at how you can avoid requerying by storing data in a hashtable. Mainly code, but you may get a good idea or two from it.

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

SQL Injection - Part 1

Randy says that the biggest reason we have so many injection vulnerabilities is that all the asp books use inline sql for their examples! We STILL encounter developers who don't understand injection. Read and pass on to your dev team.

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

Worst Practice - Triggering External Events

Andy Warren started his worst practice series some time ago with the intention of looking at the worst things you can do. Given that we may not always be able to implement the best practices, at least we can try to avoid doing things harm the system or decrease performance. This article continues the series and looks at an item I see mentioned in our discussion forum quite often, triggering external events. From a trigger.

Embarcadero ER/Studio and DT/Studio Named Finalists for JOLT Product E

Press release about Embarcadero products being named finalists in the annual Jolt awards sponsored by Software Development magazine.

Help us Improve our Logo

Reader Rob Potter suggested that our logo could use some fine tuning and graciously submitted some ideas he had for doing just that. Come take a look and tell us what you think.

Take a Break with Pingu

It's not SQL Server related, but take a break and see how you do. The highest I've seen so far is 1602. If you beat it send a screen shot (small, please) to sjones@sqlservercentral.com