Say we have a database that we want to migrate a copy of into Kubernetes for test/dev purposes, and we don’t want to backup/restore. How can it be done?... The post SQL Server Cross Platform Availability Groups and Kubernetes appeared first on SQLServerCentral ..read more

I was trying to update my dbatools install to test something and go this error. I fixed it with a little help. The Fix The short answer from Chrissy LeMaire is to run this: install-module dbatools -Force –SkipPublisherCheck That worked. Why? Chrissy explained this, but essentially it’s a certificate approval thing. Certificates work by verifying each other in a chain. One cert checks another, which checks another, etc. In this case, Microsoft changed some things and while the dbatools goes through some of these things, the update-module is doing extra checks. Supposedly MS will fix this ..read more

I see a lot of confusion on how classifications and sensitivity labels work in Microsoft Purview. This blog will help to clear that up, but I first must address the confusion with Purview now that multiple products have been renamed to Microsoft Purview. I decided to use a question-and-answer format that will hopefully clear up the confusion (I was very confused too!): Microsoft Purview is now the combination of multiple Microsoft products.  Can you explain the differences? Let’s break Microsoft Purview down into three sections of features that were formerly other products to clarify thin ..read more

As someone attending the event since 2011, I would like to share my personal experience, the value of attending, and how the event has helped me throughout my career. For decades, the PASS Data Community Summit has supported the data community, and the event itself has been going strong for more than 25 years. Looking back on my experiences, I never realized the ebb and flow the journey would take me on, but the value of attending the conference quickly became evident to me. Each year, I have gleaned new ways to improve technology, data footprints, and beyond learning from expert speakers and ..read more

The world runs on data, and SQL is the key to unlocking its secrets. If you're ready to level up your SQL game, online training is a power move. But with a dizzying array of options, finding the perfect advanced SQL course can feel overwhelming. Don't sweat it – I've done the research, so you don't have to. Here's the lowdown on the 7 best advanced SQL courses to fuel your data analysis mastery in 2024. Course #1: Advanced SQL Overview: Advanced SQL promises to take your SQL skills from competent to confident. It dives into complex queries, window functions, common table expressions (CTEs ..read more

External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas before, we might have needed an intermediate technology to make a REST call to an Azure service, we can now use an Azure SQL Database to call a REST endpoint directly. One use case for this would be to retrieve a file from blob storage. I explain how to set this up below. Azure Preparations Before we can do the SQL parts, we need to do a bit of setup. First, we need to enable the system-assigned managed identity for the Azure SQL server. This is currently located under Security -> Identity in the Azure portal ..read more

This post talks about adding custom metrics from the sqlmonitormetrics.com site automatically and how this works (and how it doesn’t). This is part of a series of posts on Redgate Monitor. Click to see the other posts What is SQL Monitor Metrics? SQLMonitorMetrics was a site that Redgate built years ago to hold various community submitted metrics that users of Redgate Monitor (formerly SQL Monitor) might care about or be interested in using. Myself, Grant, and a number of other MVPs and SQL Server experts submitted our own metrics in various categories. At some point an integration was created ..read more

I was asked to review the following book by the publisher, and I must say that it was a good experience for me. I used the book to help guide me through security on my tenant even though I don’t have all the security bells and whistles that they call out. It was a great learning experience for me! Book Information Microsoft 365 Security and Compliance for Administrators A definitive guide to planning, implementing, and maintaining Microsoft 365 security posture Authors: Sasha Kranjac & Omar Kudović Length: 432 pages Publisher: Packt My Thoughts and Review Sasha and Omar covered the v ..read more

We’ve been hearing of a few people getting errors from the latest Undercover Catalogue, Powershell interrogation script. The issue seems to be happening when the scripts tries downloading automatic updates and online module definitions when running the script with older versions of Powershell. A new version of the script has now been uploaded to our GitHub repo, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/SQLUndercoverCatalogue/CatalogueInterrogation.ps1 If you are seeing problems, please use the new, updated script. The post Latest Update for Undercover Catalogue Powershel ..read more

As a Software Engineer, I would like to replicate a copy of my database from on-premise infrastructure to AWS. This will require me to look for a perfect tool to get the job done without encountering data loss or database integrity issues. AWS Database Migration Service (DMS) is very helpful in achieving such tasks very quickly and efficiently. AWS DMS also known as AWS Database Migration Service (DMS) helps to migrate data to AWS securely and easily. During the database migration using DMS, the source database remains fully operational during the data migration without any downtime to the a ..read more