Viewing 15 posts - 1 through 15 (of 70 total)
You can do something like this too....
DECLARE @p_cmd varchar(255)
SET @p_cmd = 'cd "C:\Program Files\edb\mtk\bin" && runMTK.bat -dataOnly -tables table_changes -sourcedbtype sqlserver -targetdbtype postgresql -targetSchema public dbo'
EXEC xp_cmdshell...
December 14, 2021 at 10:01 pm
The MSSQL certification exams spend a huge amount of time explaining NUMA nodes, but they don't mention THIS! Thank you for pointing this out.
March 14, 2019 at 7:37 am
I got this error when installing.
This functionality requires .NET Framework 3.5 SP1. Please install .NET Framework 3.5 SP1 to use this functionality..
Error number: 6510 Severity: 16
I actually only do v4.0...
October 25, 2016 at 6:45 am
Did you figure this out? I have the same problem. Thanks.
September 20, 2016 at 10:36 am
john.saldanha (10/27/2013)
November 25, 2015 at 6:29 am
This could come in very handy. XML is a dying format and I deal with lots of json data. It's good to see movement in this direction. ...
August 31, 2015 at 2:11 am
Yes, I know. I actually edited the article to say the same thing but it needs to be republished. You can can get rid of step 3 by...
August 28, 2015 at 10:38 am
I haven't but this is a cool browser plug-in that you might be able to use: https://www.kimonolabs.com
It wouldn't be saving the html file but in theory you...
August 28, 2015 at 6:29 am
The very first comment I received after posting this article was from Jeff Moden ("RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row") saying basically, "Why don't you just...
August 27, 2015 at 7:03 am
So basically you need to buy the SF ODBC driver to do this, right?
August 18, 2015 at 4:04 am
I enabled Change Data Capture recently and I *WANT* to apply each update in the CDC tables to "ETL" tables that mirror the original, but I ran into this issue...
April 6, 2015 at 8:51 am
There are many ways to solve a problem.
Exactly. No one mentioned UDFs but that is a possibility too. Not a very good one though given some of the...
July 10, 2013 at 3:23 pm
Oh no, we're toast! I've got this. *Keyboard clatter* Woah, how'd you do that? I'm a DBA...Booyah
That's great...
July 9, 2013 at 8:01 am
Small thing, but I like the first graphic. The title is not cryptic, but you don't know exactly what will follow. 2 seconds after looking at the image,...
July 9, 2013 at 2:57 am
How is it possible that you are a newbie to SSC dpepper?! The truth is that I wrote the article, knowing it was rather simplistic, because I couldn't find...
June 21, 2013 at 9:13 am
Viewing 15 posts - 1 through 15 (of 70 total)