Sites anglophones


Free Live Webcast: Why is One Query Sometimes Slow and Sometimes Fast?

Publié le 28 septembre 2022 sur brentozar.com
 

Sometimes the exact same query goes slow out of nowhere. Your current fix is to update statistics, rebuild indexes, or restart the SQL Server. It works, but you don’t know why. The single most common reason is parameter sniffing. SQL Server “snif …

Easy and Cost Effective way to Encrypt Every SQL Server Database

Publié le 28 septembre 2022 sur sqlservercentral.com
 

The post Easy and Cost Effective way to Encrypt Every SQL Server Database appeared first on SQLServerCentral.

Redgate Summit: The Database DevOps Transformation

Publié le 28 septembre 2022 sur sqlservercentral.com
 

The post Redgate Summit: The Database DevOps Transformation appeared first on SQLServerCentral.

Buckle Up: October is Free Fundamentals Month!

Publié le 27 septembre 2022 sur brentozar.com
 

How about some completely free SQL Server training? Every weekday during the month of October, one of the modules from my Fundamentals classes will be absolutely free to watch. But you gotta watch it that day – you snooze, you lose. To prep, bloc …

Time to register for PASS Data Community Summit

Publié le 26 septembre 2022 sur sqlservercentral.com
 

The post Time to register for PASS Data Community Summit appeared first on SQLServerCentral.

How to Visualize Python Charts in Power BI Part 4

Publié le 26 septembre 2022 sur sqlservercentral.com
 

Introduction This is the 4th part of the topic of how to visualize Python charts in Power BI (part one, two, and three). Previously, we talked about violin plots, box plots, and hexagonal binning plots. In this chapter, we will cover the following topi …

PostgreSQL Triggers Part 2

Publié le 23 septembre 2022 sur sqlservercentral.com
 

Article Overview In this article, we will learn how to drop, alter, enable, and disable a PostgreSQL trigger. In the 1st part of this series, we got an overall view of database triggers, PostgreSQL-specific triggers, types of PostgreSQL triggers, and h …

Optimize Large SQL Server Insert, Update and Delete Processes by Using Batches

Publié le 23 septembre 2022 sur sqlservercentral.com
 

The post Optimize Large SQL Server Insert, Update and Delete Processes by Using Batches appeared first on SQLServerCentral.

Query processing architecture guide

Publié le 23 septembre 2022 sur sqlservercentral.com
 

The post Query processing architecture guide appeared first on SQLServerCentral.

[Video] Office Hours: Six-Minute Speed Round

Publié le 22 septembre 2022 sur brentozar.com
 

The morning after the Data TLV Summit in Tel Aviv, I stood out on the balcony and answered a few of your questions from https://pollgab.com/room/brento, rapid-fire style:   Here’s what we covered: 00:00 Intros 00:47 cyrpl: Hi Brent from PEI, …

[Video] Office Hours in Tel Aviv, Israel

Publié le 21 septembre 2022 sur brentozar.com
 

Before speaking at the Data TLV Summit, I sat by the Mediterranean Sea and discussed the top-voted questions you posted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:55 Manikandan GS: As postgres being one among the R …

SQL Server and Oracle Transparent Data Encryption Differences and Similarities

Publié le 21 septembre 2022 sur sqlservercentral.com
 

The post SQL Server and Oracle Transparent Data Encryption Differences and Similarities appeared first on SQLServerCentral.

Data Governance: Joining the Dots

Publié le 21 septembre 2022 sur sqlservercentral.com
 

The post Data Governance: Joining the Dots appeared first on SQLServerCentral.

New Online Class: Running SQL Server in AWS and Azure

Publié le 20 septembre 2022 sur brentozar.com
 

You’re used to managing your own SQL Servers in VMs, but now they’re asking you to work with the cloud. You’re already comfortable installing, backing up, and performance tuning “regular” SQL Servers, and you just need to catch up with what’s different …

 

Maximize the Business Impact with Quest EMPOWER

Publié le 19 septembre 2022 sur journey to sqlauthority
 

You do not want to miss out on signing up with Quest EMPOWER. I will be there along with Brent Ozar and the best Industry experts. Data operations is the foundation needed by data-driven organizations to efficiently modernize data infrastructure, optim …

 


Pages :