Query Store Instance Dashboard
Last week I shared my custom Query Store Dashboard that can be used to view additional performance information that isn’t...
2016-11-07
2,120 reads
DBCC CLONEDATABASE and sensitive data
Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is...
2016-09-28
1,719 reads
Broadening horizons: from DBA to Data Science #1
As an IT professional we are used to spending a lot of time learning about new technologies or how we...
2016-06-09 (first published: 2016-06-02)
4,838 reads
Broadening Horizons: From DBA to Data Science #2 Math Fundamentals
In the previous article in this blog series I told you my plans of expending my horizons towards the Data...
2016-06-06
1,526 reads
SQL Server 2016 – It just runs faster SQL Server Engineer Blog Post Overview
In March the CSS SQL Server Engineers started to blog about various new enhancements made to the SQL Server Engine...
2016-04-22 (first published: 2016-04-13)
3,042 reads
SSMS Preview Plan Comparison Tool and Plan Viewer Optimizations
With the February release of the SQL Server Management Studio (SSMS) Preview Microsoft introduced a nice new tool inside SSMS,...
2016-04-06
690 reads
Talking about the Query Store at SQLBits!
From the 4th till the 7th of May 2016 one of the biggest SQL Server conference in the world will...
2016-03-29
761 reads
SQL Server Management Studio Preview
You may have heard that SQL Server Management Studio (SSMS) is now available as a stand-alone installation package outside of...
2016-03-18
698 reads
Session Based Wait Statistics in SQL Server 2016
As you probably know I am very fond of SQL Server Wait Statistics (shameless book link) and the options they...
2016-03-14
2,353 reads
Pro SQL Server Wait Statistics available now!
Remember that blog post from April this year that I announced working on my first ever SQL Server related book...
2015-09-02
1,552 reads
Blogs
Unused Indexes in SQL Server: Find them, vet them, and drop them safely
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
T-SQL Tuesday #191 Round Up
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
Come See Me at the PASS Data Community Summit
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Managing unused indexes
While doing some housekeeping activity on several old but large production databases, I come...
Cloud Performance Considerations
How important to SQL Server is the speed of the SSD and network latency?...
Question of the Day
Striped Backup File Limits
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers