AZ-700 Designing and Implementing Microsoft Azure Networking Solutions
The SQL Herald
by jdanton1
1M ago
One of the fun parts of working for a small-ish Microsoft Partner is that you have to take a lot of exams. Some of which aren’t in your direct comfort areas–last year I took a couple of security exams (which was mainly my own doing) and even the Cosmos DB developer exam, which was a bit of a stretch, but I’m pretty familiar with NoSQL, and I just had to understand the specific Cosmos API calls and methods. Azure Networking was something I was more comfortable with, but the breadth of this exam, and some services that I hadn’t worked with meant I had to take a different tact. Photo by Pixabay o ..read more
Visit website
Tech Field Day 26: ZPE Systems
The SQL Herald
by jdanton1
3M ago
I recently attended Tech Field Day 26, in Santa Clara, while we spent most of time with the Open Compute summit, and discussing CXL, we got to meet with hardware and software networking vendor, ZPE Systems. ZPE has a number of solutions in the edge and data center spaces that allow you to do secure network management and just as importantly automate large scale data center deployments. In my opinion there are two main concerns with building out network automation—security and device accessibility. ZPE aims to mitigate both of these risks–with security, by building a secure ring around your in ..read more
Visit website
Understanding CXL for Servers–Tech Field Day #tfd26 at OCP Summit
The SQL Herald
by jdanton1
3M ago
Last week, I was fortunate enough to be able to attend Tech Field Day 26 in San Jose. While we met with several companies, this was a bit of a special edition of Tech Field Day, and we attended the CXL Forum at the Open Compute Project conference. In case you don’t know the Open Compute Project is project from a consortium of large scale compute providers like AWS, Microsoft, Meta, and Google, amongst others. They aim to optimize hyperscale data centers in terms of power and cooling, deployments, and automation. So how does CXL fit into that equation? CXL stands for Compute Express Link, which ..read more
Visit website
Using the Dedicated Administrator Connection with SQL Server in a Docker Container
The SQL Herald
by jdanton1
4M ago
I use a Mac (Intel, you can only run SQL Server on Edge on Apple chips) as my primary workstation. While I have a Windows VM locally, and several Azure VMs runnining Windows, I can do most of my demo, testing, and development SQL Server work locally using Azure Data Studio, sqlcmd, and SQL Server on Docker. Docker allows me to quickly run any version or edition of SQL Server from 2017-2022 natively on my Mac, and has been nearly 100% compatible with anything I’ve needed Windows for core database functionality. And then this #sqlhelp query came up this morning. #sqlhelp Came across a message a ..read more
Visit website
Why You Shouldn’t Use Amazon RDS for your SQL Server Databases
The SQL Herald
by jdanton1
1y ago
Disclaimer: I’ve a Microsoft MVP and shareholder, but neither of these things affected my opinions in this post. Cloud vendors have built a rich array of platform as a service (PaaS) solutions on their platforms. They market these heavily, because they have higher degrees of stickyness compared to IaaS platforms (and in many cases they likely have higher profit margins), but they also have key benefits to the users of the platform. Because a PaaS solution is fully managed by the cloud provider, they tend have a set of common features: Easy to deploy–you are never running setup.exe Built-in hi ..read more
Visit website
Fixing SQL Server Database Corruption (when you get lucky)
The SQL Herald
by jdanton1
1y ago
First things first–if you are reading this, and not regularly running consistency checks on your SQL Server databases, you should drop everything you are doing and go do that. What do I mean by regularly? In my opinion, based on years of experience, you should run DBCC CHECKDB at least as frequently as you take a full backup. Unless you have a clean consistency check, you don’t know if that last backup you took is valid. SQL Server will happily back up a corrupted database. Screenshot of a failed checkdb, followed by a successful backup command I cheated a little bit here and used an undocumen ..read more
Visit website
Getting Started with Log Replay Service for Azure SQL Managed Instance
The SQL Herald
by jdanton1
1y ago
Recently, I’ve started on a project where we are migrating a customer to Azure SQL Managed Instance, which now supports a few different migration paths. You can simply backup and restore from a database backup, but you can’t apply a log or differential backup to that database. You can also use the Database Migration Service, but that requires a lot of infrastructure and Azure configuration. The log replay service, or LRS, is the functional equivalent of log shipping to your new managed instance database. While log shipping is a well known methodology for both database migrations or disaster re ..read more
Visit website
A Post-mortem for PASS, and What That NDA* Issue Was
The SQL Herald
by jdanton1
1y ago
Editor’s Note: I wrote this last December, and went back and forth on publishing. As I see some of the poor leadership patterns from PASS, creeping into new offshoots of the SQL Community, I decided to publish it today. I am not writing this to dance on the grave of PASS or throw pitchforks at anyone. Just like the rest of the community, I am disappointed at the end of PASS, as the community worked really hard to make the organization great. However, a lot of mistakes were made over the course of many years, and I think it’s important to talk about those mistakes, and how we as a community can ..read more
Visit website
Passing the AZ-500 Exam–How I Prepared
The SQL Herald
by jdanton1
1y ago
A few months ago, I was asked to do a webinar on security for Microsoft Teams. In preparing for that webcast, I noticed a number of security features that required either Azure Active Directory P2, or Office 365 M5. In order to get either of those two features for free, DCAC needed to gain the silver security competency from Microsoft. In order to do this one of us, had to pass wither MS (the Office/Microsoft 365 version) or the AZ-500 security exam. Since, I was the one who wanted the features, I volunteered to take the exam. The first time I took the exam, I didn’t do much preparation. I was ..read more
Visit website
A Lesson in DR, Azure Site Recovery, and Troubleshooting
The SQL Herald
by jdanton1
1y ago
I need to blog more. Stupid being busy. Anyway, last week, we were doing a small scale test for a customer, and it didn’t work the way we were expecting, and for one of the dumbest reasons I’ve ever seen. If you aren’t familiar with Azure Site Recovery it provides disk level replication for VMs, and allows you to bring on-premises VMs online in Azure, or in another Azure region, if you VMs are in Azure already. It’s not an ideal solution for busy SQL Server VMs with extremely low recovery point objectives, however, if you need a simple DR solution for a group of VMs, and can sustain around 30 ..read more
Visit website

Follow The SQL Herald on Feedspot

Continue with Google
OR