Memories....

Registered last night for the new season, getting excited though no practices yet, and I'll miss opening day with a long trip to the UK.

BTW, anyone think Pujols for Howard...

Yep, #7, many moons ago.

You hope management has thought things through, but often I've found they haven't. It's only the people that have been through things that tend to have plans in place, or...

Congrats, Lynn! Well earned and thanks for the support.

Meaning that we're not discriminating?

Actually we're not. We try to get a wide variety of opinions and styles. Happy to get some people writing from the Standard after a few...

baseball.

Registered for the new team and got a picture in the mail from Mom

Short summary of how I used to do this

- Create small db on every instance to hold data.

- write scripts to gather metrics, separate table for each metric. Use a...

I'm with Alvin. Wary of overloads on dates. Especially with potential calendar issues across time zones. I prefer using the functions that explicitly call for the operation

If someone is not doing the backups manually, there is a job to do them. If it's from a maintenance plan, it should have a name for a job that...

So I'm confused. Where is the data stored and where is it being moved to? Where does the conversion need to take place?

Just a quick check, as you are checking on issues, are you sure you are checking tempdb? Typically tempdb isn't being backed up, and operates in Simple mode. Is that...

Happy Birthday, Grant, from SQLServerCentral!

Use this:

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

That's a basic, standard one for .NET connections with a user/pwd. If you can use trusted connection, that's great, but this should work. The DSN...

Let us know if it helps. I'm sure Grant would love feedback, especially as he prepares to update it for the next version of SQL Server.

the MERGE command suggested by GSquared works well.

However slowness depends on how you do things. If you have a way to just pull across the changes from your source system,...