Creating a Simple Graph in RedisGraph
I delivered a session on graph databases, and in it I used RedisGraph to show how you can work with graph data on that platform. This blog shows a...
2023-04-10
68 reads
Blog Posts
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find them all here. Last week was the first week of the rest of my life....
2023-04-10 (first published: 2023-03-24)
553 reads
Tales From The Field Weekly Wrap Up for the Week of 04-03-2023 & Easter
Hello Dear Reader! Hopefully you had a great weekend. This weekend was filled with gatherings. On Saturday we gathered with friends and had a really nice Game Night.... where...
2023-04-10
15 reads
Why i use a smaller docker image part I
What is Docker? Docker is a famous platform for building, shipping, and running container applications. What are containers? Containers are a way to package software in a portable and...
2023-04-10 (first published: 2023-03-27)
244 reads
Converting Types in C#
I am not a great software developer. I’m OK, and I do know how to use Google and Stack Overflow well. Maybe my best skill is wording searches well?...
2023-04-07 (first published: 2023-03-22)
273 reads
Dropping Career Goals for Q2
I set goals at the beginning of 2023 for Q1. I didn’t do well, as my evaluation earlier this week has a D for my efforts. I’m re-evaluating things,...
2023-04-07
17 reads
KQL Series – KQL the next query language you need to learn – a video from Data Exposed
I love KQL so much I even made a video and if you compare it to my last blog post – yeah my hair has changed a bit…And my...
2023-04-07 (first published: 2023-03-20)
441 reads
Star Schema Merchandising Available
Those of you who follow me on social media (twitter | LinkedIn | mastadon) or who read my blog here, might be familiar with my catchphrase “STAR SCHEMA ALL...
2023-04-06
97 reads
EightKB Topics
Hello all, I’ve been speaking to various people about EightKB and there does seem to be a misunderstanding out there about the topics of submissions that we are looking...
2023-04-05
24 reads
If You Can't Clone Yourself, Be Professional
This is going to be a rant. I'm just a bit frustrated. When organizers work hard to assemble an event, and speakers submit to speak, we...
2023-04-05
1 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers