The reason I used to do this in the past usually broke down into two scenarios. Scenairo #1, way too many columns to make up a single table, so I'd...

2500 stored procedures is a little difficult to maintain. 40 is nothing.

No, I wouldn't recommend jamming all the code into a single procedure. In fact, I'd recommend, as much as...

It depends too much on what you want to do with the data. If you're just storing it as is, no modifications, will that satisfy these future reports? Or do...

At the point of a delete or insert, you do have access to the deleted & inserted temporary tables that will allow you to see what was deleted or inserted,...

I work for a fairly large insurance company and we have SA's responsible for the OS and the Servers and the disks and all things configuration oriented. It works out....

An excellent question, and comparing it to writing a book is pretty apt. I suspect, more than anything, it's a personality trait that drives a person to do that kind...

Steve Jones - Editor (6/5/2010)

---

In a source control session at SQL Saturday #22. Surprising that quite a few people don't use an VSC for their SQL Code.

What do you guys...

dbowlin (6/3/2010)

---

I am working through the information from Blythe. We...

Oops!

Yeah, Confio. Sorry about that. There's been lots of Cognos discussions around here recently and I clearly...

Steve Jones - Editor (6/3/2010)

---

It's always a balance, right? Sometimes the old ways work well and changing for the sake of change isn't worth it. Sometimes you need to move...

I've got no problem piling on in this situation. The principal problem with the inplace upgrade is that if you hose the system, you have to rebuild. That means your...

I would still recommend using Red Gate SQL Compare. You can call the Pro version from a command line, passing parameters, and hit every single instance through a PowerShell script...

Do you mean you want to know how to do backups?

Here's an old article I wrote[/url] that can get you started.

Do a search. There are probably hundreds of them. Here are a list of companies & products:

Microsoft System Center Operations Manager

Cognos Ignite

Red-Gate SQL Alert

Idera Diagnostic Manager

Quest Fogloght

SQL Sentry

There are lots...

I'm with the previous poster. If you've upgraded the server itself, then no, you can't reconnect to the 2000 instance because it's not a 2000 instance any more. If you've...