SQL Unit Testing reference guide for beginners
The post SQL Unit Testing reference guide for beginners appeared first on SQLServerCentral.
Working with MySQL constraints
MySQL provides a set of constraints that you can include in your table definitions to help ensure the integrity of the data. The constraints let you better control the types of data that can be added to the database. For example, you can use constraint …
[Video] Office Hours at Jökulsárlón Glacial Lagoon
Post your Azure SQL DB and SQL Server questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss. In this episode, I’m at Jökulsárlón Glacial Lagoon, a wonder of nature, watching the icebergs pile up, stuc …
How To Connect to SQL Server Database From PowerShell
PowerShell can be a valuable tool for data analytics and data orchestration, especially when dealing with SQL Server data.
Microsoft Fabric: Lakehouse and Data Factory in Power BI environment
Microsoft is merging Data Factory and Power BI Dataflows in one single ETL solution. It’s not a simple merging, but still these ETL tools are easier to use then ever. In this article, I will demonstrate how to create a lakehouse and ingest data u …
[Video] Office Hours at the Blue Lagoon
Road trip time! I’m recovering from jet lag after flying over to Iceland, so I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:55 Shehroz Sabzwari: What are your pros / cons …
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 …