Administration

SQLServerCentral Article

Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses

  • Article

Andy returns to the Worst Practice series this week with a short article looking at how connection strings in applications affect what you see in sysprocesses. Perhaps less controversial (in our opinion) that some of the other worst practices, this is something easy to fix and definitely worth fixing! Read the article and post a comment - explore other points of view! Readers posting a comment will be entered in a drawing for a copy of the SQL Server 2000 Resource Kit.

You rated this post out of 5. Change rating

2003-08-01

15,766 reads

Blogs

SQL Training: Black Friday Deals Up to 75% Off

By

This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...

When is the perfect moment to build a data strategy in a company?

By

The post When is the perfect moment to build a data strategy in a...

How to Run Databases on Kubernetes: An 8-Step Guide

By

In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...

Read the latest Blogs

Forums

Simple Junction table design question

By eichnerm

I have a disagreement with the programming team on an app that I designed....

Sql query to check the status change for an item

By SQL Bee

I have a table dbo.tblPresentationStatus (sql script attached - table script.txt) I have to...

Migration of on-premises SQL Server to an AWS PostgreSQL database

By Abhishek

We are planning to migrate our on-premises SQL Server to an AWS PostgreSQL database...

Visit the forum

Question of the Day

Renaming a Database

If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)  

See possible answers