Restoring to Azure SQL Managed Instance – Part 2
So in the last blog we confirmed that we could move to SQL MI via some analysis, this is now time to actually do a backup and restore via...
2021-10-12
13 reads
All About SQL
Restore to SQL Managed Instance
Now that we have a Managed Instance built, the next question is how do we get data across? I will break this up into separate posts but the lesson...
2021-10-07
127 reads
Creating Azure SQL Managed Instance
First step login into the Azure portal and find SQL Managed Instance and click create. Yes you can find these tutorials all online but this is my thinking and...
2021-09-14
138 reads
Azure SQL Managed Instances
After many years working with different “flavours” of SQL server in Azure from its true PaaS form to SQL server in AKS (Azure Kubernetes Service) it’s time to look...
2021-08-12
185 reads
Azure Kubernetes Service – Handy Commands
Just some handy commands to use via kubectl. I found these useful for various reasons so hopefully you will too. Overview of our nodes. Pod information, remember from my...
2021-08-11
37 reads
Creating SQL Databases in AKS with PVC – Part 2
Last week I created the below with a dummy database and is something that I will do against SQL server but this time that has a persistent volume claim....
2021-08-09
45 reads
Creating SQL server Databases in AKS – Part 1
So, the point in the previous blog post was to leverage Persistent Volume Claims – PVC for data when using SQL server that it is needed in a stateful...
2021-08-03
11 reads
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
48 reads
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
60 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
62 reads
Blogs
Cyber Scams and Operation Shamrock
By Brian Kelley
Erin West gave the keynote for the 2025 Techno Security & Digital Forensics East...
The Book of Redgate: Ingeniously Simple
By Steve Jones
Redgate has been known for many useful tools that are easy to use. We’ve...
Building a Todo List RESTful API in C++ with Docker, GitHub Actions, Azure ACR: A Beginner’s Guide
C++ is a highly versatile language for developing console applications, batch processing, and performance-critical...
Forums
BULK INSERT messing up import of CSV file with a comma in it
Hi everyone I am using BULK INSERT to load a CSV. I have noticed...
Users Default Schema in a stored procedure.
One of our systems contains data for multiple organizations. OrgA should not be able...
Calculating Difference between Multiple Dates for a Given Condition in HH:MM:SS
We have the following requirement:- Event_Time ...
Question of the Day
Updating a Data API Builder Connection String
Can I use dab update to update a connection string in my Data API Builder configuration file?
See possible answers