May 24, 2022
Introducing SQL Server 2022 Get SQL Server 2022 What’s new in SQL Server 2022 (16.x) Preview Bob Ward’s presentation deck about SQL Server 2022 SQL Server 2022 demo Introducing the Microsoft Intelligent Data Platform by Rohan Kumar Announcing SQL Server 2022 public preview: Azure-enabled with continued performance and security innovation by Peter Calin SQL Server […]
May 21, 2022
View Event: SQL Assessment – Microsoft’s Best Practices Checker Do you want to get the current 244 suggested best practices from the SQL Server Team and evaluate your environments? These best practices are available for all instances, from your Data Center to the cloud. In this demo session (Yes, no slides), I will show you […]
May 14, 2022
View Event: Query store hints demo Query Store hints feature provides an easy-to-use method for shaping query plans without changing application code. This feature is a member of the Intelligent Query Processing family. In this demo-only session, I will show how to use and take advantage of Query Store hints.
May 10, 2022
I thank Kenneth Fisher (Blog|Twitter) for hosting T-SQL Tuesday #150. The topic for this month is your first technical job(s). I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some of the T-SQL Tuesdays and participated in a few. Thank you, Steve Jones (Blog|Twitter), for coordinating this program. If […]
May 4, 2022
There is a new DMV currently in preview which returns information about backups of Azure SQL databases except for the Hyperscale tier. Microsoft official documentation is here. If you run the example query as-is from the above documentation some of the columns do not make sense. Instead, use this query where I am joining with […]