2020-03-31
454 reads
Azure SQL database
Going Serverless with Azure SQL Database
Microsoft has a new virtual core offering of Azure SQL database called serverless and this offering optimizes the price performance tradeoff and simplifies performance management for databases with intermittent and unpredictable usage.
2020-01-14
Overview of Azure SQL Database Networking
Learn about the range of connectivity options available for Azure SQL Database deployments.
2019-12-24
Overview of Azure SQL Database Networking
Learn about the range of connectivity options available for Azure SQL Database deployments.
2019-12-20
Querying Master Database DMVs in Azure SQL Database
Learn how you can query information in the logical server's master database from an Azure SQL Database.
2019-12-12
1,604 reads
Moving Encrypted Data to Azure SQL Database
Learn how you can move encrypted data from on premises SQL Server to Azure SQL Database.
2019-11-26
1,202 reads
Very Hot Patches
Azure SQL Database can be patched without stopping the sqlsrvr.exe process. Quite a feat of engineering.
2019-10-08
150 reads
2019-08-15
642 reads
Cross Database Queries in Azure SQL Database
Cross database queries in Azure SQL Database aren't as straightforward as you might think, but they aren't hard to implement. Follow along to learn how to implement them.
2019-07-25
10,188 reads
Technology Flows Downstream
The technologies that we see in other data platform products sometimes flow to SQL Server.
2019-06-20
193 reads
Blogs
T-SQL Tuesday #125 – Unit testing databases – we need to do this!!
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
T-SQL Tuesday Live–7 Apr 2020
By Steve Jones
Last week went a little crazy, and I learned something: don’t post a Zoom...
Getting Your dbatools Version–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
MAXDOP and cost threshold for parallelism settings
Hi All, On one of our newly migrated sup-prod azure vm which is running...
Dial sbcglobal helpline for Customer Service
SBCGlobal Email Settings: If you are going to use Sbcglobal for your email applications...
How not to have sql to restart on the same node but failover on 1st failure in a
Hi, By default sql tries to restart on the same node in case of...
Ask SSC