Skip to content

Curious..about data

One data professional's adventures with data..and beyond

  • About
  • Cookie Policy

Category: DBA

DBA

Thrilled to #BITS!

February 9, 2022 diligentdbaLeave a comment

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!

DBA · Scriptdom

Parsing scripts with ScriptDOM

January 27, 2022January 28, 2022 diligentdbaLeave a comment

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

DBA

Crocs and Naps….

July 10, 2021July 10, 2021 diligentdba1 Comment

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….

DBA

Scripting using SMO

June 6, 2021 diligentdbaLeave a comment

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

DBA

Data dictionary script

March 12, 2021March 13, 2021 diligentdba7 Comments

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.

DBA

Old but not gone…

February 22, 2021 diligentdbaLeave a comment

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…

DBA

TSQL Tuesday #134 – Taking a break

January 12, 2021 diligentdba1 Comment

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

DBA

End of an Era – SQL PASS and Lessons learned

December 22, 2020December 22, 2020 diligentdba1 Comment

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

DBA

PASS Summit 2020 – My experience

November 15, 2020November 15, 2020 diligentdbaLeave a comment

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

DBA

T-SQL Tuesday 132: Coping with a pandemic

November 10, 2020 diligentdbaLeave a comment

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

Posts navigation

Older posts

Recent Posts

  • T-SQL Tuesday 150: My first technical job
  • T-SQL Tuesday 148: Finding and keeping a consistent audience, and what works
  • Thrilled to #BITS!
  • Parsing scripts with ScriptDOM
  • T-SQL Tuesday 146: Where should business logic reside?

Recent Comments

Tim Radney (@tradney… on Crocs and Naps….
diligentdba on Data dictionary script
diligentdba on Data dictionary script
Jeff Moden on Data dictionary script
diligentdba on Data dictionary script

Archives

Categories

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

Blogroll

  • Brent Ozar
  • Buck Woody
  • Chris Yates
  • Grant Fritchey
  • Jason Brimhall
  • Jen Stirrup
  • John Morehouse
  • Kevin Kline
  • Kimberly Tripp
  • Mickey Stuewe
  • Paul Randal
  • Wayne Sheffield
Blog at WordPress.com.
Curious..about data
Blog at WordPress.com.
  • Follow Following
    • Curious..about data
    • Already have a WordPress.com account? Log in now.
    • Curious..about data
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...