July 25, 2020
View Event: Think like the Cardinality Estimator SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates bases on the statistics as to how many rows flow from one query plan iterator to the next. Knowing how CE generates these numbers will enable you to write better TSQL code […]
July 25, 2020
View Event: Need to Monitor Any Azure Resource? Must Learn Kusto Query Language Kusto is a service for storing and running interactive analytics over Big Data, easy to query using Kusto Query Language (KQL). As we make progress in our migration to the cloud, we are learning new ways to monitor and alert on resources and […]
July 14, 2020
View Event: Think Like The Cardinality Estimator SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates based on the statistics as to how many rows flow from one query plan iterator to the next. Knowing how CE generates these numbers will enable you to write better TSQL code […]
July 2, 2020
View Event: Azure SQL Database – Where is my SQL Agent? You migrate your on premise SQL Database to cloud, taking advantage of PaaS offering of Azure SQL Database. You heard the promise of spinning up databases on demand and being able to scale up resources during high peak and scale down when not in […]
July 14, 2020
View Event: Need to Monitor Any Azure Resource? Must Learn Kusto Query Language Kusto is a service for storing and running interactive analytics over Big Data. Kusto was designed from scratch to be a “big data” repository for Azure and easy to query using Kusto Query Language (KQL). As we make progress in our migration […]