Opinions, tips, and news orbiting Microsoft
Today, we worked on a service request where our customer needs to know the TLS version that their application are using.
Thanks to Azure SQL Auditing, we have the ability to access highly valuable information for our day-to-day work. We ca… Continue reading Lesson Learned #478: Identifying TLS Version Using Azure SQL Auditing
Frontline managers have gained greater control, on a team-level, over the capabilities offered in Microsoft Shifts.
With the latest releases now available on the Shifts settings page, we have made updates to improve the end-user experience for frontlin… Continue reading Understand Microsoft Shifts settings as an end-user
special thanks to @Ofer_Shezaf for showing me the new function call.
Watchlists
Watchlists are a feature of Microsoft Sentinel that provide great flexibility and useability. They allow for user-defined tables that can be used in KQL q… Continue reading Querying Watchlists
Who Deleted a Blob?It is sometimes useful to know who created/modified/deleted a storage blob. For that information to be recorded in a log the authentication must be done with Azure AD to populate the user information correctly.
There are two set… Continue reading Who Deleted a Blob?
In the realm of SQL Server, certain combinations of commands and functions can lead to unexpected conflicts and errors. A notable example is the conflict between the NEXT VALUE FOR function and the ROWCOUNT setting. This article aims to dissect the nat… Continue reading Lesson Learned #477:NEXT VALUE FOR function cannot be used if ROWCOUNT option has been set
In SQL Server environments, managing session states and transactions is key to ensuring optimal database performance. A particular challenge arises with sessions in a ‘sleeping’ state holding open transactions for extended periods. These sessions, whil… Continue reading Lesson Learned #476:Identifying Sleeping Sessions with Open Transactions in Azure SQL Database
Introduction
In today’s digital age, the influx of user-generated content, especially videos, has been immense. With this surge comes the challenge of ensuring these videos adhere to community standards and do not propagate harmful content. This is whe… Continue reading The Power of Video Moderation of Azure AI Content Safety
In Azure SQL DB is possible to configure alert to receive a notification when failover happens in failover group or geo replica
Basically you need to configure activity log to send data to some destination in this case workspace will be used
Azu… Continue reading QTip: Configure Azure SQL DB to receive alert when failover occurs in failover group or geo replica