• 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: )

598 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

523 reads

Blogs

PASS Keynote Shots

By

Rodney Kidd took some great shots of the keynote and published an album here:...

Microsoft AI Red Teaming Course

By

here is the compiled video of the Red Teaming course Microsoft put together.

What’s New at AWS re:Invent 2025 – Day2 Highlights

By

Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote...

Read the latest Blogs

Forums

Fabric Mirroring

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Fabric Mirroring

T-SQL in SQL Server 2025: The UNISTR Function

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

How Important Are Real Time Decisions?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Important Are Real Time...

Visit the forum

Question of the Day

Fabric Mirroring

In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?

See possible answers