Sites anglophones


Find Foreign Key Problems: Answers & Discussion

Publié le 10 janvier 2024 sur brentozar.com
 

Your Query Exercise was to find foreign key problems: data that might stop us from successfully implementing foreign keys in the Stack Overflow database. Question 1: Write queries to find the problematic data. Montro1981’s thorough answer broke t …

Adding Cookie Consent to SQL Server Central

Publié le 10 janvier 2024 sur sqlservercentral.com
 

To comply with various regulatory requirements, we are adding a cookie consent form to the website. You will see this banner at the bottom if you have not accepted or rejected cookies before. You can control which types of cookies and data you are allo …

Connecting SQL Server to SaaS applications with a Linked Server

Publié le 10 janvier 2024 sur sqlservercentral.com
 

The post Connecting SQL Server to SaaS applications with a Linked Server appeared first on SQLServerCentral.

An In-Depth Look at MIXED_PAGE_ALLOCATION and Changes in Page Allocation

Publié le 10 janvier 2024 sur sqlservercentral.com
 

When it comes to managing data in SQL Server, efficient page allocation is crucial for performance and storage utilization. In recent years, there have been significant changes in the way SQL Server allocates pages for data storage, specifically with t …

Announcing the 2024 Data Professional Salary Survey Results.

Publié le 9 janvier 2024 sur brentozar.com
 

This is the 8th year now that we’ve been running our annual Data Professional Salary Survey, and I was really curious to see what the results would hold this year. How would inflation and layoffs impact the database world? Download the raw data h …

 

Optimized locking in Azure SQL Database

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

I don’t think I’ve ever had a great impression of Azure SQL Database as a place for production applications. In its early days, it was missing several important features (like data compression). While that hole has been plugged, there are s …

 

Machine learning K-Means applied to SQL Server data

Publié le 8 janvier 2024 sur sqlservercentral.com
 

Introduction In this article, we will use K-Means applied to SQL Server using Python. We will learn what is the K-Means algorithm, how to use Python to create charts, and how to connect to SQL Server. The data in SQL Server will be segmented in cluster …

 

PowerShell Dynamic Parameters and SQL Server

Publié le 5 janvier 2024 sur simple-talk.com
 

Have you ever been in a situation that you want to call a cmdlet or a function with a parameter that depends on a conditional criteria that is available as a list? In this article I will show a technique where you can use PowerShell Dynamic Parameters …

 

New Power BI Explore this Data Feature: An Alternative to Excel Pivot Tables

Publié le 5 janvier 2024 sur sqlservercentral.com
 

The post New Power BI Explore this Data Feature: An Alternative to Excel Pivot Tables appeared first on SQLServerCentral.

Dijkstra's Algorithm

Publié le 5 janvier 2024 sur sqlservercentral.com
 

Introduction This article celebrates a classic algorithm [1] of Dijkstra (1930 – 2002) which finds a path of minimal cost between any pair of nodes in an undirected graph. His procedure is widely recognized as a fundamental tool for examining communica …

Query Exercise: Find Foreign Key Problems

Publié le 4 janvier 2024 sur brentozar.com
 

For 2024, I’m trying something new: weekly homework challenges! For this week, let’s say we’ve decided to implement foreign keys, and we need to find data that’s going to violate our desired keys. We’re going to use the St …

 

Being A Bit Less Comfortable in 2024

Publié le 3 janvier 2024 sur simple-talk.com
 

I hate coming up with ideas for editorials, but my last editorial of the year gives me a very simple topic just staring me in the face: New Year’s Resolutions. Love them or hate them (or it we are honest, a good bit of both,) this end of one …

 

[Video] Office Hours: Oddball Questions Edition

Publié le 3 janvier 2024 sur brentozar.com
 

The last Office Hours of 2023 featured some oddball questions from https://pollgab.com/room/brento. Not bad, just … odd. https://youtu.be/prkpWssHsaE Here’s what we covered: 00:00 Start 03:04 TheMooneyFlyer: Hey Brent, how do you work on op …

SQL Window Functions Series: NTILE()

Publié le 3 janvier 2024 sur sqlservercentral.com
 

Continuing our journey through SQL’s handy window functions, we now tackle the NTILE() function. After exploring LAG(), LEAD(), RANK(), and DENSE_RANK(), NTILE() stands out for splitting data into clear, ordered groups. It’s perfect for grading perform …

Kickstart the year with our free Livestream! Navigating the database landscape in 2024

Publié le 3 janvier 2024 sur sqlservercentral.com
 

The post Kickstart the year with our free Livestream! Navigating the database landscape in 2024 appeared first on SQLServerCentral.


Pages :