Tag Archive for 'SQL Server'



Execute Oracle procedure from Sql Server


Warning: Use of undefined constant nw_noteworthyLink - assumed 'nw_noteworthyLink' (this will throw an Error in a future version of PHP) in /home/public/wordpress/wp-content/themes/black-minimalism-10/theloop.php on line 114

Warning: Use of undefined constant template_directory - assumed 'template_directory' (this will throw an Error in a future version of PHP) in /home/public/wordpress/wp-content/themes/black-minimalism-10/theloop.php on line 116

This took me a while to figure out, and there wasn’t good results from Google. So here’s the answer, for those who happen to find this.

EXEC('call Schema.ProcedureName()') at LINKED_ORACLE_SERVER

Make sure you’ve enabled RPC on your linked server too.

We regret this error


Warning: Use of undefined constant nw_noteworthyLink - assumed 'nw_noteworthyLink' (this will throw an Error in a future version of PHP) in /home/public/wordpress/wp-content/themes/black-minimalism-10/theloop.php on line 114

Warning: Use of undefined constant template_directory - assumed 'template_directory' (this will throw an Error in a future version of PHP) in /home/public/wordpress/wp-content/themes/black-minimalism-10/theloop.php on line 116

I made this SSIS package a while back, and thought it was awesome at the time…

Yeeeaah… Not so much.

cunfuzled

The DBA in the clouds


Warning: Use of undefined constant nw_noteworthyLink - assumed 'nw_noteworthyLink' (this will throw an Error in a future version of PHP) in /home/public/wordpress/wp-content/themes/black-minimalism-10/theloop.php on line 114

Warning: Use of undefined constant template_directory - assumed 'template_directory' (this will throw an Error in a future version of PHP) in /home/public/wordpress/wp-content/themes/black-minimalism-10/theloop.php on line 116

Recently in the IT blogosphere, there’s been a lot of talk about cloud computing, especially in connection with Microsoft’s new initiative Azure.  The announcement of SQL Server available in the cloud has caused some turmoil in my field of database administration. SQL Data Services will offset the responsibility of hosting, installing, configuring, and otherwise administrating the server as we are akin to. I have mostly avoided all the DBA rants regarding the prospect of loosing jobs to the SDS cloud, for the reason that is succinctly explained in the excerpt below.

Why do I think things will be fine? Because data is King. And those that know how to move data, and get data to the right people, in the right way, at the right time, will always have a job. So, maybe having your database servers in the cloud means we do not have to worry about backups, tape storage, etc. Fine, I don’t care about that piece of being a DBA anyway. But you are still going to need someone that understands the tools involved in making your systems and processes work efficiently and correctly.

The full article, found over at BaconBitsAndBytes.com, is a witty (and potentially NSFW/offensive) article by a smart DBA and I highly recommend following the advice.