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
I am glad to be contributing to the 150th blog party started by Adam Machanic and has helped so many get our blogs going. This month’s T-SQL Tuesday is hosted by a dear friend Ken Fisher – Ken wants us to write on our first technical job. The year was 1987. I was an engineering… Continue reading T-SQL Tuesday 150: My first technical job
This months’ T-SQL Tuesday blog party is hosted by Rie Merrit (t|b) as part of Azure Community Group lead. Her call is to pick one or two things that work for running a user group and blog on it. I am co lead at two user groups – the Triangle SQL Server User Group and… Continue reading T-SQL Tuesday 148: Finding and keeping a consistent audience, and what works
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 am trying to get started on blogging again this year…T-SQL Tuesday came in handy with a great topic. This month’s host is Andy Yun(t |b). Andy’s challenge for us is to write about some notion ‘something you’ve learned, that subsequently changed your opinion/viewpoint/etc. on something. ‘ There are many things on which I’ve changed my… Continue reading T-SQL Tuesday 146: Where should business logic reside?
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