SQL Server and AKS
Following on from my last post after creating AKS, I now want to work with SQL server. First step, load up Azure cloud shell. Run the following commands Here...
2021-07-29
14 reads
All About SQL
Intro to AKS – Azure Kubernetes Service
What is Azure Kubernetes Service? Probably makes sense to tell you what Kubernetes is first. As Kubernetes states themselves “also known as K8s, is an open-source system for automating...
2021-07-21
43 reads
Azure Container Instance and SQL server part 2
In the last post we built an image of SQL server 2019 Linux hosted in Azure Container Instance for fast access to SQL server. So, your next question is...
2021-07-08
30 reads
Azure Container Instance and SQL server
Being heavily involved with Microsoft Azure and database technologies it was only a matter of time that I would enter the world of Azure Container Instances (ACI). The same...
2021-07-05
18 reads
Azure SQL Managed Instance Versions
Just a really quick FYI for the readers. If you are using Managed Instances in Azure (If not, why not?) and you connect vis SSMS (SQL Server Management Studio)...
2021-06-23
19 reads
Azure SQL Database – Secondary Database and Tiers
On the theme of failover groups let’s do a quick recap on my environment. As shown below you can see the secondary database server called spacesql in West Europe....
2021-06-11
62 reads
Azure SQL Database – Cancel Scale Up Request
You have an Azure SQL Database, it could be a single database, it could be a primary database within a failover group. Regardless of the context, what would you...
2021-06-07
66 reads
Azure SQL Database Restore to different server
It is quite a common requirement to restore a copy of a database to the same Azure SQL server, you just issue a COPY OF command. What if you...
2021-06-03
133 reads
Snowflake in Azure
Being aligned to a global cloud like Microsoft Azure you have choices. Whether that is Azure SQL Database or Azure Database for MySQL for your relational database, it does not matter...
2021-04-12
12 reads
Error creating Azure SQL Database
A quick post today, quite simply, the error message is: “code”: “ConflictingDatabaseOperation”, “message”: “Operation on server x and database y is in progress. Please wait a few minutes before trying again.” What is going on here? Well for this example (and maybe yours) I created a database...
2021-04-16 (first published: 2021-04-09)
212 reads
Blogs
Goal Progress for July 2021
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Data Modeling at your fingertips
By Rayis Imayev
(2021-July-30) A picture is worth a thousand words, the same way a visual database schema...
How to put a SQL Server Database into Recovery Pending
By John
You might be asking why on earth would you want to get a database...
Forums
How is Throughput optimized HDD (st 1)
Hi Everyone. i am planning to shift my website to AWS I want...
Alternative to LAG(SUM) - Can a Column Reference The Sum of the Values Above It
Hi Everyone, I'm trying to do something that seems pretty simple, but SQL Server...
Transaction log shrink w/ logshipping
Hello everyone, Again with this question. 🙂 I've got a log-shipped database, and I...
Ask SSC