Thursday, Sep 09, 2010
Login

Posts Tagged ‘SQL Server’

SQL Server 2005 Agent Schedule Not Updating

Ewwwh, this was a nasty little bug. Let me describe the title … I was having to update all our database data and schema to support the GMT/UTC baseline and then accounts and clients would register what timezone they are in and our system would reflect the dates and times from GMT/UTC to the registered [...]


SQL Server Linked Server to Oracle

As a database administrator by trade, I have had a very perplexing task to have my SQL Server 2005 Enterprise servers communicate with my Oracle 10g box and gather data in real-time in fast, efficient ways. This article will go over the steps to setup the the linked server and some of the gotchas so [...]