Upcoming speaking events in May (Australia)
Are you looking to boost your skills and knowledge in Database DevOps, learn how to transition to the cloud, and work across multiple databases? Join me and fellow speakers/experts...
2024-05-01
17 reads
Blog Posts
Use a slicer to filter a visual based upon a measure in Power BI
Have you ever wanted to filter a visual by selecting a range of values for a measure? You may have found that you cannot populate a slicer with a...
2024-05-01
26 reads
SQL Saturday Atlanta 2024
Hey there happy coders! Last weekend I had the pleasure of speaking at the SQL Saturday Atlanta event in Georgia! It was an awesome time of seeing data friends...
2024-04-30
33 reads
dataMinds Saturday 2024 – Session Materials
It was great being at dataMinds Saturday 2024 this past weekend. A great crowd of data enthusiasts was present to learn from a bunch of local speakers (both old...
2024-04-29
18 reads
Elastic Jobs for Azure SQL DB
I know if you are a SQL Server DBA using Azure SQL DB, you’ve been sorely missing the agent. Enter Elastic Jobs to help you schedule jobs more easily...
2024-04-29 (first published: 2024-04-16)
325 reads
Microsoft Purview new data governance features
Starting last week is a rollout of the public preview of a new and fully reimagined Microsoft Purview data governance solution. Data governance has become so much more important...
2024-04-29 (first published: 2024-04-17)
441 reads
The Redgate Seminar – Brisbane
On Thursday, May 2, we have the Redgate Seminar in Brisbane. I’ll be at there along with fellow Redgate engineers, account executives, Octopus Deploy engineers, fellow Microsoft MVPs, and...
2024-04-29
21 reads
New Pluralsight Course - Certified Kubernetes Administrator - Working With Your Cluster
We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight!
The next course “Certified Kubernetes Administrator: Working With Your Cluster” in the updated series is now...
2024-04-28
44 reads
7 Best Online Advanced SQL Training Courses to Learn in 2024 and Beyond
The world runs on data, and SQL is the key to unlocking its secrets. If you're ready to level up your SQL game, online training is a power move....
2024-04-26 (first published: 2024-04-10)
1,296 reads
A New Word: the standard blues
the standard blues– n. the dispiriting awareness that the twists and turns of your life feel new and profound, but are not unique – marked by the same coming-of-age...
2024-04-26
22 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