SQLintersection Workshop attendees change to URL

Hello All.  I am ensuring that you have access to the downloads. In the slide deck there was a link and it pointed to the file.  You need to add /wp-content/ to the URL before uploads and after dbaduck.com.

That means that the uploads are at https://dbaduck.com/wp-content/uploads/nameoffile.zip

I apologize for having the link in the wrong place.  Please feel free to email me at the email in the slides if you cannot get the file.

#SQLIntersection with DBADuck

In May, I will be at SQLintersection at the Disney World Swan in Orlando, Florida. You can visit the site to see the full lineup of sessions and workshops. I’m going to be presenting three sessions on SQL Server topics and 1 Workshop on PowerShell in SQL: IN DEPTH TEMPORAL TABLES IN SQL 2016 Have you… Continue Reading

sys.dm_db_index_physical_stats Easter Egg

I was reading through documentation on the DMV sys.dm_db_index_physical_stats and found that there are a couple of things you need to be aware of when using this DMV.  First, we know that there are parameters for the DMV. Parameters Database Id Object ID Index Id Partition Id Level of interrogation (DEFAULT, LIMITED, DETAILED, SAMPLED, NULL… Continue Reading