×

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

Warning: Non-existent Step Referenced While Creating SQL Agent Job

April 6, 2017

Today there was a question submitted in dba.stackexchange.com with the heading “Suppressing non-ANSI warnings in SQLCMD script”. Details here. In summary, this happens when you use a script to create a SQL Agent job and one of the job steps has conditions (under advanced properties) to go to certain steps in case of success or […]

How to Exclude Read_Only Databases Using sp_MSforeachdb

March 28, 2017

I will explain how you can use sp_MSforeachdb stored procedure against READ_WRITE database only. There are numerous articles on the web about excluding databases using database id or name. Recently I needed a script to run against databases that are part of Always On Availability Groups and in READ_WRITE status. I used the ‘Updateability’ properties […]


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

T - 7 days
@zippy1981
will be talking about: "Git for DBA"
Registration details:
... https://meetup.com/dbavug/events/279220662/

Wednesday, September 22, 2021
Pacific Noon
3 PM EST
7 PM GMT

#Git #GitHub #sourcecontrol
#database #sqlserver

Hey #AzureDataCommunity leaders, the info went out today for our Leader Summit in October. Check your inbox & add an... hour to your calendar that works best for your schedule. We're looking forward to connecting, networking and learning!

#DPS2021 Updates:
Starting now: Sessions by @dbanuggets, @tommartens68, Paul Ou Yang, @feaselkl, @pookamath, @blakhani
... Data+AI Gurukul by @jamesbroome_ , @chanmm
Join us for FREE: https://bit.ly/dps_2021
Thanks for RT
#Azure #analytics #AzureSQL #sql #SQLServer #PowerBI #DPS10

Surbhi Pokharna presents Applying a Security Mindset to Lock Down Azure SQL DB at #PASSDataCommunitySummit Register ... today! @PASSDataSummit #AzureSQL #Azure

Search the list of sessions here: http://ow.ly/NnUq50G2q6r and register for FREE today: http://ow.ly/J3YZ50G2pgu

Load More...
/* (function () { var s = document.createElement('script'); s.type = 'text/javascript'; s.async = true; s.src = 'https://app.termly.io/embed.min.js'; s.id = '4f4146f3-eaa6-4e46-8f46-3fc9f2223b5f'; s.setAttribute("data-name", "termly-embed-banner"); var x = document.getElementsByTagName('script')[0]; x.parentNode.insertBefore(s, x); })(); */