• Interests: Hi, my name is Norm Enger. I have worked in and around Microsoft SQL Server as well as web and other programming languages since 1997. I am by profession a Microsoft SQL Server database administrator (DBA), or as some of my friends and coworkers have called me over the years, ”the database guy” or ”the SQL guy.” I am employed by Mohawk Industries of Dalton, GA, working remotely to my office from Tucson, AZ. I have a wide range of interests, experiences, and expertise in all things SQL Server, all the way from SQL Server 7.0 to the newest editions of SQL Server, as well as with some third-party tools.

Technical Article

Script Tbl Data to Insert Stmts. - Handles Unicode

Script Table Data to Insert Statements - Handles Unicode datatypes (nchar, nvarchar, ntext). This script works with SQL 2000 and has been improved to handle properly the nchar, nvarchar, and ntext data types for Unicode, as well as handle apostrophes in data correctly. Usage is to run the script to create the stored proc in […]

(1)

You rated this post out of 5. Change rating

2006-01-24 (first published: )

602 reads

Technical Article

Verify all DBs are part of a Maintenance Plan

This is a script you can run on a per-server basis, from any database in Query Analyzer or incorporate into a stored procedure, that will examine all databases on that instance of SQL and show what Maintenance Plan(s) they are part of, if any. Shows clearly any databases that are not currently part of a […]

You rated this post out of 5. Change rating

2004-10-01

529 reads

Blogs

Who Are You Doing It For?

By

But as I've matured over the years, I came to realize that I needed...

Presenting Twice in May 2026

By

I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...

Finding the Next Sequence Value: #SQLNewBlogger

By

I saw a question asking about the next sequence value and decided to try...

Read the latest Blogs

Forums

A Fun Computer Quote

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Fun Computer Quote

AI Database Central

By Steve Jones - SSC Editor

Comments posted to this topic are about the item AI Database Central

The Grafana Alternative to SSRS and Power BI

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Grafana Alternative to SSRS...

Visit the forum

Question of the Day

A Fun Computer Quote

Which movie featured this quote?

"All programs have a desire to be useful."
Happy April Fools!

See possible answers