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,976 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

Unlocking Real-Time Financial Insights: The Power of Microsoft Fabric

By

Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...

Understanding Lakehouse Permissions in Microsoft Fabric

By

Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access...

The Cost of Not Having a DBA

By

Does skipping a DBA save money? Wait until your system grinds to a halt,...

Read the latest Blogs

Forums

what etl tool are folks moving toward?

By stan

Hi as we replace on prem machines , sometimes not with vm's, what should...

Union where it matches against only one shared column

By ldanks

Hi folks I have two tables, both with a NAME, START and END fields...

How to update using data from three tables?

By mjdemaris

I am in the process of migrating from MySQL to SQL Server. I have...

Visit the forum

Question of the Day

Replacing a NULL II

What is returned from this code in SQL Server 2022?

DECLARE
  @value INT = NULL
, @value2 VARCHAR(20) = NULL;
SELECT COALESCE (@value, @value2, 100.5) AS Result;
GO

See possible answers