Sites anglophones


PASS Data Community Summit 2023

Publié le 26 juillet 2023 sur sqlservercentral.com
 

The post PASS Data Community Summit 2023 appeared first on SQLServerCentral.

What is OneLake in Microsoft Fabric?

Publié le 26 juillet 2023 sur sqlservercentral.com
 

Get ready to be blown away! The highly anticipated Microsoft Build in May 2023 has finally unveiled its latest and greatest creation: the incredible Microsoft Fabric – an unparalleled Data Intelligence platform that is guaranteed to revolutionize the t …

 

Querying PostgreSQL: Learning PostgreSQL with Grant

Publié le 24 juillet 2023 sur simple-talk.com
 

Writing queries to retrieve the data from a database is probably the single most common task when it comes to working with data. Working with data in PostgreSQL is no exception. Further, PostgreSQL has an incredibly rich, wide, and varied set of mechan …

 

Finishing Up Your Free Azure Networking Training

Publié le 24 juillet 2023 sur brentozar.com
 

To celebrate this month’s launch of our new class, Fundamentals of Azure Networking for the Data Professional, we’re making one video a day completely free. Here’s what’s on tap this week: July 24: Demo: Working With a VPN July …

A Overview of Amazon Redshift

Publié le 24 juillet 2023 sur sqlservercentral.com
 

Introduction In the world of big data analytics and data warehousing, Amazon Redshift has emerged as a powerful cloud-based solution for processing and analyzing vast amounts of data. Redshift is a fully managed, petabyte-scale data warehousing service …

DAX RANKX Function Behaviors Lead to Incorrect Results and Corrections

Publié le 24 juillet 2023 sur sqlservercentral.com
 

The post DAX RANKX Function Behaviors Lead to Incorrect Results and Corrections appeared first on SQLServerCentral.

Exploring Parameter Sensitive Plan Optimization in SQL Server 2022

Publié le 21 juillet 2023 sur sqlservercentral.com
 

Overview of PSP Optimization PSPO (Parameter Sensitive Plan Optimization) is a SQL Server feature that improves query performance by accepting varied data sizes based on the runtime parameter value(s) specified by the customer. It deals with the situat …

SQL Server vs Oracle Query Statistics to Improve Performance

Publié le 21 juillet 2023 sur sqlservercentral.com
 

The post SQL Server vs Oracle Query Statistics to Improve Performance appeared first on SQLServerCentral.

PASS Data Community Summit – Early Bird price ends July 26

Publié le 21 juillet 2023 sur sqlservercentral.com
 

The post PASS Data Community Summit – Early Bird price ends July 26 appeared first on SQLServerCentral.

 

Optimizing Queries in MySQL: Optimizing Updates

Publié le 20 juillet 2023 sur simple-talk.com
 

In the previous parts of these MySQL optimization series, we’ve told you how queries work on a high level, then dived deeper into the power of SELECT and INSERT statements. In this blog, I will cover some of the ways to optimize modifying your da …

 

[Video] Office Hours: SO MANY Good Questions

Publié le 20 juillet 2023 sur brentozar.com
 

Seriously, how do y’all keep coming up with so many great questions? I went through your top-voted questions from https://pollgab.com/room/brento/ on a live stream on my Twitch channel, like I do on most Wednesdays & Thursdays, and really enj …

[Video] Office Hours: While Stack Overflow is Down

Publié le 19 juillet 2023 sur brentozar.com
 

Stack Overflow was down, so y’all posted questions at https://pollgab.com/room/brento and I gave ’em my best shot. Here’s what we covered: 00:00 Start 04:33 Amir: Does Az-900 worth the effort and money? What about other microsoft cert …

SQL ConstantCare® Population Report: Summer 2023

Publié le 18 juillet 2023 sur brentozar.com
 

The short story for this quarter: SQL Server 2022 adoption rates have stalled, even backtracked, and it doesn’t appear to be due to the cloud, either. For the long story: ever wonder how fast people are adopting new versions of SQL Server, or wha …

 

A Beginners Guide to MySQL Replication Part 3: Multi-Source Replication

Publié le 18 juillet 2023 sur simple-talk.com
 

Welcome back to the world of MySQL Replication! If you’ve been following this series, thank you for your support! And if you’re new here, welcome! Before we dive in, I suggest checking out the first part of the series to get up to speed. In …

 

Free Azure Networking Training This Week

Publié le 17 juillet 2023 sur brentozar.com
 

To celebrate this month’s launch of our new class, Fundamentals of Azure Networking for the Data Professional, we’re making one video a day completely free. Here’s what’s on tap this week: July 17: Demo: Using Virtual Networks f …


Pages :