Sites anglophones


 

Microsoft Fabric: Extended Source Control Features

Publié le 29 novembre 2023 sur simple-talk.com
 

The source control features in Microsoft Fabric are evolving every day. The PBIP feature included in Power BI allowed us to include source control on a SDLC process for Power BI, supporting reports and datasets linked directly from the portal to a repo …

 

[Video] Office Hours: Live on Black Friday Edition

Publié le 29 novembre 2023 sur brentozar.com
 

On Black Friday, I took a break from answering support emails to hit your top-voted questions from https://pollgab.com/room/brento.   Here’s what we covered: 00:00 Start 00:41 MatthewsSQLServer: How AlwaysON AG failovers cause can be analyze …

TABLOCK Hint can Negatively Impact SQL Server Concurrency

Publié le 29 novembre 2023 sur sqlservercentral.com
 

The post TABLOCK Hint can Negatively Impact SQL Server Concurrency appeared first on SQLServerCentral.

Using the Import Extension in Azure Data Studio

Publié le 29 novembre 2023 sur sqlservercentral.com
 

Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how the tool works, and I’ve got a few more coming. I covered a basic orientation and a more in-depth one on some of the code writing features. In …

Working with Azure DocumentDB: SQL & NoSQL Together

Publié le 29 novembre 2023 sur sqlservercentral.com
 

The post Working with Azure DocumentDB: SQL & NoSQL Together appeared first on SQLServerCentral.

[Video] Office Hours: Black Friday Promo Edition

Publié le 28 novembre 2023 sur brentozar.com
 

In this episode, a lot of the questions triggered mentions of our Black Friday Sale, on now! Here’s what we covered: 00:00 Start 01:41 Pete: 1 NUMA, 2 NUMA, 3 NUMA, 4 NUMA, or More? 176 cores, 1.5 TB RAM, currently all in a single NUMA configurat …

BrentOzar.com Cyber Monday Week Sale

Publié le 27 novembre 2023 sur brentozar.com
 

Every November, we run a huge sale here on my training courses, apps, and online services. Now’s your chance to talk to the boss and get the SQL Server and Azure SQL DB training that will help your company solve real problems in the year 2024 and …

 

When an update doesn’t update

Publié le 27 novembre 2023 sur simple-talk.com
 

Tell me if you’ve heard this one before: I changed data from my application, but when I checked the database, I couldn’t see the change! I’ve seen this. Loads. It can be quite perplexing for folks because they expect to see an error m …

 

Time Series Data Mining Example with T-SQL when Adding New Data

Publié le 27 novembre 2023 sur sqlservercentral.com
 

The post Time Series Data Mining Example with T-SQL when Adding New Data appeared first on SQLServerCentral.

Ensuring a Single Row Table

Publié le 27 novembre 2023 sur sqlservercentral.com
 

Single row tables in data modeling Single row tables are a fact of our life as as a data designer, data modeler, data programmer, data whatever. Whether you are setting up a data warehouse or an operational database, it happens often that you need to s …

 

Warehouse Load Patterns – Part 1 – Requirements and General Patterns

Publié le 26 novembre 2023 sur simple-talk.com
 

No matter the ETL tool used, there are some basic patterns to follow when transferring data between systems. There are many data tools and platforms, but the basic patterns remain the same. This focuses on SQL Server, but most of these methods work in …

 

 

Updates about Database Projects for Microsoft Fabric

Publié le 26 novembre 2023 sur simple-talk.com
 

comp A few weeks ago, I wrote a blog about Database Projects for Microsoft Fabric. It’s an interesting advance, but it was disappointing because it was only available in half. Updating the Fabric Data Warehouse was not possible yet. The November …

 

It’s Black Friday! Time to save big on SQL Server training.

Publié le 24 novembre 2023 sur brentozar.com
 

My Annual Black Friday Sale is On! I’m running a giant Black Friday sale on my training courses! You can choose from Fundamentals, Mastering, or both. The Fundamentals package is best if you’ve never been to a formal SQL Server training cla …

Black Friday returns to SQLServerFast

Publié le 24 novembre 2023 sur sqlservercentral.com
 

The post Black Friday returns to SQLServerFast appeared first on SQLServerCentral.

Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY

Publié le 24 novembre 2023 sur sqlservercentral.com
 

The post Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY appeared first on SQLServerCentral.


Pages :