I decided to resume tech blogging after a long break and this tsql-tuesday came in handy. This month’s blog part is hosted by John McCormack (B|T). He would like us to blog about handy scripts. I use Query Store a lot where I work – and I’d like to share queries I use on Query… Continue reading TSQL-Tuesday 143: Short Code Examples
I was planning a blog post for a TSQL2sday..instead would up writing an obituary blog post for a dear friend who passed on yesterday. Brian Moran was among the older members of the community. I was introduced to him by a mutual friend at a SQL saturday many years ago. I recognized him instantly as… Continue reading Crocs and Naps….
I will be delivering a lightning talk at DataMinutes on June 7th on this topic. I thought it would help to write a synopsis of what am going to talking of on my blog post. SMO – essentially stands for SQL Server Management Objects…this is a .net based scripting model Microsoft created to perform several… Continue reading Scripting using SMO
I restarted speaking with New Stars of Data today – I gave a talk on Database documentation. Below is the script I created to pull metadata into an excel file if you need it. Thank you Mladen Prajdic(t) for being the original inspiration for this.
I am part of a weekly talk show we run at the TriPASS user group, called ‘Shop Talk’. Shop Talk was the brainchild of Kevin Feasel, our key user group lead..we meet on a bi weekly basis and discuss random tech topics related to sql server. Some of these are questions from our audience, and… Continue reading Old but not gone…
This month’s TSQL Tuesday invite is from James McGillivray – he asks people to write about what they were/are doing to take a break during this crisis ridden time we are in.Breaks are very important – it is very easy to drive ourselves deeper into work when we are working from home. I personally still… Continue reading TSQL Tuesday #134 – Taking a break
Most of my blog is filled with posts related to PASS in some way. Events, various volunteering opportunities, keynote blogging, this or that…With the demise of the organization, I wanted to write one final post but wondered what it could be..I could write about what I think caused it go down, but that horse has… Continue reading End of an Era – SQL PASS and Lessons learned
This was the first year in 16 years for me that there has been a fall season without the PASS Summit to go to. Every year, during the fall, it has been a soul sustaining practice to pack up and head to the summit (typically, Seattle) and spend a week with friends – learning, sharing… Continue reading PASS Summit 2020 – My experience
This month’s T-SQL Tuesday is hosted by my good friend and data platform MVP Taiob Ali. Taiob’s challenge is very relevant to current season – he asks to blog about how we are coping with what life has dealt us during this time. I really wondered where to start on this..because this year has stuck… Continue reading T-SQL Tuesday 132: Coping with a pandemic
This month’s TSQL2sday is hosted by one of my favorite presenters, Rob Volk. His challenge for us is to use analogies and explain a database concept like you would to a five year old. I love this idea..because so many of us techies have challenges with getting down-to-earth and simple when it comes to explaining… Continue reading T-SQL Tuesday 131: Data Analogies, or: Explain Databases Like I’m Five!