Introduced in SQL Server 2016 (13.x) SP1 and Azure SQL Database is the USE HINT option. At the time of writing this article, there are 23 of those. You can see an up to date list by running Dynamic Management View sys.dm_exec_valid_use_hints. With the introduction of this feature, we can replace some of the trace […]
Accessing runtime information of a query execution plan is vital to get a precise understanding of resource usage, execution patterns to resolve performance issues. Runtime statistics is beneficial while debugging query performance issues, such as long-running queries, and queries that run indefinitely and never finishes. Historically query completion was a prerequisite for the availability of […]
I thank Elizabeth Noble (blog|twitter) for hosting T-SQL Tuesday #123. The topic for this month is Automate Your Stress Away. I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some of the #TSQL Tuesday’s and participated in a few. Thank you, Steve Jones (blog|twitter), for coordinating this program. If you […]
I am writing this blog post for my own reference for future. Hopefully someone will be benefited in the process. Recently I was working on upgrading System Center Operations Manager and configuring alert for high CPU. I wanted the alert to trigger if CPU was above a certain percent for x consecutive polls. While simulating […]
Data Discovery & Classification is supported for SQL Server 2012 and later, and can be used with SQL Server Management Studio (SSMS) 17.5 or later. Starting SSMS 18.5, a new feature called ‘sensitivity rank’ was added in Data Classification. I will show details about the sensitivity rank in this blog post. I want to thank David Trigano, Program […]
We're on Twitter now with an official account. Please follow @sqlsatofficial to get SQL Saturday news.
Listening to @MsSQLGirl and Barbara Valdez talking about 'Notebooks 101 for SQL People' .
Organized by @DBAVUG .
Did you attend my @AzureDataStudio session for @DBAFun yesterday but wanted a deeper dive on ADS itself? Check this out ... today with an awesome group of presenters... https://twitter.com/AzureSQL/status/1420368451407806464
TODAY on Data Exposed Live, join @AnalyticAnna, @MsSQLGirl,
@SysAdminDrew, @AlanYuSQL, and @VasuBhog for an Azure Data Studio Power Hour 🕘
Tune into #LearnTV:
⏰ 9:00 AM PT
🔗 http://aka.ms/LearnTV
The @AzureDataStudio takeover! #AzureSQL #SQLServer https://twitter.com/azuresql/status/1420368451407806464
TODAY on Data Exposed Live, join @AnalyticAnna, @MsSQLGirl,
@SysAdminDrew, @AlanYuSQL, and @VasuBhog for an Azure Data Studio Power Hour 🕘
Tune into #LearnTV:
⏰ 9:00 AM PT
🔗 http://aka.ms/LearnTV
Do you have correct mindset and knowledge to secure #AzureSQL Database?
Join @Surbhi_Pokharna to hear about 'Applying a... Security Mindset to Lock Down Azure SQL DB'
Thursday, August 5, 2021
6:00 PM to 8:00 PM EDT
https://www.meetup.com/North-Boston-Azure-Cloud-User-Group/events/279719873/?refund_policy=true&rv=ea1_v2&_xtd=gatlbWFpbF9jbGlja9oAJGNlNTY0MmUyLWQyM2MtNGFmMi1iNzZlLTY0NTdlMmI1MTc1Yg&utm_campaign=event-announce&_af=event&_af_eid=279719873&utm_medium=email&response=3&action=rsvp&utm_source=promo
