PinnedRemy UrsemSQL Auditing stops logging data after enabling Microsoft support operationsWhen designing and setting up SQL auditing you might be challenged with finding the right events and getting the configuration right.5 min read·Dec 8, 2022----
Remy UrsemNavigating SQL Server Corruption on Sparse ColumnsExplore a SQL Server corruption case involving sparse columns. Learn the challenges faced, solutions implemented, and key takeaways.4 min read·Feb 21, 2024----
Remy UrsemHow to configure an Azure file share storage key for Log ShippingCombining Azure Files with SQL Server Log Shipping is an easy way to configure a hybrid disaster recovery or migration setup.4 min read·May 20, 2022----
Remy UrsemHow to write performant queries in Spark notebooks fetching data from Synapse SQLLearn how to execute a query directly on your Synapse Dedicated SQL Pool using Spark Notebooks in Azure Synapse Analytics.6 min read·Apr 20, 2022----
Remy UrsemHow to cross-charge shared Reservations based on Azure Cost Management billing dataLearn how to obtain Reservation insights from the Cost Analysis reporting functionality5 min read·Dec 2, 2021----
Remy UrsemHow to use Azure SQL Always Encrypted in your CI/CD pipelineProtecting and encrypting your data is a subject that never left the table. How can we handle Always Encrypted in our development process?3 min read·Oct 12, 2021----
Remy UrsemComparing authentication between Azure SQL and Amazon RDS for SQL ServerA strategic component of the Microsoft Azure ecosystem is SQL Server. As one of the first Platform-as-a-Service (PaaS) products in Azure…4 min read·Sep 21, 2021----