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
14 reads
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
14 reads
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
128 reads
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
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
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
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
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
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
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
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
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
Here’s how these tools can make Kubernetes security easier and help you avoid common...
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
Comments posted to this topic are about the item Shades and Reflecting on SQLBits...
In Azure SQL DB, i want to merge records from the staging table to...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers