Viewing 15 posts - 1 through 15 (of 191 total)
Hey, our solution ended up being having a team of people who build reports take it on as a task on their side to pull numbers that they then feed...
December 13, 2016 at 6:12 am
SQL Search is such a huge time saver. Just yesterday I was wondering where we were referencing a linked server that we're going to migrate, then a job I...
July 27, 2016 at 6:00 am
Do you have experience creating Analysis Services connection string in SSIS to connect to Analysis Server in different domain? I'm working on figuring out a way...
December 2, 2015 at 11:43 am
I'm the data manager for the baseball league I participate in each summer. This past season we used iScore Sport's app on a couple of Samsung tablets instead of...
November 4, 2015 at 6:14 am
My work laptop is esstentially blank except for VPN stuff. All my tools are on a desktop at the office, but it could just as easily be installed on...
October 22, 2015 at 6:26 am
Great editorial, what an eloquent way of describing what we're doing. I've been noticing that more and more people need to work with the data we have here so...
July 23, 2015 at 6:44 am
Doesn't seem like I've run into the same issue you've had. I've had 2 instances open at the same time with different credentials and it's worked fine until I...
June 17, 2015 at 7:36 am
In this case the value is 51 characters. The label was actually a bit less. I'll admit, I was being a bit lazy when building this report and...
February 26, 2015 at 1:51 pm
Sure I have a large workload, but I'm only working 40 hours in a week or so. I manage expectations and do the best I can. The work...
January 30, 2015 at 6:33 am
Well said! Now if only I could convince my director that we need to be doing more of this "boring stuff" so I can get time to actually do...
December 6, 2014 at 9:04 am
The extra 7% for Oracle people is probably because they don't have a community like SQLServerCentral (and all the rest) to help them figure stuff out. If someone offered...
October 28, 2014 at 7:17 am
Yeah in my case at first I tried to tackle the fact table like I would a Type 2 SCD. Part of my problem was that the data was...
October 21, 2014 at 4:47 pm
I've added effective dates to one of the fact tables in my data warehouse to allow reporting using different points in time. The application that generates the data for...
October 20, 2014 at 6:26 am
Ian Massi (10/10/2014)
October 10, 2014 at 6:34 am
I'm doing some analysis right now looking at our fleet and examining the data from our tracking devices to see if I can correlate it to motor vehicle accidents. ...
October 10, 2014 at 6:24 am