New Buying Option: Lifetime Access to Class Recordings
Wanna buy my Recorded Class Season Pass: Fundamentals or Mastering, but you don’t want an annual subscription? Now you can buy either of those bundles, pay one price, and get permanent access to the classes without worrying about recurring fees. …
Find Database File Latency – SQL in Sixty Seconds #198
Lots of people asked me to create a video on my earlier blog post SQL SERVER – Script to List Database File Latency. Here is the video on the same topic. I use this script quite often in my Comprehensive Database Performance Health Check. You can find …
Summit 2022 Community Pre-cons have been announced
The post Summit 2022 Community Pre-cons have been announced appeared first on SQLServerCentral.
Introduction to artificial intelligence
The post Introduction to artificial intelligence appeared first on SQLServerCentral.
Understanding Shared Access Signature and Access Policy in Azure Storage
Introduction You may want to provide access to the files from your Azure storage account container, there are a couple of ways to do it. You can share the access key but it may not be the best option because this is something you want to keep secret. A …
[Video] Office Hours: Palm Springs, California Edition
On a road trip from San Diego to Vegas, I stopped in Palm Springs and answered your highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:45 i_use_lowercase_for_select: Hi Brent, just wanted …
Tracking Changes in MySQL Configuration
What will you do if your system working perfectly fine, suddenly starts slowing down to the point where it stops responding? Your first reaction is to check the change in the workload. It is a common culprit for most the sudden slowdowns. Let us say th …
Office Hours Speed Round, Text Edition
Not all of the questions y’all post at https://pollgab.com/room/brento are hard – some of ’em can be answered in just a line or two: Q: Hany: Hello Brent, Who’s “Brent Ozar” in the Azure world? Microsoft, and I wrote …
[Re-post] The 10 Benefits of Monitoring for Leaders
The post [Re-post] The 10 Benefits of Monitoring for Leaders appeared first on SQLServerCentral.
Power BI Report Builder Expressions – Date Functions
Using Power BI Report Builder expressions is an advanced topic that requires a little programming knowledge. You can use if clauses, cases, functions, etc. In this tutorial, we will introduce the use of Expressions in Power BI Report Builder. We will s …
Recover Recently Closed Tab in SSMS
The post Recover Recently Closed Tab in SSMS appeared first on SQLServerCentral.
The benefits of database change management
The post The benefits of database change management appeared first on SQLServerCentral.
Dealing with Transaction Log Growth
Introduction Relational databases are designed to track changes introduced to a database by data modification language (DML) commands. The fundamental reason for this construct is to ensure that changes are durable and that they can be rolled back reli …
[Video] Office Hours: Vail Fireside Chat
You posted and upvoted questions at https://pollgab.com/room/brento, and I sat down by the fire on a chilly evening in Vail, Colorado to answer ’em. I was driving cross-country, heading back from a road trip to see my mom. Here’s what we co …
Challenges Monitoring MySQL Performance
MySQL is one of the most popular relational database management systems (RDBMS). Applications are now becoming more data-dependent, and they are expecting more performance from the database applications. Every database system performs well when configu …