The Heap™ – Consultancy ©®

2:12 PM

0

Q: Integrating Postgres/GIS data in a MSSQL environment without generating 'data islands'

Good day, Currently I'm facing an scenario in which a GIS expert is planning on starting to integrate mapping services for several departments within the organization I work for. I handle around 40 mid-sized MSSQL databases and so far its been a very painful process to try and unify the data so...

interesting problem, has anyone already seen such?

From the PostgreSQL side, there is AFAIK no mature solution

billinkc

2:39 PM

I so love science

I wish SO would recognize legitimate shitty questions and just shut them down

-1

Q: SSIS - how to access ADP payroll system

how do i access the ADP payroll system using SSIS Is there any ODBC available? can someone provide any steps we can use? thanks

ssis

dezso

@billinkc interesting, my first reaction while reading 'if it's a boy or a girl' was 'but the left-hand-side is a girl and the other one is a boy, most probably'

bonus question: do I have a degree in biology?

Kris Gruttemeyer

@billinkc The first question here is why does he need to access them. we use 2008 R2 for ADP here. They don't like people touching their stuff and it can void the service agreement if you do. Not as bad a MS Dynamics, though

billinkc

For the company I'm working for, it's entirely a SaaS so I assume as an admin you can get prepackaged reports and that's it. Didn't realize they had an on-premises verison

bluefeet

@billinkc or just ask me and I can handle it

billinkc

But I like to bitch

because I am one

beat y'all to that one

Kris Gruttemeyer

2:48 PM

@billinkc Yeah, ours is in house. Used to track clock ins/outs for Drs

Which then ties into insurance verification so its very critical to keep it up. The only thing I'm allowed to do is manage the backup/maintenance of it. No indexing, nothing.

Kris Gruttemeyer

3:05 PM

I love getting put on the 'on call roatation'. I'm the only DBA, im 'on call' 24/7/365. Now I jsut have to carry yet another phone.

billinkc

what's the other pager for? In case IIS goes down?

Kris Gruttemeyer

We share the rotation with .NET/AS400 team. I'm on call all the time, just now im the first responder.

We need to have each system have their own rotation, ideally

Less people that get woken up at 2am

billinkc

Or stabilize stuff so it doesn't go off

Which doesn't happen until management allocates time to solve such problems

My first post college job involved a pager. They sure knew how to bend an eager young grad over. So, since then I have been vehemently anti-pager

So many places that didn't have official support come up with the idea of devs carrying support pagers but when I start asking the painful questions I learned about, they usually backed off

Kris Gruttemeyer

@billinkc Yeah, it's tough. Many problems need management approval to resolve and that can be difficult getting their approval

billinkc

Now you have us essentially working 24x7 instead of our standard 5x8 - have you given any thought to remuneration? If the pager does go off, what's the expectation? There is no SLA in place. If I'm up all night, do you expect me to come in the next day? etc.

Kris Gruttemeyer

3:19 PM

@billinkc Yeah, that's a good point. Thankfully, my boss is VERY cool about that so if I'm up til 2am (like the past 3 nights), she makes sure to pay it forward a bit and let me come in late the next day or leave early. I know i'm incredibly lucky to have that

billinkc

Or at least track it and bank it. The Financial services institute, I got a call on Christmas Eve while I was at a family function because the website was "slow"

"Really? People are buying mutual funds to tuck them under the tree? How do you know it's slow." Uhh, they (a person in marketing) just said it was.

Kris Gruttemeyer

@billinkc 'its slow', very descriptive. I ask 'how slow' and the response is usually 'i dont know, it's jsut slower'.

Go to their PC and there's crapware everywhere and 5 instances of chrome open

swasheck

@AaronBertrand the confusion is that stats_column_id matches table order, not stats order for stats that support an index. in "theory" the stats_column_id should match hash_order of index_columns (if i understand BOL correctly)

@JamesLupolt AHHHH!!! MOTHERLAND!

@ypercube do you have access to a sql server 2014 instance?

ypercube

@swasheck Yes, but not at the moment.

swasheck

@AaronBertrand i met him in ABQ. he was a dick

ypercube

3:27 PM

Only in my laptop and it's at home.

swasheck

@ypercube hm. ok. send this to your home laptop

select
	schema_name = sh.name,
	table_name = t.name,
	stats_name = s.name,
	c.name,
	s.stats_id,
	s.auto_created,
	s.has_filter,
	s.filter_definition,
	s.is_incremental,
	spi.*
from sys.stats s
join sys.stats_columns sc
    on s.object_id = sc.object_id
    and s.stats_id = sc.stats_id
join sys.columns c
    on s.object_id = c.object_id
    and sc.column_id = c.column_id
join sys.tables t
	on s.object_id = t.object_id
join sys.schemas sh
	on t.schema_id = sh.schema_id
cross apply sys.dm_db_stats_properties_internal(s.object_id,s.stats_id) spi

of particular note is the spi.*

it's undocumented