Sites anglophones


How to Use SQL to Analyze the Bitcoin Blockchain

Publié le 8 septembre 2023 sur sqlservercentral.com
 

Background The Bitcoin blockchain is a vast and complex database. It contains over 100 million blocks, each of which contains thousands of transactions. This makes it a challenge to analyze the blockchain using traditional methods. SQL is a powerful la …

Decision Tree – Credit Card Fraud Detection

Publié le 8 septembre 2023 sur sqlservercentral.com
 

Credit card fraud detection is an important application of machine learning techniques, including Decision Trees. The goal is to identify and detect fraudulent transactions and separate them from valid transactions to prevent financial loss and protect …

SQL Unit Testing reference guide for beginners

Publié le 8 septembre 2023 sur sqlservercentral.com
 

The post SQL Unit Testing reference guide for beginners appeared first on SQLServerCentral.

 

Working with MySQL constraints

Publié le 7 septembre 2023 sur simple-talk.com
 

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

Publié le 7 septembre 2023 sur brentozar.com
 

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

Publié le 7 septembre 2023 sur sqlmag.com
 

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

Publié le 6 septembre 2023 sur simple-talk.com
 

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

Publié le 6 septembre 2023 sur brentozar.com
 

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

Publié le 6 septembre 2023 sur sqlservercentral.com
 

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

Publié le 5 septembre 2023 sur brentozar.com
 

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

Publié le 5 septembre 2023 sur simple-talk.com
 

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

Publié le 4 septembre 2023 sur brentozar.com
 

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

Publié le 4 septembre 2023 sur sqlservercentral.com
 

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

Publié le 4 septembre 2023 sur sqlservercentral.com
 

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

Publié le 3 septembre 2023 sur simple-talk.com
 

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 …

 


Pages :