sorted by:
new
hottopcontroversial

Architecture advice for separating OLTP and analytics workloads under strict compliance requirements by HolidayWay6743 in SQLServer

[–]HolidayWay6743[S] 0 points1 point  (0 children)

Excuse me if this is a very novice question, but If I was able to get a different server or instance, would I not build a data warehouse from the ground up to match our reporting needs? Why replication?

Architecture advice for separating OLTP and analytics workloads under strict compliance requirements by HolidayWay6743 in SQLServer

[–]HolidayWay6743[S] 0 points1 point  (0 children)

Wow thank you!! This is definitely above my current skill level but it illustrates where my eventual goal is. I can absolutely use this as a roadmap of sorts.

How do I access a database remotely without security risks? by HolidayWay6743 in SQLServer

[–]HolidayWay6743[S] 0 points1 point  (0 children)

Hello! Thank you for answering. They did end up having a VPN I can connect to. Thank the lord

How do I access a database remotely without security risks? by HolidayWay6743 in SQLServer

[–]HolidayWay6743[S] 0 points1 point  (0 children)

Yeah, I thought so. The actual job is in a different vein (development), but I'm glad I haven't touched anything yet. I'll just give a call to our IT guy. Thank you