Sites anglophones


How Do You Test IOPs, Latency, and Throughput?

Publié le 8 décembre 2021 sur brentozar.com
 

You’ve heard these terms thrown around about storage, and you’re not sure what they mean, and how they relate to each other. Let’s make it simpler by using an analogy. Say you want to measure a shipping company. You’re trying to …

Create a SQL Server PolyBase Scale-out Group Using Amazon Web Services

Publié le 8 décembre 2021 sur sqlservercentral.com
 

The post Create a SQL Server PolyBase Scale-out Group Using Amazon Web Services appeared first on SQLServerCentral.

Going to SQLBits? Join me for my Mastering Parameter Sniffing workshop.

Publié le 7 décembre 2021 sur brentozar.com
 

You’re a database developer or DBA with at least 3 years experience performance tuning queries and indexes. You already know you have parameter sniffing issues, and now you need to figure out how to fix it. In this one-day class, you’ll lea …

Who’s Hiring in the Database Community? December 2021 Edition

Publié le 2 décembre 2021 sur brentozar.com
 

Is your company hiring for a database position as of December 2021? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment m …

Crazy, crazy end-of-year sale!

Publié le 1 décembre 2021 sur sqlskills.com - paul randall
 

Update: We extended the sale through Christmas Day at midnight UTC! Our end-of-year sale is here and the discounts are insane! For example: Our signature BlackBelt Bundle is usually $6,995; on sale for $1,999! Performance Tuning Bundle (IEPTO1 and IEPT …

Today is the last day to buy a Live Class Season Pass, EVER.

Publié le 30 novembre 2021 sur brentozar.com
 

Today is literally it. This is the end of an era. One of the most popular things I sell is my Live Class Season Pass, which gives you two cool things: The ability to drop in on any live online class that I teach for a year straight, plus The ability to …

My Black Friday sale ends tomorrow.

Publié le 29 novembre 2021 sur brentozar.com
 

The countdown timer is on: you’ve got less than 48 hours to grab one of my massively discounted bundles and get the SQL Server training you’ve always wanted at a price your manager can live with: Level 1: Fundamentals$395per year(save $1,39 …

[Video] Office Hours: Black Friday Edition, Ask Me Anything About SQL Server

Publié le 27 novembre 2021 sur brentozar.com
 

Yesterday, I finished setting up my new Apple MacBook Pro with the new M1 Max processor and did its first live stream on my Twitch channel to see how the hardware held up. I was tickled pink – worked great! Here’s what we covered: 00:00 Int …

[Video] Office Hours Speed Round: 17 Answers in 11 Minutes

Publié le 25 novembre 2021 sur brentozar.com
 

Not all of your questions need detailed answers. In this speed round, I race through 18 answers in 11 minutes: Here’s what we covered: 00:11 UnfortunatelyPostgresIsCheaper: I know you’ve answered that, as far as u know, there isn …

Logging Database Scoped Configuration Changes

Publié le 24 novembre 2021 sur sqlskills - jonathan kehayas
 

The introduction of DATABASE SCOPED CONFIGURATIONS in SQL Server 2016 enabled different configuration settings at the individual database level. However, there is no logging of changes to the database scoped settings by default in SQL Server, making it …

[Video] Office Hours on the Balcony Part 2

Publié le 24 novembre 2021 sur brentozar.com
 

Picking up right where we left off yesterday, we continue down through the not-so-highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:22 Andrew from Canada: To Null or not to Null? Th …

NOLOCK Is Bad And You Probably Shouldn’t Use It.

Publié le 23 novembre 2021 sur brentozar.com
 

I’m waiting for the YOLOck option.When you put NOLOCK in your query, SQL Server will: Read rows twice Skip rows altogether Show you changes that never actually got committed Let your query fail with an error This is not a bug. This is by design. …

Free Live Class This Week: Fundamentals of TempDB

Publié le 22 novembre 2021 sur brentozar.com
 

You’ve been working with Microsoft SQL Server for a couple of years, and you know a little bit about TempDB. You’ve heard that temp tables and table variables have different performance characteristics than regular user database tables, and …

[Video] PASS Data Community Summit Keynote: 5 Ways the Cloud Impacts Your Career

Publié le 18 novembre 2021 sur brentozar.com
 

Succeeding as a data professional is all about placing the right bets at the right times. The more you know about what’s happening around you, the better bets you can place. I’ve been working with databases for over two decades. In this ses …

[Video] Office Hours on the Balcony Part 1

Publié le 17 novembre 2021 sur brentozar.com
 

I hang out on my balcony in San Diego with a gin & tonic and a bunch of your highly upvoted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 01:33 FishCakesForTea: I have designed a filtered index fo …


Pages :