×

TSQL2sday #94 Get-DbaRegisteredServerName | Power of dbatools

September 12, 2017

I thank Rob Sewell (b|t) for hosting TSQL Tuesday #94. Topic for this month Let’s get all Posh – What are you going to automate today?. If you are a database professional most likely you heard of dbatools by this time. Dbatools is a free PowerShell module with over 200 SQL server administration, best practice […]

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 […]

My Stackexchange Profile

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

Preparing for my presentation to #Vermont SQL User Group on Tuesday.
https://www.meetup.com/VTCode/events/267938985/

... http://sqlworldwide.com/vermont-sql-server-user-group/

@sqlpass
#MVPbuzz

Load More...