PASS Summit 2019: Day 1 Keynote – my takeaways
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...
2019-11-07
3 reads
Mala Mahadevan
Geneology with SQL Graph – Part II
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...
2019-10-24
14 reads
Geneology with SQL Graph – I
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...
2019-10-17 (first published: 2019-10-14)
1,192 reads
T-SQL Tuesday: Changing my mind
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...
2019-10-14 (first published: 2019-10-08)
515 reads
Graph – Shortest Path
‘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...
2019-10-08 (first published: 2019-09-22)
751 reads
Simple Graph Queries
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...
2019-10-01 (first published: 2019-09-21)
450 reads
Protected: Vajrasara – an interview with Lashana Lewis – Part 1
There is no excerpt because this is a protected post.
2019-09-02
13 reads
Protected: Vajrasara – An interview with Lashana Lewis – Part 2
There is no excerpt because this is a protected post.
2019-09-02
5 reads
Graph Databases – Introduction
I have been looking into this feature and also into understanding graph data in general. I believe introduction of graph database feature in SQL Server has many advantages –...
2019-08-22 (first published: 2019-08-09)
840 reads
PASS Summit 2019 – spending the time
The session line up for PASS Summit 2019 was announced today...there are so many good sessions to go to..managing time and what we do with our limited time there...
2019-08-08
21 reads
Blogs
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
The Book of Redgate: Don’t be an a**hole
By Steve Jones
This was one of the original values: The facing page has this text: No...
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
I Love Editorials
Comments posted to this topic are about the item I Love Editorials
Line number in error message doesn't match up with line number in code
Hi everyone I have a 1000 plus line query and I am getting an...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers