This is a session about Azure Automation service and how you can perform some of SQL Agent functionality against Azure SQL Database using runbook. I presented the session to following user groups and events. PASS DBA Virtual Chapter (Asia Pacific Region) on November 15, 2017 PASS DBA Virtual Chapter on February 28, 2018 Boston Azure DataFest […]
Today there was a question submitted in dba.stackexchange.com with the heading “Suppressing non-ANSI warnings in SQLCMD script”. Details here. In summary, this happens when you use a script to create a SQL Agent job and one of the job steps has conditions (under advanced properties) to go to certain steps in case of success or […]
There was a tweet that came last night from Lohit about “need guidance on how to enable a set of jobs on secondary AG as soon as failover happens from primary to secondary AG”. I have implemented a solution for most (I am using “most” literally because I have not done this for all jobs) of […]
DBA team that I worked with manage 170+ SQL Servers. We do not enable notification on any SQL Agent job. We centrally monitor all jobs and send a notification based on the tier (Business-critical). Last night on-call DBA got paged for a job failed in the server we are doing proof of concept. By looking […]
Recently in one of our server row count in MSDB.DBO.SysJobHistory table exceeded 100 Million and looking at job history was slow via SSMS. It was impossible via the GUI. Because we had about 50 jobs that were running frequently (called from a listener mostly once in every 2 to 3 minutes). I was curious if […]
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
