Jeremy Brown

  • Interests: Flying, playing drums, playing the baritone horn, reading, and SQL Server!

Technical Article

Add Enterprise Manager registrations quickly

Use this Perl script to add Enterprise Manager registrations from a text file. The text file should contain three fields seperated by spaces. The first two fields are the server groups you want to create, and the last is the server name. ex...Production Accounting ACTPRSQL01QA Accounting ACTQASQL01The script also goes out and registers all SQL […]

You rated this post out of 5. Change rating

2007-06-19 (first published: )

288 reads

SQLServerCentral Article

DBGhost Review

The integration of SQL Server 2000 with version control is basically nonexistent. Managing and keeping track of your changes and files is a cumbersome task, and prone to have mistakes occur. There is a product that can help you with this called dbGhost and Jeremy Brown takes a look at this product and how it works.

5 (1)

You rated this post out of 5. Change rating

2005-11-29

6,984 reads

SQLServerCentral Article

Flexible DTS Packages with Perl

SQL Server 2000 DTS was a revolutionary programming environment, but one that was not without a few quirks. As often found with many Microsoft products, there were sections in your packages where things were hard coded, making them less flexible. New author Jeremy Brown brings us a look at how you can build extremely flexible packages using Perl.

You rated this post out of 5. Change rating

2005-04-05

11,040 reads

Blogs

KDA: Echoes of Deception - Onboarding

By

I’ll walk through the KDA UI and tackle the first challenge before diving into...

Kusto Detective Agency - Intro

By

While I mostly write about SQL Server, I have a soft spot for Kusto....

The Book of Redgate: Customer Quotes

By

Many organizations list customer testimonials and quotes on their websites or literature. It makes...

Read the latest Blogs

Forums

How to take a backup as a .bak file while omitting some tables?

By Saran_

Hi Guys, I'm not sure if this is possible or not, but let me...

Life Moves Pretty Fast

By Grant Fritchey

Comments posted to this topic are about the item Life Moves Pretty Fast

Parse XML data from SQL table using temp tables and variables

By Lord Slaagh

Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...

Visit the forum

Question of the Day

Multiple Collations

Can I have a collation expression like this in SQL Server 2022?

...
WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS
...

See possible answers