Query Store custom SSMS performance dashboard
As most of you might know, I am a big fan of the Query Store feature inside SQL Server 2016....
2016-11-08 (first published: 2016-11-02)
2,699 reads
DotNine SQL Server and more
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,656 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,515 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,781 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,034 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
671 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
748 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
664 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
1,409 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,544 reads
Blogs
Recovering a TDE Database Without the Certificate
If you don’t have the backups of the certificate and private key from the...
Daily Coping 31 Jan 2023
By Steve Jones
Today’s coping tip is to take a small step towards and important goal. One...
Tales From The Field Weekly Wrap Up for the Week of 01-23-2022
By SQLBalls
Hello Dear Reader! It's been a while since I had time to sit down...
Forums
Use Zonal RIs for less than 100% utilization?
We’ve been running 400-instance clusters of t3.medium on an on-demand basis during the work...
query multiple sql tables and alert last record written datetime
I'm trying to develop a script that connects to SQL pulls in a list...
Using a set based approach as opposed to Loop Based Procesing to Improve Perform
Hi there I have a script which processes and aggregates data. Now this is...
Ask SSC