SQLBits 2024 Recap
Had an absolutely amazing time at SQLBits this year! It was lovely to see all my data friends again and had the opportunity to introduce my husband to everyone...
2024-03-12
28 reads
Blog Posts
A First Look at Redgate’s Subsetter
I have been a proponent of subsetting databases in dev/test for a long time. It took awhile, but as part of the Test Data Manager that Redgate launched at...
2024-03-11 (first published: 2024-02-28)
317 reads
Azure SQL MI License free?
A common setup when leveraging the cloud is to use the cloud for Disaster recovery (DR) purposes, some say it becomes a logical extension of your on-prem / data...
2024-03-11 (first published: 2024-02-27)
444 reads
10 reasons why IT certifications are still important
As someone who has spent over 20 years in the Software/Data Engineering area and has obtained numerous certifications, I can confidently say that certifications are still a valuable asset...
2024-03-08 (first published: 2024-02-23)
446 reads
A New Word, err Phrase: loss of backing
loss of backing– n. an abrupt collapse of trust in yourself – having abandoned a resolution, surrendered to your demons, or squandered an opportunity you swore you’d take seriously...
2024-03-08
27 reads
SQLpassion Live Training about running SQL Server in Microsoft Azure
From April 24 – 25, 2024 I will run a brand-new SQLpassion Live Training about Design, Deploy, and Optimize SQL Server on Microsoft Azure. Unlock the power of Microsoft...
2024-03-08 (first published: 2024-03-04)
325 reads
Book Review: My Effin Life
This is very off topic, but I’ve been a fan of Rush since I was about 12 years old. Their Moving Pictures This is a few thoughts on Geddy...
2024-03-06
142 reads
Foreign Keys in SQL Data Generator
A customer recently asked about using FKs in SQL Data Generator, and I decided to write a short post showing how these work. The Scenario I’ve got a copy...
2024-03-06 (first published: 2024-02-26)
327 reads
How Redgate’s Test Data Manager Can Enhance Automated Testing
A brief overview of the benefits and challenges of automated testing and how Redgate’s Test Data Manager can help. Automated testing uses software tools to execute predefined tests on...
2024-03-06 (first published: 2024-02-26)
160 reads
Adding Git LFS Support – #SQLNewBlogger
I got this message recently while committing some changes: This post shows my work in adding Git LFS support to GitHub. Another post for me that is simple and...
2024-03-04 (first published: 2024-02-21)
179 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
Are luxury packages in Andaman suitable for a honeymoon?
Yes, luxury packages in Andaman are highly popular among honeymooners due to their romantic...
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...
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