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...

This really gets down to personal preference to a large degree. Here's the question, will that two character abbreviation EVER change? If a country named the United States of Ted...

I agree. Do the backup locally and then ftp the file or whatever to the remote site. If you run backup across the internet, connection interruption, etc., could cause lots...

It only backups up the database if it's configured to and it doesn't take into account logs at all. If you want a full point in time recovery system, you...

From the sounds of things, you should be setting up a server side trace to capture the completed queries along with their performance metrics. That way you can see what...

CirquedeSQLeil (6/2/2010)

---

Sounds like a conversation I had recently.

Me: Why are we doing it that way?

other: Because it is being done this way.

Me: Why can't we do it...

Breaking my Thread-free streak...

At least his current icon is appropriate.

2-3 seconds...

Sure, Sharepoint writes it up to a varbinary data type and you can do the same. You just have to take into account that you need to stream that data...