Viewing 15 posts - 1 through 15 (of 31 total)
i got that info from here years ago: https://cathydumas.com/2012/04/23/changing-an-analysis-services-instance-to-tabular-mode/
November 28, 2016 at 6:53 am
regarding the "is ETL dead?" question:
every time a new shiny dev toy comes out, the silo'd tunnel vision ADD kiddiez are always quick to scream "zomg everything else is obsolete...
November 21, 2013 at 2:26 pm
Cool - I hadn't considered source control for report builder content.
October 23, 2012 at 5:59 am
May 28, 2012 at 12:57 am
Is this process numerically stable?
May 14, 2012 at 8:57 am
SAinCA (5/8/2012)For anyone interested, I found http://regexpal.com/ very useful when building and testing RegEx's.
I've always used expresso http://www.ultrapico.com/Expresso.htm - makes code for a bunch of...
May 8, 2012 at 6:12 pm
I wasn't familiar with this before - thanks! In general, it sounds like a linked server server. 🙂
1) Did you really say you cannot use sql service accounts with CMS?
April 30, 2012 at 7:26 am
It'll go the route every other new shiny thing in tech goes, I would imagine:
1) There'll be a proliferation of home-rolled cobbled together codes to perform big data gathering, storage,...
April 16, 2012 at 5:23 am
jshahan (3/27/2012) You are better off coding in the SSMS text editor and pasting into your dataset or calling a stored procedure from it.
Oh. I didn't realize people did anything...
March 27, 2012 at 9:19 am
I use ssrs for reports that are consumed by web pages.
The bulk of my users use access (ugh) to create their own stuff. As a replacement, I'll be nudging...
March 27, 2012 at 7:41 am
When I require live data, I almost always join against OPENQUERY resultsets - much, much, MUCH faster than directly joining to the remote server.
Or else an SSIS job.
February 27, 2012 at 8:19 am
Oh welp there you go then! 🙂
Now back to figuring out how to get the right passwords in my deployed ssis package's connection managers. #@$@#%@
February 10, 2012 at 8:05 am
Friend of mine told me to order my joins so that the greatest expected number of rows are eliminated soonest. Unfortunately, I've never been clear on just how to do...
February 10, 2012 at 7:50 am
I can't recall the last time I used isnull. I always use coalesce specifically to avoid data type result issues.
February 1, 2012 at 11:00 pm
I like this thread because it furnishes a nice object lesson in why you don't go reinventing wheels.
November 21, 2011 at 9:09 pm