The 4 Presentations I’m Proudest Of, and What Inspired Them
Take a look at some of Brent Ozars favourite public presentations, and hear the stories of how they came to be.
Clownpocalypse and DR
Today we have a guest editorial as Steve is out of town at the PASS Summit. Grant looks at disasters and being prepared.
SQL Server Synonyms
SQL Server synonyms can be used to permanently alias database objects in the same or another database. In this article, Greg Larsen demonstrates how to use synonyms and the many reasons to consider using them.
Bringing Data Catalog into your CI/CD pipeline
As business rules shift and data structures change, organizations need to be able to maintain and update their data catalog. Discover how you can implement an automated solution using PowerShell and Redgate’s SQL Change Automation.
Orchestrating Azure Databricks Notebooks with Azure Data Factory
Learn how to orchestrate your Databricks notebooks through Azure Data Factory in this article with a step by step walkthrough.
Responding to the Call of the Wild
Phil Factor's manual for taming machines, applications, and other wild beasts.
Career Goals and Inspiration
Steve asks what you might want to achieve or accomplish in your career.
Count the Number of Weekend Days between Two Dates
Handling weekends can be tricky in SQL. This article shows you how to Count the Number of Weekend Days between Two Dates
Dynamic Data Unmasking
The SQL Server 2016 dynamic data masking feature may seem like a great way to obfuscate data for downstream systems like dev and QA. Joe Obbish shows us that the data can be “unmasked” with T-SQL statements, so it’s not secure against anyone who can write their own queries.
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