Explores Microsoft's Resumable Online Index Creation feature in Azure SQL DB, detailing its benefits for managing large databases without downtime.
Announcing four in-depth tech workshops on SQL Server, Git/GitHub, Cassandra, and Microsoft Azure at the Tuga IT 2018 Summer Edition conference.
A guide to using Extended Events (XEvents) for advanced tracing and diagnostics in Azure SQL Database, covering setup and specific use cases.
Columnstore Indexes are now available on the Standard Tier of Azure SQL Database, enabling better compression and performance for data warehousing.
A technical guide on creating multi-source partitioned tables in Azure Analysis Services, combining cold data from Azure Data Lake Store with hot data from Azure SQL Database.
A technical walkthrough implementing Row-Level Security (RLS) in Azure SQL Database using the AdventureWorks sample database.
A technical walkthrough on setting up and testing the Auditing feature in Azure SQL Database, including configuration and reporting.
A technical walkthrough on setting up and using the Dynamic Data Masking feature in Azure SQL Database for on-the-fly data obfuscation.
A guide on connecting to and working with Windows Azure SQL Database directly within the PhpStorm IDE, covering setup, queries, and database management.
