SQLSteve (4/30/2014)
Sean Lange (4/29/2014)
SQLSteve (4/29/2014)
What is everyones view on accessing SQL data which is stored on SQL instances in the DMZ via management tools on your local desktop?Would you put a rule on the firewall to allow this? or would you have to directly log onto a server in the DMZ to access data stored there?
The more relevant question is why oh why do you have a sql instance in the DMZ???
So Sean is this something we shouldn't be doing? or something you see at just not really required?
Well as David pointed out there are times when it makes sense.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/