Sites anglophones


The promise – and the perils – of GitHub Copilot

Publié le 23 octobre 2023 sur sqlservercentral.com
 

The post The promise – and the perils – of GitHub Copilot appeared first on SQLServerCentral.

Understanding Locking, Data Modification and Committing Data in SQL Server

Publié le 23 octobre 2023 sur sqlservercentral.com
 

The post Understanding Locking, Data Modification and Committing Data in SQL Server appeared first on SQLServerCentral.

Updated First Responder Kit and Consultant Toolkit for October 2023

Publié le 20 octobre 2023 sur brentozar.com
 

The last couple of releases have focused on running sp_Blitz with limited permissions, like not being able to see inside some user databases. Those efforts continue this month with a lot of work from Montro1981. Wanna watch me use it? Take the class. T …

What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples

Publié le 20 octobre 2023 sur sqlservercentral.com
 

Background A Common Table Expression (CTE) in T-SQL is like a versatile tool in the toolbox of a SQL developer. It’s a way to create a temporary result set that you can reference within a larger SQL statement. Think of it as a query-within-a-query that …

Azure Databricks Tables – Delta Lake, Hive Metastore, TempViews, Managed, External

Publié le 20 octobre 2023 sur sqlservercentral.com
 

The post Azure Databricks Tables – Delta Lake, Hive Metastore, TempViews, Managed, External appeared first on SQLServerCentral.

[Video] Office Hours: Back in the Vegas Home Studio

Publié le 19 octobre 2023 sur brentozar.com
 

After a long trip through Scandinavia, I’m back in the desert. You posted questions at https://pollgab.com/room/brento and I took the hot seat:   Here’s what we covered today: 00:00 Start 03:15 Marek: Hi Brent, what is the best solutio …

SQL ConstantCare® Population Report: Fall 2023

Publié le 18 octobre 2023 sur brentozar.com
 

The short story for this quarter: SQL Server 2019 is on fire, dominating the market. For the long story: ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates? …

What I Wish Everyone Knew About ETL Processes – Traditional to Modern Cloud Solutions

Publié le 18 octobre 2023 sur sqlservercentral.com
 

The post What I Wish Everyone Knew About ETL Processes – Traditional to Modern Cloud Solutions appeared first on SQLServerCentral.

Designing Databases for Distributed Systems

Publié le 18 octobre 2023 sur sqlservercentral.com
 

The post Designing Databases for Distributed Systems appeared first on SQLServerCentral.

Who’s Hiring in the Microsoft Data Platform Community? October 2023 Edition

Publié le 17 octobre 2023 sur brentozar.com
 

Is your company hiring for a database position as of October 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 in …

Fundamentals Week is Coming. Every Day, the Price Goes Up.

Publié le 16 octobre 2023 sur brentozar.com
 

You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes. You’ve tried watchi …

 

Don’t use DISTINCT as a “join-fixer”

Publié le 16 octobre 2023 sur simple-talk.com
 

I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there only to serve as a “join-fixer,” and I can explain what that means using an example. Let’s say we have the follo …

 

Explore Natively Compiled SQL Server Stored Procedure Execution Plans

Publié le 16 octobre 2023 sur sqlservercentral.com
 

The post Explore Natively Compiled SQL Server Stored Procedure Execution Plans appeared first on SQLServerCentral.

GIT Configuration and Automated Release for Azure Data Factory

Publié le 16 octobre 2023 sur sqlservercentral.com
 

Introduction Azure Data Factory resources including pipelines, datasets, linked services, etc. should be maintained in a version control system. Also, the changes implemented in the Data Factory in Development Environment need to be deployed in higher …

What Is Good Database Design?

Publié le 16 octobre 2023 sur sqlservercentral.com
 

The post What Is Good Database Design? appeared first on SQLServerCentral.


Pages :