First off I think Database Developers and Database Administrators are quite different positions, though most smaller companies tend to lump both into one position or group. In our group...

Seems like it could be multiple answers because "The DBA is connected to a SQL 2000 instance" is true as well... See below (and don't ask why I still have...

Renaming the physical server hosting your SQL Instance is definitely possible, here's how MS suggests doing it since you'll need to also update the metadata in SQL after the change:

Kevin,

First thing run this to verify there are no active transactions:

DBCC OPENTRAN

If this returns nothing run this to view the Virtual Log Files on the database:

DBCC LOGINFO

If the last log...

SQLTougherGuy (6/17/2014)

---

Not really sure what you are asking here bud. Please try to clean up your post as it's difficult to understand. Active/Active IMHO is always better than log shipping....

My primary computer at work is a laptop with 17" screen, so that and a second monitor (I think 19" - never measured it) is what I use. There's...

Sean Lange (5/29/2014)

---

SQLRNNR (5/29/2014)

---

NOT a fan...

Wow, I agree with literally 100% of what you guys have entered, including 'sprocs'. We have a few non-DBA's who use this verbiage, and it always makes me cringe. ...

I've pulled my SharePoint calendars into Outlook, but that's about it. I toyed around once with pulling calendar data out of the SharePoint database so I could convert it...

David O (3/24/2014)

---

Does anyone else every have day's when they feel like there the audit team's secretary (I could you another word but it is a family show)?

Run this...

Jeff,

I inherited an aging DB2 environment last year, and having zero experience with DB2 it's definitely been a crazy ride learning. The IBM mentality is very dissimilar from Microsoft's...

You may be able to force the query to return 0.00 by converting the value to numeric(9,2) (or whatever precision you need), but this probably needs to be set in...

I was half way into an email to my other DBA and our Dev's with a link to the article when I double-checked to see if this was an April...

I'm really curious to know why your making the switch... I work in a DB2/MS SQL mixed shop where we have DB2 LUW and on z/OS plus we have many...

Merge would probably work, but you'll need to run this for each historical day to get caught-up then each day after that. Here's an example given your dates are...