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 […]
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 […]
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 […]
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 […]
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 […]
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
The map on the left is the recall results. The one on the right is the current COVID situation.
2Hey #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
