June 24, 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 […]
June 11, 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 […]
June 4, 2020
View Event: Azure SQL Database – Where is my SQL Agent? You migrate your on-premise SQL Database to cloud, taking advantage of the 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 […]
June 1, 2020
As a member of the leadership team of the New England SQL Server User Group (NESQL), my primary responsibility is to schedule speakers ahead of time. With the current pandemic, I am struggling to formulate my email to potential speakers for the year 2020-21. Do I ask them to commit to in-person, virtual, or for […]
June 17, 2020
View Event: Azure SQL Database – Where is my SQL Agent? You migrate your on-premise SQL Database to cloud, taking advantage of the 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 use. […]