Monitor Query Performance Using Query Store in SQL Server
The Query Store captures a history of queries, execution plans, and runtime statistics, which persist within SQL Server and can be reviewed later.
2018-04-12
4,214 reads
Articles
Software Testing Skills Must Shift with AI
Artificial intelligence (AI) is touching many parts of our lives and careers. Rama Anem discusses the impact of AI on software testing and how testers’ skills must adapt.
2018-04-11
2,961 reads
“Full Stack” Means “Part Time” – or Why DBAs Might Wanna Learn DevOps
Brent Ozar explains that if you're going to do continuous integration or deployment, you've got a rocky road ahead of you.
2018-04-10
4,855 reads
How to Programmatically Identify When Your SQL Server Was Last Started
Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.
2018-04-10
3,427 reads
Avoiding Unexpected Results with DATEDIFF in Year Comparisons
Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.
2018-04-09
1,791 reads
Mount SQL Server DMVs and Custom Queries Using DBFS on Linux
With SQL Server now supported on Linux, traditional SQL Server DBAs will need to learn how to work with Linux, and Linux administrators will need to learn how to work with SQL Server. Fortunately, there are several tools available to assist. In this article Prashanth Jayaram describes how to work with the DMV tool which treats queries as files.
2018-04-09
2,500 reads
How to execute a Powershell script via SSIS
Learn how you can execute a PowerShell script via the SSIS execute process task.
2018-04-06 (first published: 2015-12-03)
31,212 reads
Data Retention: An Inexact Art
A myriad of laws regulate data retention and generally compete with each other. William Brewer provides an introduction to the principles, but gives good advice -- leave the details to the specialists.
2018-04-06
2,948 reads
Analyze entity data flow in Power BI Desktop using Sankey charts
Siddharth Mehta looks at how and why to use Sankey charts and how this can be done in Power BI Desktop.
2018-04-05
3,082 reads
Whitepaper: Database deployments: Choosing a state-based or migrations-based approach
This whitepaper explores the differences between the approaches, state based or migrations based, and how Redgate tools can help.
2018-04-05 (first published: 2016-03-24)
6,278 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers