×

T-SQL Tuesday #150: Is that a Tech Job?

May 10, 2022

I thank Kenneth Fisher (Blog|Twitter) for hosting T-SQL Tuesday #150. The topic for this month is your first technical job(s). I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some of the T-SQL Tuesdays and participated in a few. Thank you, Steve Jones (Blog|Twitter), for coordinating this program. If […]

Azure SQL Database backup history

May 4, 2022

There is a new DMV currently in preview which returns information about backups of Azure SQL databases except for the Hyperscale tier. Microsoft official documentation is here. If you run the example query as-is from the above documentation some of the columns do not make sense. Instead, use this query where I am joining with […]

T-SQL Tuesday #148: Advice on running a user group -Consistency

March 9, 2022

I thank Rie Merritt (Blog|Twitter) for hosting T-SQL Tuesday #148. The topic for this month is Advice on running a user group. I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some of the T-SQL Tuesdays and participated in a few. Thank you, Steve Jones (Blog|Twitter), for coordinating this […]

Azure Synapse SQL Pool Backup

November 2, 2021

Definition Data warehouse snapshot A data warehouse snapshot creates a restore point you can leverage to recover or copy your data warehouse to a previous state. Since a dedicated SQL pool is a distributed system, a data warehouse snapshot consists of many files that are located in Azure storage. Snapshots capture incremental changes from the data stored […]

Azure Data Factory Monitoring Choice?

May 19, 2021

If you are using Azure Data Factory, you can export platform logs and metrics to a log analytics workspace. Sending logs and metrics to a Log Analytics workspace allows you to analyze them with other monitoring data collected by Azure Monitor using powerful log queries and leveraging other Azure Monitor features such as alerts and visualizations. […]



profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook