The New Lightweight Query Plan Profile Hint
SQL Server 2016 & 2017 enable a new way to get query performance metrics live via Extended Events.
2018-10-26
2,735 reads
Additional Articles
Generate HTML Formatted Email of SQL Server Database Consistency Check Errors
In this tip we look at to create a SQL Server DBCC CHECKDB errors email formatted in an HTML table. This will report any errors for all of your databases on the server.
2018-10-24
2,764 reads
Scheduling SQL Server Tasks on Linux
In this tip we look at how to schedule SQL Server tasks on Linux servers using Cron.
2018-10-23
2,090 reads
How to Linux for SQL Server DBAs — Part 2
SQL Server DBAs are typically quite familiar with security and best practices in Windows but may not understand how security works in Linux. In this article, Kellyn Pot'Vin-Gorman demonstrates how to manage user accounts in Linux and why working while logged in as root is a bad idea.
2018-10-22
2,405 reads
Your SQL Server is Bored: What Low Wait Times Mean
In which you ask your assistant to fetch your coffee, and time them.
2018-10-19
3,120 reads
Creating Machine Learning Applications using Azure Cognitive Services
Azure contains a vast array of services that can be used for machine learning, text analysis, and more. In this article, Supriya Pande provides a brief explanation of machine learning and then walks you through creating a sentiment analysis application.
2018-10-18
3,009 reads
Using Azure Quickstart Templates
In this tip we look at how to use Azure quick start templates as well as how you can customize the templates to meet your needs.
2018-10-17
2,544 reads
Configuring a MySQL Database on Amazon RDS
Although concerns about ownership and security persist, many companies have embraced cloud services and are reaping substantial financial rewards as a result. Rob Gravelle describes the different cloud database categories, and shows us how to configure an Amazon RDS MySQL database.
2018-10-16
2,171 reads
A Primer on Defect Management
Defects in software can occur in any phase of the software creation process. The earlier and better they are managed, the easier they are to correct. In this article, Afsana Atar explains defect management, including prevention and resolution.
2018-10-15
2,216 reads
Finding & Fixing Statistics Without Histograms
Men Without Hats were awesome. Statistics without histograms are terrible, but now they're easy to find and fix.
2018-10-12
3,200 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers