Heaps in SQL Server: Part 2 Optimizing Reads
The series so far: Heaps in SQL Server: Part 1 The Basics Heaps in SQL Server: Part 2 Optimizing Reads Heaps are not necessarily the developer’s favourite child, as they are not very performant, especially when it comes to selecting data (most pe …
Storage 101: Cloud Storage
The series so far: Storage 101: Welcome to the Wonderful World of Storage Storage 101: The Language of Storage Storage 101: Understanding the Hard-Disk Drive Storage 101: Understanding the NAND Flash Solid State Drive Storage 101: Data Cente …
Connecting to a SQL Server Docker Container Running in macOS
The series so far: Creating Your First SQL Server Docker Container in macOS Managing SQL Server Docker containers in macOS Connecting to a SQL Server Docker Container Running in macOS In the second part of this article series, you learned about the con …
Finally, You Can Buy Brent Ozar Unlimited Swag.
When I’m doing a webcast, the same question always comes up: “Hey, how do I get one of those coffee mugs?” We used to give ’em away during our in-person live training classes, but since I stopped doing those, we needed to come u …
DAX for SQL Folks: Part III – DAX Calculations
Introduction In response to my approach in the popular MDX Guide for SQL Folks series. I am using SQL as a good frame of reference for starting or developing a new approach for improving your Data Analysis Expression(DAX) language learning ex …
Testing SQL Server Stored Procedures and Functions with SQL Data Compare
The post Testing SQL Server Stored Procedures and Functions with SQL Data Compare appeared first on SQLServerCentral.
What is the impact of remote working on estate management?
The post What is the impact of remote working on estate management? appeared first on SQLServerCentral.
How Doug Lowing Gets the Most Out of His Live Class Season Pass
With my Live Class Season Pass, students have the ability to attend as many of my live online classes as they want for an entire year straight, plus they can view the instant replay recordings whenever they want. Doug Lowing, one of the students, share …
Provisioning Azure SQL Database with Failover groups using Terraform
Introduction The world of IT infrastructure is fast changing with the introduction of cloud offerings. Although the Azure/AWS portals make life easier but imagine if you have to provision multiple resources. You will spend entire day clicking and that …
Unlocking the value of frequent database deployments
The post Unlocking the value of frequent database deployments appeared first on SQLServerCentral.
Page Life Expectancy Doesn’t Mean Jack, and You Should Stop Looking At It.
Page Life Expectancy is a Perfmon counter that’s supposed to track how long pages stay in memory before they get flushed out to make room for other pages that are needed instead. Paul Randal has blogged this a few times, and rather than rehash …
Take our short readers’ survey and win a $50 Amazon voucher
The post Take our short readers’ survey and win a $50 Amazon voucher appeared first on SQLServerCentral.
Monitor Deadlocks in SQL Server with system_health Extended Events
The post Monitor Deadlocks in SQL Server with system_health Extended Events appeared first on SQLServerCentral.
What Was the Worst Database Decision You Ever Made?
I’m not talking about “oops” mistakes. I’m talking about things you decided to do on purpose, and then deeply regretted later. Me personally, my biggest database regret was that time almost twenty years ago when I ran a Profiler …
Understanding the State of Database Monitoring report
The post Understanding the State of Database Monitoring report appeared first on SQLServerCentral.