This month’s T-SQL Tuesday is hosted by my dear friend Kevin Kline (b | t) . Kevin’s call is for us to ‘Tell us the story of how attending an IT conference or event resulted in an amazing career or life opportunity.‘ My professional life literally changed for the better since my first PASS Summit, which was many years… Continue reading T-SQL Tuesday 153: The conference that changed everything
I received a great collection of blog posts in response to my T-SQL Tuesday 151 – asking people to write on T-SQL Coding Standards. Rob Farley (t|b) is of the opinion that coding values that help with efficiency are better than rigidly enforced standards, although he as a consultant abides by his customer’s needs in… Continue reading T-SQL Tuesday 151 Round up: Coding Standards
T-SQL Tuesday is the blog party started by Adam Machanic (b|t) over a decade ago and is now maintained by Steve Jones (b|t) on tsqltuesday.com. On the first Tuesday of each month, a blogger hosts the party and suggests a topic. Anyone interested in the topic gets to blog about it. You have one week to… Continue reading T-SQL Tuesday 151 Invite: T-SQL Coding Standards
2021 was a strange year…mid way through a pandemic, enormously depressing on many fronts to me..and yet, it bought with it some unexpected joys. I never imagined, in the wildest of dreams, that I would get a chance to present at a prestigious non-US conference. But this year, I was selected to present at SQLBits,… Continue reading Thrilled to #BITS!
In the last post I wrote about what ScriptDOM is and why it is useful. From this post, I will explain how it can be put to use. What it does when you pass a script to it is to parse it, check if it is free of syntax errors, and build what is called… Continue reading Parsing scripts with ScriptDOM
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