Sites anglophones


 

Snake draft sorting in SQL Server, part 1

Publié le 12 avril 2024 sur simple-talk.com
 

I recently had a restore job where I needed to split the work up into multiple parallel processes (which I’ll refer to here as “threads”). I wanted to balance the work so that the duration was something significantly less than the sum …

 

 

Fabric and Azure SQL in a few clicks: Mirroring a Database

Publié le 12 avril 2024 sur simple-talk.com
 

Finally, mirroring is available for Fabric! You can mirror an Azure SQL to Fabric. It works for CosmoDB and Snowflake as well, but in this article, I will focus on Azure SQL. It is 100%, no, but it is definitely a feature that is really great even now. …

 

Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts

Publié le 12 avril 2024 sur sqlservercentral.com
 

Introduction to SQL Window Functions In today’s data-driven world, SQL (Structured Query Language) stands as a cornerstone for managing and manipulating database systems. A core component of SQL’s power and flexibility lies in its window functions, a c …

[Video] Office Hours: Career & Data Q&A

Publié le 11 avril 2024 sur brentozar.com
 

A few career and security questions found their way into the queue at https://pollgab.com/room/brento for this episode: Here’s what we covered: 00:00 Start 02:10 Ethan: What percent of your constant care shops require encryption to connect with S …

 

How to Use Any SQL Database With Rust

Publié le 11 avril 2024 sur simple-talk.com
 

Rust is emerging as a frontrunner for ensuring memory safety without sacrificing performance. Its growing popularity isn’t solely based on the “fearless concurrency” mantra but also on its expanding ecosystem that fosters integration …

 

 

Azure OpenAI and RAG Security

Publié le 10 avril 2024 sur simple-talk.com
 

The most watched videos on my youtube channel are related to security. Azure SQL Networking Secrets and Cloud Security: Secure Access from your Applications to Azure SQL explain private endpoints from different points of views: Azure SQL and Function A …

 

Your Teammates Need the Fundamentals.

Publié le 10 avril 2024 sur brentozar.com
 

You’ve been reading my site for a while, watching videos, keeping up with the best SQL Server techniques. However, you’ve got a lot of other folks on your team who don’t have as much free time as you, or they’re just getting sta …

SQL Server Plan Cache Bloat Performance Impacts

Publié le 10 avril 2024 sur sqlservercentral.com
 

The post SQL Server Plan Cache Bloat Performance Impacts appeared first on SQLServerCentral.

Using ChatGPT for T-SQL Code Reviews

Publié le 9 avril 2024 sur brentozar.com
 

For this month’s T-SQL Tuesday, Pinal Dave asked us if AI has helped us with our SQL Server jobs. For me, there’s been one instant, clear win: code reviews. I usually keep a browser tab open with ChatGPT 4, and I paste this in as a starting …

 

Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2

Publié le 8 avril 2024 sur simple-talk.com
 

In the first article in this transforming data series, I discussed how powerful PostgreSQL can be in ingesting and transforming data for analysis. Over the last few decades, this was traditionally done with a methodology called Extract-Transform-Load ( …

 

 

Giving Feedback on Microsoft Data Platform Tools

Publié le 8 avril 2024 sur simple-talk.com
 

As a data professional, there is a set of tools that you use on pretty much a daily basis. Before I started as the editor of Simple-Talk, there were two Microsoft tools I used every day of the work week, and also for my hobby work: SSMS (SQL Server Man …

 

Joining Queries in Azure Data Factory on Cosmos DB Sources

Publié le 8 avril 2024 sur sqlservercentral.com
 

This article illustrates how to join two queries using ADF (Azure data factory). Prerequisites First, prepare your data sources. Make sure you have at least two data sources (such as tables, files, or databases) that you intend to join together. Additi …

SQL Server Patching Using PowerShell DSC

Publié le 5 avril 2024 sur sqlservercentral.com
 

Introduction In the previous article we have seen how to install SQL Server Management Studio (SSMS) using PowerShell DSC. In this article, we will explore how to use PowerShell Desired State Configuration (DSC) to automate the patching process for SQL …

Introduction to Python including Installation, Jupyter Notebooks and Visual Studio Code

Publié le 5 avril 2024 sur sqlservercentral.com
 

The post Introduction to Python including Installation, Jupyter Notebooks and Visual Studio Code appeared first on SQLServerCentral.

[Video] Office Hours: Just Three Questions

Publié le 4 avril 2024 sur brentozar.com
 

Sometimes y’all post questions at https://pollgab.com/room/brento that require extended answers. Today, I’m hitting just 3 questions: Here’s what we covered: 00:00 Start 00:44 MyTeaGotCold: If storage is no issue, do I need to worry a …


Pages :