Dennes Torres in Blogs T-SQL Tuesday #181: Query Store and its evolution Query Store. This is my choice in relation to “What feature release made you say WOW!”, the subject of this... 09 December 2024 4 min read
Blogs Dennes Torres in Blogs Azure Functions and Managed Identity: More Secrets I wrote about Managed Identity Secrets a few weeks ago, but since that article was published I made new interesting... 23 January 2023 3 min read
Blogs Dennes Torres in Blogs Parameterizing Azure Policy and Ensuring Azure SQL AD Authentication I wrote before about enforcing Azure SQL AD Authentication using Azure Policies in two different ways. First, only auditing if... 27 June 2022 3 min read
Blogs Dennes Torres in Blogs Azure SQL: Enforcing Azure AD Only Authentication Some time ago I wrote a blog about the just released feature to allow only Azure Authentication in Azure SQL... 06 December 2021 5 min read
Blogs Dennes Torres in Blogs Query Store and hints: More Powerful than ever Dennes Torres explains how Query Store hints work in Azure SQL Database and Managed Instance.… 29 November 2021 6 min read
Blogs Dennes Torres in Blogs Dynamic Data Mask is now useful and no one noticed it Dynamic data mask is a very interesting security feature allowing us to mask critical fields such as e-mail, phone number,... 22 November 2021 3 min read
Blogs Dennes Torres in Blogs SQL Elevated Configuration: The fail-safe for maintenance Many years ago, in the company I was working for, one junior DBA started a reindex operation in a SQL... 08 November 2021 3 min read
Blogs Dennes Torres in Blogs Data Factory: Use a SQL Query to create a Data Source When we include a data source inside a data flow it always requests a dataset. The dataset, in turn, requires... 01 November 2021 2 min read
Dennes Torres in Blogs Azure SQL: Extended Events and the use of slash “/” Many DBA skills transfer when moving to the cloud, but you'll have to make some adjustments in many cases. In... 13 September 2021 3 min read
Blogs Dennes Torres in Blogs Azure SQL: Tightening the Security using Integrated Authentication only This new feature was already being expected for a while. Out of the blue, while I was delivering an online... 21 June 2021 5 min read
Blogs Dennes Torres in Blogs Azure SQL and Managed Identity Azure SQL has a close relationship with Azure Storage. Features like Polybase, backups, extended events and more make use of... 01 February 2021 5 min read