New HP Spectre x360 Laptop
IntroductionEarlier this week, I bought a new HP Spectre x360 13-AP0023DX convertible laptop at Best Buy. I have often criticized Best Buy as a bad place to buy a computer, but in this case I ignored my own advice for some good reasons. First, this was …
SSMS v18 and Azure Data Studio: The Golden Age of SQL Server Tooling
Yesterday, SQL Server Management Studio 18.0 shipped. Here’s the official announcement, the download page, and the release notes. Yes, it’s still free, and yes, they’re still adding features. Yes, they removed database diagrams and th …
SQL Server Monitoring Week – Spotlight Cloud
Today I am starting a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary aim is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help customers with their vario …
Tracking the number of active sessions on a database using SQL Monitor
The post Tracking the number of active sessions on a database using SQL Monitor appeared first on SQLServerCentral.
Using Backup Encryption with an External Certificate
As security becomes more and more important to data professionals, one of the more basic things a DBA or sysadmin must do is protect the backup files for their databases. SQL Server provides a few ways to encrypt backups, and there are numerous third p …
BrentOzar.com is Turning 17 Years Old.
I registered it before then, and it used to be a static HTML site, but I consider the birthday to be the first published blog post from May 7, 2002. A few fun stats: 2002 Brent: at home with a Thinkpad with a webcam module on top, reading HAL-PC Magazi …
SQL Server Monitoring Week – SQL Monitor
Today I am starting a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary aim is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help customers with their vario …
SQL Server Database Users to Roles Mapping Report
The post SQL Server Database Users to Roles Mapping Report appeared first on SQLServerCentral.
5 reasons why backup and restore doesn’t cut it in dev and test
The post 5 reasons why backup and restore doesn’t cut it in dev and test appeared first on SQLServerCentral.
Fixing Performance By Throwing Cloud At It
Your databases are hosted in the cloud – either in VMs or in a database-as-a-service – and you’re having a performance emergency that’s lasted for more than a day. Queries are slow, customers are getting frustrated, and you …
SQL Server Monitoring Week – SQL Diagnostic Manager
Today I am starting a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary aim is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help customers with their vario …
Its time to accelerate the State of DevOps
The post Its time to accelerate the State of DevOps appeared first on SQLServerCentral.
Compressed Microsoft SQL Server Backups by Default
The post Compressed Microsoft SQL Server Backups by Default appeared first on SQLServerCentral.
Free SQL Server Load Testing Tools
So you wanna run a load test against SQL Server. One thing I need you to understand first: you have to provide the database and the queries. Almost all of the tools in this post, except the last one, are designed to help you run queries, but they don …
SQL Server Monitoring Week – Database Performance Analyzer
Today I am starting a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary aim is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help customers with their vario …