×

TSQL Tuesday #93 -Do Not Drive During Interview

August 8, 2017

I thank Kendra Little (b|t) for hosting TSQL Tuesday #93. Topic for this month Interviewing Patterns & Anti-Patterns. What advice do you have for people preparing for or going through an interview?. After initial phone screening I went for in person interview. I was scheduled to meet 5 interviewer. Last person in the list was […]

Extended Event duration Millisecond or Microsecond?

July 23, 2017

There was a question in dba.stackexchange.com titled “module_end extended events duration in microseconds?” that I answered and it was Microsecond in that instance. Later on, I questioned myself if the duration is always in Microseconds for extended events. I found it is a mix of Millisecond, Microsecond and some are unknown meaning famous NULL. I […]

NULL Values in Histogram

May 26, 2017

During my cardinality estimator presentation in DBA virtual group, there was a question asked about NULL values and histograms. I am quoting the question as is “SQL Server include null values in the index. How are statistics handle null values?” I will answer the question in this blog post. For demo purposes, I will be […]

Think Like the Cardinality Estimator

April 26, 2017

This is a session about cardinality estimation, a phase during query optimization. I presented the session to following user groups. Pass DBA Virtual Chapter on April 25, 2017 SQL Saturday Rochester (#619) on April 29, 2017 Rhode Island SQL Server User Group on May 03, 2017 Maine PASS Chapter on May 18, 2017 Seacoast SQL […]

TSQL Tuesday #89 -My Learning Steps to Azure

April 11, 2017

I thank Koen Verbeeck (b|t) for hosting TSQL Tuesday #89. Topic for this month The times they are a-changing inspired by the blog post Will the Cloud Eat My DBA Job? by Kendra Little. I was glad to see this topic was chosen. I clearly remembered reading this blog post and thanking kendra for writing […]



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