Additional Articles


Technical Article

New Product - Equivalent Script

At Last! No need to convert SQL Scripts from one dialect to another. Although SQL is a simple language, it can be tedious, inaccurate and frustrating when developing equivalent SQL scripts for multiple database servers. This product handles the conversion for you. (Not Reviewed)

2003-07-15

804 reads

Technical Article

SQL Bible

Here, in one definitive volume, is all the information you need to understand and use SQL and its implementations in accordance with the established SQL99 standard. Whether you want to learn database programming from scratch, you’d like to sharpen your SQL skills, or you need to know more about programming for a heterogeneous database environment, this book provides the complete menu. (Not Reviewed)

2003-07-11

948 reads

Technical Article

Microsoft SQL Server 2000 Weekend Crash Course

The big day is Monday. The day you get to show off what you know about SQL Server 2000. The problem is, you're not really up to speed. Maybe it's been a while since you worked with SQL Server. Or maybe you just like a challenge. Open the book Friday evening and by Sunday afternoon, after completing 30 fast, focused sessions, you'll be able to get right to work on a SQL Server 2000 databases.(Not Reviewed)

2003-07-04

793 reads

Technical Article

SQL Server DTS Best Practices

This article discusses various SQL Server Data Transformation Services (DTS) best practices. It is divided into sections like DTS naming conventions, DTS documentation, troubleshooting DTS packages, improving the performance of DTS packages, securing DTS packages, DTS resources.

2003-06-24

4,068 reads

Technical Article

Free BCP GUI

Pedro Estrada has published a free tool that according to his site "This is a complete application to have an easier interface to work with BCP against MSSQL servers. Just specify a server, database, table user name and password to BCP out or IN." Worth a try, and he has some other free utilities (some SQL, some not) on the site.

2003-06-19

1,922 reads

Technical Article

myLittleAdmin for MS SQL and MSDE released !

myLittleTools.net is pleased to announce the release of myLittleAdmin, the most advanced and robuste web-based MS SQL and MSDE database administration tool. This new version offers a new skinnable interface and a lot of great new features, such as user levels, multi-databases support or SQL script generation. A lite version is available for free so that you can test it in your own environment. Use myLittleAdmin and do through a browser almost everything you did before with Enterprise Manager.

2003-06-17

1,164 reads

Blogs

The Book of Redgate: Spread across the world

By

This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...

Merry Christmas

By

Today is Christmas and while I do not expect anybody to actual be reading...

Self-Hosting a Photo Server the Whole Family Can Use

By

Until recently, my family's 90,000+ photos have been hidden away in the depths of...

Read the latest Blogs

Forums

Happy Holidays, Let's Do Nerdy Stuff

By Grant Fritchey

Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...

UNISTR Escape

By Steve Jones - SSC Editor

Comments posted to this topic are about the item UNISTR Escape

Celebrating Tomorrow

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Celebrating Tomorrow

Visit the forum

Question of the Day

UNISTR Escape

In SQL Server 2025, I run this command:

SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation) A: B: C:

See possible answers