Search Results for &#8220;extended event&#8221;

If you deal with VMware, Hyper-V, SANs, and SQL Server, come check out my pre-conference session at SQLBits in York, England on Thursday, September 30th. My all-day session is called, “Virtualization, SAN, and SQL Server: The Perfect Storm.” This will be a fun, intimate session – it’s limited to 40 people max, and we’ve got…

SQL University: Scary Storage Scenarios

Last Updated February 13, 2017

Storage

In the final part of my SQL University serries, I talk about the nightmares of storage: why things change when we’re not looking and why virtualization makes it harder to keep an eye on things.

PASS Summit Keynote Notes (#sqlpass)

Last Updated February 12, 2017

#SQLPass

Updates It’s Friday, it’s 8:30 AM, and it’s time for another keynote. 8:30 AM – Bill Graziano just rode out on a trike! 8:40 – Two sessions will be repeated today due to high demand. At 10:45 in room 604 they’re repeating the clustering session, and 2:30 in room 6E is SQL Server on SAN.…

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…

PASS Summit 2018 Keynote Day 1: Live Blog

Last Updated November 7, 2018

#SQLPass

Today is the opening day of the 2018 PASS Summit, the largest annual gathering of Microsoft data professionals. Every year, thousands of us gather at the Seattle Convention Center to connect, learn, and share. On this first day of the conference, all the attendees go to the same room to watch the keynote speech. To…

What’s New in SQL Server 2019’s sys.messages: More Unannounced Features

Last Updated September 24, 2018

SQL Server 2019

The system table sys.messages holds error messages that SQL Server needs to return to end users. When a new build comes out, I love checking this table to see what features Microsoft has coded, but isn’t quite ready to announce yet. When SQL Server 2017 came out, that’s how I unmasked snapshot materialized views, a…

[Video] Office Hours 2018/1/10 (With Transcriptions)

Last Updated January 18, 2018

This week Brent, and Richie discuss validating backups using the backup set table, how to figure out if you’re a Mid-Level or Senior DBA, rollbacks, compatibility modes while upgrading SQL Server versions, MAXDOP settings, and Brent’s car purchasing tip. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our…

[Video] Office Hours 2017/06/07 (With Transcriptions)

Last Updated June 11, 2017

This week, Brent, Erik, and Richie discuss running SQL Server 2017 CTP on Linux, receive side scaling on servers and VMware, query tuning, nested roles vs. assigning roles to users, hierarchical data type, apps and scripts for automating restores, and learning Azure and AWS. The audio’s kinda rough this week because Brent & Erik were…

[Video] Office Hours 2016/10/12 (With Transcriptions)

Last Updated October 15, 2016

This week, Brent, Richie, and Erik discuss estimating compression savings, disabling triggers, suggestions to first-time Pass Summit attendees, tools for database version control, transitioning from SQL 2000 to 2016, troubleshooting failovers, and how to convince your manager to upgrade to newer version of SQL. FYI: our regular transcriptionist is out for a couple of weeks,…

[Video] Office Hours 2016/07/27 (With Transcriptions)

Last Updated July 30, 2016

This week, Brent, Richie, Erik, and Tara discuss speeding up performance, how to make SSRS highly available, what to do with SSIS packages when making upgrades, Windows Core, and how to hide data from DBAs when they have SA access. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to…

[Video] Office Hours 2016 2016/04/27

Last Updated June 7, 2020

This week, Brent, Erik, Jessica, Angie, and Tara discuss SQL service packs, partial restores, breaking replication, backups, as well as their favorite TV shows. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. If you prefer to listen to the audio: Transcript:…

The Nine Circles of Developer Hell

Last Updated February 13, 2017

Kendra Little

Humor

Commit message: Duck! Everyone’s code is terrible. But exactly how terrible is yours? First Circle: Code Limbo We can’t say this is good code, but for the most part nobody notices it. Second Circle: Code Lust Cool function, bro! Third Circle: Gluttonous Code There’s always one simple piece of logic that’s been written hundreds of…

“Who Wrote This?” Contest

Last Updated February 12, 2017

Humor

Over and over, readers leave comments here saying things like “Nice comment, Brent” on a post that Kendra wrote. We laugh about it – after all, they can’t really be reading that closely if they don’t even notice the name on the bottom of the post, right above where they’re commenting – but we started…

Brent’s 2012 Conference Schedule

Last Updated February 12, 2017

#SQLPass

I feel like the luckiest guy in the world: I get to take part in six major SQL Server events in 2012. Here’s where I’m going and why: January 26-Feb 4: SQLCruise Miami SQLCruise is the highlight of my year. This year, we’ve transitioned SQLCruise completely to Tim Ford – he owns the event start…

How to Buy Your First Mac

Last Updated February 13, 2017

Hardware

So you’re tired of craptastic plastic, and you’re noticing more and more Windows people toting around shiny metal computers? Here’s what you need to know. Update October 2013 – updated to include the current Apple laptop lineup. Running Windows On Your Mac If you’re reading this, you probably make a living working with Windows software,…

Rock Stars, Normal People, and You

Last Updated June 7, 2020