Product has been added to your cart.

Search Results for “ssd”

Looking Back at the 2022 #PASSDataCommunitySummit in Seattle

Last Updated November 21, 2022

I’m back home in Vegas, back down to Inbox Zero, and I’ve had some time to think about last week’s conference in Seattle. I liveblogged the keynotes, but I wanted to talk about the conference overall. This was Redgate’s first time running an in-person Summit after the professional organization folded in December 2020. Redgate bought…

#PASSdataCommunitySummit Keynote Day 3 Live Blog

Last Updated November 18, 2022

Today at the PASS Data Community Summit in Seattle, Kimberly Tripp is doing the first-ever in-person community keynote. Here’s the abstract: Over the 30+ years I’ve been working with SQL Server, I’ve seen an incredible amount of innovation and change. How do we keep up with so many changes and how do we know how…

#PASSdataCommunitySummit Keynote Day 2 Live Blog

Last Updated November 17, 2022

I’m in Seattle for the PASS Data Community Summit, and the day 2 keynote is about to start. This year, now that Redgate owns the Summit event, they’re doing the day 2 keynote. Gotta pay the bills, I suppose! Redgate’s CEO, Jakub Lamik, is leading a team of speakers for the keynote, and here’s the…

Rohan Kumar

#PASSdataCommunitySummit Keynote Day 1 Live Blog: SQL Server 2022 is Out Now.

Last Updated November 16, 2022

I’m in Seattle for the biggest annual gathering of Microsoft data platform professionals, the PASS Data Community Summit. This is the first in-person Summit since the pandemic, and the first since Redgate took over ownership from the old PASS organization. I’m really excited – this is like a family reunion for me. Microsoft’s Rohan Kumar…

Comparison Review: Microsoft SSDT vs Redgate SQL Source Control

Last Updated November 14, 2020

Hi. I’m still not Brent. My name’s Alex, and I care about databases, DevOps and data protection. Last year I delivered a session on GroupBy all about how to do Database DevOps right, and back in May I wrote a blog post for BOU about how to screw it up. Now, dear reader, I’m going…

Pocket Square

First Responder Kit Release: Like pssdiag, if pssdiag had parents who cared

Last Updated July 18, 2018

First Responder Kit Updates

I went to the PFE and guess what he told me? Guess what he told me? He said girl you better try fix those spinlocks too No matter what you do, now run this tool You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1620: @AAvella schooled us on Group Policy registry settings. Someday, we’ll get our act…

SSD RAID Load Testing Results from a Dell PowerEdge R720

Last Updated December 9, 2018

Hardware, Load Testing, Storage

We’ve got a client that does big batch jobs every day, loading hundreds of gigabytes of data or more in short bursts. They were frustrated with slow performance on the batch jobs, and after we performed our SQL Critical Care® with ’em, it was really clear that their hardware was the bottleneck. They were using…

Monitoring SSD Performance

Last Updated February 13, 2017

Jeremiah Peschka

SQL Server, Storage

Everyone wants to make sure they’re getting the best performance out of their solid state storage. If you’re like a lot of people, you want to make sure you’re getting what you paid for, but how do you know for sure that the drive is performing well? Watch that Average The first way to monitor…

I’m on RunAsRadio Talking SQL Azure and SSDs

Last Updated April 20, 2011

At the Connections conference in Orlando, I had the opportunity to sit down with Richard Campbell, host of RunAs Radio, and talk shop. I love conversations with Richard because he gets to travel and touch all kinds of cool systems, so as a result we end up jumping off-topic all over the place, talking about…

[Video] Office Hours: Ask Me Anything About Microsoft Databases

Last Updated February 12, 2024

Post your database questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss on the stream. If you’d like to be alerted when I live stream these, follow me on Twitch. Here’s what we discussed today: 00:00 Start 00:38 Steve E: Hi Brent, Have you ever come across any environment using Application…

ChatDBA: ChatGPT 4 Answers 5 Office Hours Questions

Last Updated December 1, 2023

Production Database Administration

Every now and then, someone asks a question on PollGab about why I don’t use ChatGPT to answer these questions. And sometimes, I wonder that myself – I wonder why people don’t put their questions into ChatGPT, especially GPT 4, because it’s pretty damned good. I did this a while ago using ChatGPT 3.5, which…

[Video] Office Hours: Yes, I’m In the Same Shirt

Last Updated October 25, 2023

Why yes, I’m wearing the same shirt as the video from “yesterday”. Why do you ask? Stop paying attention to that, and check out the top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:12 DBABA (database administrator by accident): I have a complex, nested view. everytime after a dacpac deployment this view runs…

[Video] Office Hours at Breiðamerkursandur, Diamond Beach

Last Updated September 4, 2023

Post your Azure SQL DB and SQL Server questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss. In this episode, I’m overlooking Breiðamerkursandur, Diamond Beach, one of the most Instagrammed places in Iceland. Here’s a shot from a prior trip when I climbed up on one of the icebergs: This time…

“Oops, I Lost My Indexes in Azure SQL DB.”

Last Updated September 12, 2023

Azure SQL DB, Backup and Recovery

I got an interesting request for consulting, and I’m going to paraphrase it: We were using Azure SQL DB with automatic index tuning enabled for months. Things were going great, but… we just deployed a new version of our code. Our deployment tool made the database schema match our source control, which… dropped the indexes…

The PASS Summit Lineup Is Out and Registration is Open!

Last Updated August 14, 2023

This year’s PASS Data Community Summit is November 13-17 in Seattle. (No online version is available this year – you gotta be there in person.) If you’ve attended in person before, you already know the value: it’s like a family reunion for the Microsoft data community. It’s your chance to see the authors you’ve read…

Office Hours Podcast

[Video] Office Hours: Azure & SQL Server Q&A

Last Updated May 4, 2023

Y’all post questions at https://pollgab.com/room/brento, and I go through the top-voted ones on my Twitch channel streams. Here’s what we covered today: 00:00 Start 01:56 Manoj: Where do you see artificial intelligence having the most impact on DBA’s? 03:25 It’s ‘a me: Hi Brent, is it still “best practice” to have databases split into…

Happy 21st Anniversary, BrentOzar.com. What’s Coming Next?

Last Updated June 1, 2023

It’s pretty cool to look at a blog post and see, “Last updated: 21 years ago.” It’s pretty fun to see old pictures of me in the media library, too. When I first started blogging over two decades ago, it wasn’t a business. I just did it because I enjoyed writing, sharing, and being part…

3 Ways to Debug T-SQL Code

Last Updated January 6, 2023

Writing new code = bugging. That part’s easy. Taking those bugs back out, that’s the hard part. Developers are used to their tools having built-in ways to show what line of code is running now, output the current content of variables, echo back progress messages, etc. For a while, SQL Server Management Studio also had…

Should You Use SQL Server 2022’s DATETRUNC?

Last Updated December 16, 2022

SQL Server 2022 introduced a new T-SQL element, DATETRUNC, that truncates parts of dates. For example: SELECT DATETRUNC(year, '2017-06-01'); 1 SELECT DATETRUNC(year, '2017-06-01'); Truncates everything in that date other than the year, so it returns just 2017-01-01 00:00: You might ask, “Well, why not just use YEAR()?” That’s a good question – there are times…

Slow “Having” Query? Try Pre-Filtering.

Last Updated November 21, 2022

I was helping a client with a query, and I’m going to rework the example to use the Stack Overflow database for easier storytelling. Say we need to: Find all the locations where users have logged in since a certain date, then Return the total count of people who live in those locations One way…