Sites anglophones


Stats Q&A 2: Updating SQL Server Statistics

Publié le 16 novembre 2021 sur SQLSkills.com - Erin Stellato
 

Last week I presented a session, Demystifying Statistics in SQL Server, at the PASS Community Summit, and I had a lot of great questions; so many that I’m creating multiple posts to answer them. This second post is dedicated to questions specific …

SQL Server 2022 Slogan Contest Winners

Publié le 16 novembre 2021 sur brentozar.com
 

Last week, I challenged y’all to come up with slogans for SQL Server 2022. I have to confess that when I came up with the idea for that blog post, I thought y’all would take it seriously. I thought you’d come up with ideas that were m …

Stats Q&A 1: Creating SQL Server Statistics

Publié le 15 novembre 2021 sur SQLSkills.com - Erin Stellato
 

Last week I presented a session, Demystifying Statistics in SQL Server, at the PASS Community Summit, and I had a lot of great questions; so many that I’m creating multiple posts to answer them. This first post is dedicated to questions specific …

Free Live Class This Week: Fundamentals of Columnstore

Publié le 15 novembre 2021 sur brentozar.com
 

Your report queries are too slow. You’ve tried throwing some hardware at it: your production SQL Server has 12 CPU cores or more, 128GB RAM, and SQL Server 2016 or newer. It’s still not enough to handle your growing data. It’s already …

Is Microsoft SQL Server 2022 a Big Release?

Publié le 11 novembre 2021 sur brentozar.com
 

Normally when y’all post questions here on Pollgab, I let ’em pile up and I eventually do an Office Hours webcast where I talk through my answers. I check in on the list every couple of days just out of curiosity, though, and one of ’ …

Updated First Responder Kit and Consultant Toolkit for November 2021

Publié le 10 novembre 2021 sur brentozar.com
 

Just like you, the First Responder Kit has been pretty much stable for the last couple of months. There have been a few small changes, but nothing too big. There are a few pending pull requests that folks are working on around an open source setup …

Contest: SQL Server 2022 Needs a Slogan.

Publié le 9 novembre 2021 sur brentozar.com
 

Now that Microsoft has announced that SQL Server 2022 is coming, it’s time for us to talk about a shameful truth: SQL Server doesn’t sell itself. Remember when everybody was talking about how MongoDB was Web Scale™? Or when Oracle was …

There is a Ton of Free SQL Server Training Coming Up.

Publié le 8 novembre 2021 sur brentozar.com
 

If you don’t get smarter soon, it’s your own damn fault. Oh sure, I’m running a Black Friday sale, but even if you’re as broke as SSMS’s live query plans, you can still afford this free stuff I’m doing: Weds-Thurs: Q …

[Video] Office Hours Manhattan Edition: Ask Me Anything About SQL Server

Publié le 5 novembre 2021 sur brentozar.com
 

I sat down on the edge of Brooklyn, overlooking the Manhattan skyline, to take your highest-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:42 Dylan: Do you have any experience with sys.dm_db_t …

[Video] Office Hours Speed Round: Quick Answers

Publié le 4 novembre 2021 sur brentozar.com
 

Think fast! Not all of the questions at https://pollgab.com/room/brento have long-winded answers. In this 5-minute session, I crank through a bunch of straightforward questions: 00:00 Introductions 00:32 Mike: Hi Brent, the delete job is blocking for a …

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

Publié le 3 novembre 2021 sur brentozar.com
 

Is your company hiring for a database position as of November 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 …

What’s New in SQL Server 2022

Publié le 2 novembre 2021 sur brentozar.com
 

Today at Microsoft Ignite, Microsoft started dropping new details on the next version of SQL Server, 2022. Here’s a 13-minute video from Bob Ward explaining and demoing some of the new features: The new features include: Failover back/forth from …

5 Ways to Measure a Query

Publié le 2 novembre 2021 sur brentozar.com
 

In my free How to Think Like the Engine class, we start out by measuring query performance using logical reads. That’s the number of 8KB data pages that SQL Server has to read in order to find your query’s results. That’s the measure …

The Curious Case of… the BULK_OPERATION lock during a heap NOLOCK scan

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

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

The Brent Ozar Black Friday Sale is Open Now.

Publié le 1 novembre 2021 sur brentozar.com
 

It’s the mooooost wonderful tiiiiime of the year…. You’re a database professional who wants to up your game. You’ve been stuck at home this year, and next year isn’t looking much better. You can’t attend in-person t …


Pages :