New Job -> Week 1 -> What Tools Do You Need?
I changed to a new job and started it this week. Before I started, I thought of all the things I thought I would want to do when I...
2023-04-05 (first published: 2023-03-17)
422 reads
Blog Posts
SQL Server Quickie #45 – SQL Server Availability Groups
Today I have uploaded SQL Server Quickie #45 to YouTube. This time I’m talking about SQL Server Availability Groups.
2023-04-05 (first published: 2023-03-21)
236 reads
WIT Women Speakers Survey
There is a survey from the WIT group for female speakers. If you are a woman and speak in front of groups, or used to, please fill it out....
2023-04-05
42 reads
Tales From The Field Weekly Wrap Up for the Week of 03-27-2023 & MegaCON
Zach's 1st MegaCon 2011 Hello Dear Reader! This past week is a blur. It was a tough week at work. That sentence is an understatement, but its really all I...
2023-04-04
32 reads
Data Ceili 2023 – Schedule and Registration
Today we have announced the schedule for Data Céilí 2023 and have opened registration! We have two days of great sessions for you, the 8th of June will have...
2023-04-03
24 reads
Goal Progress for March 2023
The grade for March is also D. Details below, but just not making a lot of progress in these areas. In fact, I find myself not motivated to work...
2023-04-03
15 reads
Is Cataloging Your Data Important?
Data continues to be the lifeline for companies across the globe. As maturity levels continue to grow across companies, one aspect that sometimes needs to be checked is cataloging...
2023-04-03 (first published: 2023-03-20)
264 reads
KQL Series – some DevOps things: Provisioning using Powershell
If you have read any of my last few posts on provisioning Azure Data Explorer then you will probably be wondering….. Will he write about Powershell? Ok, I will....
2023-04-03 (first published: 2023-03-20)
215 reads
New Job -> Week 3 -> Creating Alerts
This is part of a series of new job blog posts. You can find them all here. The main goal for week 3: setup much needed alerts on DTU...
2023-03-31 (first published: 2023-03-30)
185 reads
SQL Bits 2023 Recap
I had an amazing time adventuring to Wales with other members of the data community last week! It was my first international conference, and I had heard so many...
2023-03-31 (first published: 2023-03-23)
254 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