PinnedRemy UrsemCross-database queries on Azure PostgreSQL Flexible Server with strict network requirementsThis short article discusses how to setup Foreign Data Wrapper for cross-database queries with low network requirements.Jun 5Jun 5
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.Feb 21Feb 21
Remy 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.Dec 8, 2022Dec 8, 2022
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.May 20, 2022May 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.Apr 20, 2022Apr 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 functionalityDec 2, 2021Dec 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?Oct 12, 2021Oct 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…Sep 21, 2021Sep 21, 2021