Skip to content

Curious..about data

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

  • About
  • Cookie Policy

Category: DBA

DBA

T-SQL Tuesday 123: Life Hacks to make your day easier

February 11, 2020February 11, 2020 diligentdba2 Comments

This month’s T-SQL Tuesday is hosted by Jess Pomfret. Jess’s theme is ‘Life Hacks to make your day easier’. She talks of some things we do to make life simpler/easier. Two of mine are as below.1 Before I accepted the current gig I am at – I worked several years in telecommuting positions. I found… Continue reading T-SQL Tuesday 123: Life Hacks to make your day easier

DBA

T-SQL Tuesday #122: Being authentic

January 14, 2020January 14, 2020 diligentdbaLeave a comment

This month’s T-SQL Tuesday is hosted by Jon Shaulis – the topic is an evergreen one, dealing with Imposter Syndrome. I learned of this word via Mindy Curnett a.k.a @sqlgirl in one of her presentations. I was aware of it in a different way for a long time. Trauma victims know what it is better… Continue reading T-SQL Tuesday #122: Being authentic

DBA

PASS Summit 2019 Takeaways

November 13, 2019 diligentdbaLeave a comment

I attended my 16th PASS Summit this November 6th, 2019 at Seattle. It was a wonderful week of learning and networking. Below are my takeaways for key days. The keynotes by Rohan Kumar from Microsoft on wednesday, and Tarah Wheeler, Cyber Security Expert on Thursday were not ‘among the best’, they were ‘THE BEST’ i’ve… Continue reading PASS Summit 2019 Takeaways

DBA

PASS Summit 2019: Day 1 Keynote – my takeaways

November 7, 2019November 7, 2019 diligentdbaLeave a comment

I’ve been at the bloggers table for two years now. I felt honored to be selected this year too. The day has started a bit differently – bloggers were given an overview of what to expect from the board and staff of PASS. It was a very different and great move, in my opinion. It… Continue reading PASS Summit 2019: Day 1 Keynote – my takeaways

DBA

Geneology with SQL Graph – Part II

October 24, 2019 diligentdbaLeave a comment

In the previous post I explored a query on how to construct a basic family tree with sql graph – including table set up and queries. In this post am going to explain how to query this to get relationships and some clues on DNA/ethnic mix.1 Relationships: We can use the ‘shortest path’ clause to… Continue reading Geneology with SQL Graph – Part II

DBA

Geneology with SQL Graph – I

October 14, 2019 diligentdba1 Comment

I have been working a lot of SQL Graph related queries and applications of the graph data concept to the extent possible within SQL Server’s graph capabilities. Genealogy, or querying family trees is an important graph data application. A lot of us may not have work related applications that are genealogy related, necessarily. But conceptually,… Continue reading Geneology with SQL Graph – I

DBA

T-SQL Tuesday: Changing my mind

October 8, 2019 diligentdbaLeave a comment

This month’s T-SQL Tuesday is hosted by my friend across the pond – Alex Yates. Alex has a fantastic topic for us to blog about – he asks us to talk about why we changed our mind, on anything related to our careers. What was our original opinion, why we believed that, and what we… Continue reading T-SQL Tuesday: Changing my mind

DBA

Graph – Shortest Path

September 22, 2019 diligentdbaLeave a comment

‘Shortest path’ is by far the most feature of SQL Graph for now. What does this even mean? ‘Shortest path’ is the term accorded to the shortest distance between any two points, referred to as nodes in graph databases. The algorithm that helps you find the shortest distance between node A and node B is… Continue reading Graph – Shortest Path

DBA

Simple Graph Queries

September 21, 2019September 30, 2019 diligentdbaLeave a comment

In this post we saw how to create some graph tables with data. In this I will explore simple queries off of this data and how they compare with their relational counterparts. The main goal behind a graph design is to help you answer queries – so what are the questions you’d ask of a… Continue reading Simple Graph Queries

DBA

Creating Graph tables

September 9, 2019September 20, 2019 diligentdba1 Comment

In the previous post on this we saw what is a basic graph data structure, and the layout of an example – a movie database with it. In this I am going to explain how to convert that design into graph tables. The SQL Server graph architecture is explained really well here. I already have… Continue reading Creating Graph tables

Posts navigation

Older posts
Newer posts

Recent Posts

  • Old but not gone…
  • TSQL Tuesday #134 – Taking a break
  • End of an Era – SQL PASS and Lessons learned
  • PASS Summit 2020 – My experience
  • T-SQL Tuesday 132: Coping with a pandemic

Recent Comments

Kendra Little on PASS – Meanderings
diligentdba on T-SQL Tuesday 123: Life Hacks…
Tim Harkin on T-SQL Tuesday 123: Life Hacks…
T-SQL Tuesday #121:… on T-SQL Tuesday 121 – Gift…
T-SQL Tuesday #121:… on T-SQL Tuesday #121: Gifts rece…

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

 
Loading Comments...
Comment
    ×