I have finally decided to start blogging and Redgate have kindly given me a platform to do it.<\/p>\n
So, what am I going to blog about?\u00a0 Well pretty much anything and everything that I come across that is vaguely SQL Server related.\u00a0 Hopefully a lot of Azure content while I\u2019m getting to grips with it.\u00a0 I\u2019ve recently changed role and in the new job the entire test and production environment will be in Azure, and across multiple regions so lots to get my head round.<\/p>\n
Our current production database environment is on Infrastructure as a Service (IAAS). The reason we went this route is because it\u2019s for a database driven application and there is some cross database scripting and when we set it up that wasn\u2019t possible on an Azure SQL Database.\u00a0 I am now trying to remove that and go to using Azure SQL Database on Platform as a\u00a0 Service (PAAS).\u00a0 I have investigated all the stored procedures and found that whilst some can be decoupled using additional API calls (or so I\u2019ve been told because I\u2019m not a .net developer!) however some of the code I think may be difficult to actually decouple so I wanted to know if cross database scripting was actually still possible using a SQL Database just in case.\u00a0 Thanks to Grant Fritcheys great post here<\/a> I managed to get it \u00a0working on a test environment however for all you newbies like me, make sure that the user you use to connect to the secondary database has the right permission.\u00a0 In the end I used my admin account so now I\u2019ve got to create a user with much less permission but I\u2019ve proved that in theory it all works.<\/p>\n For my next trick I\u2019ve got to work \u00a0out how to develop this on my laptop and not have to rely on Azure, that may well be my next blog post!!!<\/p>\n Thanks for reading and hope to be back soon.<\/p>\n","protected":false},"excerpt":{"rendered":" I have finally decided to start blogging and Redgate have kindly given me a platform to do it. So, what am I going to blog about?\u00a0 Well pretty much anything and everything that I come across that is vaguely SQL Server related.\u00a0 Hopefully a lot of Azure content while I\u2019m getting to grips with it.\u00a0……<\/p>\n","protected":false},"author":10747,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[6044],"coauthors":[57570],"class_list":["post-78656","post","type-post","status-publish","format-standard","hentry","category-blogs","tag-azure-paas"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/78656","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/10747"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=78656"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/78656\/revisions"}],"predecessor-version":[{"id":78657,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/78656\/revisions\/78657"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=78656"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=78656"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=78656"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=78656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}