Sites anglophones


Join Me for Free Live SQL Server Training Next Week.

Publié le 26 mars 2024 sur brentozar.com
 

Next week, I’m teaching my very favorite class live online, for free, two different ways – one with all slides, and one with all demos. Whatever way you like to learn, I’ve got you covered. So, what’s the subject? You’re comfort …

 

Pagination and ordering by large values

Publié le 25 mars 2024 sur simple-talk.com
 

Pagination is a technique for limiting output. Think of Google search results, shopping the electronics category on Amazon, or browsing tagged questions on Stack Overflow. Nobody could consume all of the results in a single shot, and no site wants to s …

 

Tinkering with Fabric Data Factory Framework Functionality

Publié le 25 mars 2024 sur sqlservercentral.com
 

The post Tinkering with Fabric Data Factory Framework Functionality appeared first on SQLServerCentral.

Quick and Effective Migration Between CosmosDB Collections Using ADF

Publié le 25 mars 2024 sur sqlservercentral.com
 

This document aims to explain the process of using ADF (Azure data Factory) to make a copy of a Cosmos DB (Instance A)  collection into a new collection in another Cosmos DB Instance effectively and cost effectively. For example, here is our  Instance …

How to Optimize Power BI Semantic Model Performance with Vertipaq Analyzer

Publié le 22 mars 2024 sur sqlservercentral.com
 

The performance of a Power BI semantic model – formerly known as dataset – depends on a variety of factors. One of the biggest influences is the data model itself: did you put everything into one single big table (you might found out writing DAX might …

[Video] Office Hours in Snowy Telluride, Colorado

Publié le 21 mars 2024 sur brentozar.com
 

On a beautiful sunny afternoon in the mountains, I went through your top-voted questions from https://pollgab.com/room/brento. Audio is a little rough on this one because I used a new wireless microphone and forgot to put the wind shield on it. If you …

Does Your GROUP BY Order Matter?

Publié le 20 mars 2024 sur brentozar.com
 

Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT queries produce different results:CREATE INDEX Location_DisplayName ON dbo.Users(Location, DisplayName); SELECT TOP 100 Location, DisplayName, COUNT(*) …

Managed Vs Unmanaged Tables – Data Engineering with Fabric

Publié le 20 mars 2024 sur sqlservercentral.com
 

Managed Vs Unmanaged Tables Microsoft Fabric was released as general availability on November 15th, 2023. I will be creating a series of articles to get you up to speed on how to manipulate data in the lake house using Spark. I really like the speed of …

Free Live Webcasts: Slide & Demo Versions of How to Think Like the Engine

Publié le 19 mars 2024 sur brentozar.com
 

You’re comfortable writing queries to get the data you need. But you’re uncomfortable if someone asks you how it works, how SQL Server and Azure SQL DB turn your queries into results. You know there are execution plans, but … you’re u …

 

Department of Redundancy Department

Publié le 18 mars 2024 sur simple-talk.com
 

Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too much anymore, the first reason that databases came into existence was to remove redundancies. The first source of redundancy back in the dar …

 

Correct SQL Server Transactional Replication Issues with T-SQL and SSMS

Publié le 18 mars 2024 sur sqlservercentral.com
 

The post Correct SQL Server Transactional Replication Issues with T-SQL and SSMS appeared first on SQLServerCentral.

Find Unused or Backup Tables

Publié le 18 mars 2024 sur sqlservercentral.com
 

In this article, I am going to demonstrate how we can identify the unused tables of a given SQL database. As a database administrator, we must keep an audit of the database objects. You are administrating a database that has hundreds of tables and some …

The difference between BIN2 and Case-Sensitive collations in SQL

Publié le 15 mars 2024 sur sqlservercentral.com
 

A common question that arises in SQL Server collation discussions is whether a binary collation (BIN2) is functionally equivalent to a case-sensitive collation that is sensitive to all aspects of sensitivity (for instance, Latin1_General_100_CS_AS). In …

 

The Benefits of Volunteering at SQL Saturdays

Publié le 14 mars 2024 sur simple-talk.com
 

Editor note: The call for volunteer and speakers is open at on the Pass Data Community Summit 2024 site  for this year’s Summit coming up in Seattle November 4-8! Volunteering for local data events large and small is a great way to get into …

 

[Video] Office Hours: Speed Round

Publié le 14 mars 2024 sur brentozar.com
 

Not all of the questions y’all post at https://pollgab.com/room/brento require long-winded answers. Let’s conquer 22 questions in 15 minutes! Here’s what we discussed: 00:00 Start 01:05 JoseDBA: We just started monitoring our AlwaysOn …


Pages :