Embracing Efficiency: T-SQL in Azure SQL Database and Elastic Pools
In the dynamic world of cloud computing, managing databases effectively is paramount. Microsoft Azure offers two compelling options for this purpose: Azure SQL Database and Azure SQL Elastic Pools. Both…
Migrating SQL Server On-Prem to the Cloud: A Guide to AWS, Azure, and Google Cloud
Taking your on-premises SQL Server databases to the cloud opens a world of benefits such as scalability, flexibility, and often, reduced costs. However, the journey requires meticulous planning and execution….
Read moreA Brief Overview of Migrating Your On-Prem SSRS to Azure Power BI
Ever thought about moving your SQL Server Reporting Services (SSRS) from the comfort of its on-premise setup to the cloud? With Azure and Power BI waving from the horizon, it’s…
Read moreChoosing the Right SQL Solution for Charge-Back in Multi-Tenant Cloud Environments
Navigating multi-tenant cloud SQL services (Azure SQL, Azure SQL on VMs, Aurora PostgreSQL) for fair charge-back. Practical T-SQL examples included.
Read moreAssessing the Impact of AUTO_SHRINK on Azure SQL Databases on SSDs
Using AUTO_SHRINK on SSD-based SQL databases harms performance, causes fragmentation, and strains SSDs unnecessarily. Microsoft advises against it.
Read more
You must be logged in to post a comment.