Quickstart: Connect SQL Server machines to Azure Arc
The post Quickstart: Connect SQL Server machines to Azure Arc appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? September 2023 Edition
Is your company hiring for a database position as of September 2023? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must …
Orchestrating a MySQL Container on Kubernetes
If you’ve been using MySQL for a while and want to learn how to orchestrate MySQL containers, you’ve come to the right place. And while using Docker on its own to manage a single MySQL instance or multiple instances has certain drawbacks, s …
Why Australian Azure SQL DBs Went Down for 8+ Hours
On August 30, Azure’s Australia East data center had a big problem, affecting customers like Bank of Queensland and Jetstar. Here’s the timeline: 30 August 2023 @ 08:41 – Voltage sag occurred on utility power line 30 August 2023 @ 08:43 – F …
Optimized Plan Forcing with Query Store in SQL Server 2022
In this article, we will delve into the world of Query Store and explore how to use Optimized Plan Forcing to improve performance in SQL Server 2022. We will discuss what it is, how it works, and how it can impact your system’s performance. The Query S …
How To Use Flyway for Database Migration in Spring Boot
The post How To Use Flyway for Database Migration in Spring Boot appeared first on SQLServerCentral.
SQL Server Row Level Security Deep Dive. Part 2 – Setup and Examples
The previous section in this series was an introduction to Row Level Security (RLS) and some use cases. This section focuses on basic setup of RLS, methods for implementing RLS and performance considerations with those implementations. The RLS access p …
Setting up Drill Through in the New Power BI Report User Interface
The post Setting up Drill Through in the New Power BI Report User Interface appeared first on SQLServerCentral.
Export and Import SSISDB in just a few clicks
From SQL Server 2012 onwards, Microsoft introduced a new deployment model in SSIS called the project deployment model. This new model has many benefits in managing SSIS project deployments, executions, and configurations. Every new version of SQL Serve …
[Video] Office Hours: Overly Caffeinated Edition
After consuming waaaay too much coffee, I went through your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 03:53 It’s ‘a me: Is there a feature in SQL that Microsoft abandoned that you wi …
[Video] Office Hours: All About Miles Edition
Today’s webcast featured an awful lot of questions from one particular person who was super-active at https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 00:03 Miles: Hi Brent, I am aware of “sp_statement” compl …
Let’s talk about Artificial Intelligence, ChatGPT and Gobbledegook
The post Let’s talk about Artificial Intelligence, ChatGPT and Gobbledegook appeared first on SQLServerCentral.
Free Webcast: Avoiding Deadlocks by Tuning Queries
You’ve been getting more and more deadlock errors, and users are starting to complain. You’re wondering if your queries are the root cause, and if so, what you should do to fix ’em. In a fast-paced session, I’ll explain the 3 ca …
Microsoft Fabric: Loading On-Premises and External Data
Loading On-Premises and external data is a fundamental need for a Data Platform such as Microsoft Fabric. However, during this preview stage, Microsoft Fabric brings many surprises (and, should I say, deceptions?) in this area. This blog may explain a …
How to export data to SQL Server using Bard (Google chatbot)
The article will explain how to export data to SQL Server with Bard can be challenging. Previously, we talk about Bard. Bard is a chatbot like ChatGPT created by Google. In this article, we will learn how to export data from different sources like JSON …