A Self-deployable TICK Stack for ingesting data, monitoring and alerting for any service (including SQL Server)
Oh boy, this is a spinoff of my previous post on “How To Use Grafana (On Docker) To Monitor Your Sql Server (Eventually On Docker Too) – Feat.
Read MorePROTIP: Performance Tuning on the cloud will save you money by the hour
Note: I'll be focusing on Azure Cloud and SQL Server, but these considerations are valid for any Cloud/DB Vendor.
Read MoreGet faster performance and lower network usage in SQL Server Loops by avoiding the "DONE Token" overload
FYI: You can get the Notebook for this article on my github and experiment yourself (opens with Azure Data Studio ).
Read MoreRow Level Security Performance Implications
A conversation had me wondering about performance implications in SQL Server RLS feature, specifically on how to mitigate the performance impact;
Read MoreTest: confronting various methods of bulk loading data from a table to another, what's the fastest?
Most of the support request I get involved with can be summarized with the following keywords: “slow” + “datawarehouse” + “ETL” + “Save us” What about thinking about ETL performance before it goes bad?
Read More