• 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 (1)

You rated this post out of 5. Change rating

2006-01-24 (first published: )

578 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

504 reads

Blogs

Know Thy Platform

By

IT and data professionals, I implore you – know thy platform. All of it....

Adding Git LFS Support – #SQLNewBlogger

By

I got this message recently while committing some changes: This post shows my work...

EightKB 2024

By

EightKB is back! The biggest online SQL Server internals conference is back in 2024…it’s...

Read the latest Blogs

Forums

How to suppress the info of queries execution in Stored Procedure.

By rkordonsky 63916

I inherited the Stored procedure the whole purpose of it is to populate our...

ssis catalog not showing all executions

By stan

Hi we just migrated to 2019.  Unlike our previous server on which every ssis...

Is there a such thing as connections being made too fast in a package?

By stricknyn

Hi all, SSIS doing some quirky things and I wanted to run a scenario...

Visit the forum

Question of the Day

A New Audit

I have a brand new D: drive on my system that is formatted, but contains no files or folders. What happens when I execute this code?

CREATE SERVER AUDIT audit2 TO FILE ( FILEPATH ='D:\audit' );
GO

See possible answers