Skip to content

Curious..about data

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

  • About
  • Cookie Policy

Author: diligentdba

My name is Mala, I am a DBA on SQL Server for the past 15 years..and an active member of the PASS community. Aside from my profession i love to read, write, paint,travel and play practical jokes.
DBA

T-SQL Tuesday #121: Gifts received for this year

December 3, 2019December 3, 2019 diligentdbaLeave a comment

It is December again. 2019 has gone by in a flash. I have the honor of hosting the last TSQL Tuesday blog party of the year. This monthly blog party started by SQL Guru Adam Machanic since 2009 has completed 121 months this year. I am the lucky host of event #121. If you are… Continue reading T-SQL Tuesday #121: Gifts received for this year

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 diligentdbaLeave a 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

Posts navigation

Older posts

Recent Posts

  • T-SQL Tuesday #121: Gifts received for this year
  • PASS Summit 2019 Takeaways
  • PASS Summit 2019: Day 1 Keynote – my takeaways
  • Geneology with SQL Graph – Part II
  • Geneology with SQL Graph – I

Recent Comments

Simple Graph Queries… on Creating Graph tables
diligentdba on Graph Data – Basic …
Will on Graph Data – Basic …
pianorayk on PASS Summit 2019 – Getti…
T-SQL Tuesday 109: I… on T-SQL Tuesday 109: To influenc…

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
Create a free website or blog at WordPress.com.
Curious..about data
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
Cancel