When I’ve started working with Azure SQL there were some differences to SQL Server that I’ve needed to get used to. One of the first was that you just can’t query other databases that you’re already in, querying for [OtherDB].[dbo].[SomeTable] just wasn’t possible anymore. It appears that it may not be possible, but you actually can query for data in other databases.
Working with Azure means you can use on of databases it provides in SaaS model. It means you don’t have to install and configure i.e. SQL Server on some kind of (virtual or not) machine. Databases in SaaS model have a lot of other virtues but let’s not go there in this post, today I want to write about choices you can make during choosing which database to use.
Daj się poznać 2017 2755 dni, 22 godziny, 16 minut temu 46 źrodło rozwiń
Along with Get Noticed contest I’m a bit preoccupied with other activities. One of them is preparing to take 70-473 Exam (cloud and data related stuff). Since I’m reading and using cert related stuff I could as well write about it – I’ll probably remember everything I’ll write about for rest of my life (writing about things works magic with memory) and maybe someone will have any use for that. Let’s start with simple things – dynamic data masking.
Daj się poznać 2017 2825 dni, 7 godzin, 52 minuty temu 13 źrodło rozwiń