The Evolution of Windows
Today Steve looks back at Windows, and how Windows 10 might be the last version. Perhaps this is the model we'll see with SQL Server in the future.
2020-09-01
271 reads
Microsoft
The Computing Revolution
Steve reflects on some of the ideas of how Microsoft imagines the future of computing.
2020-07-27
144 reads
2020-07-06
142 reads
The Build Book of News
Every year Microsoft has held the Build conference for developers. I've been lucky enough to go a few times, and I was hoping to get the chance to attend again. With the pandemic, the entire event went virtual, and was held across 48 continuous hours. I was slightly disappointed as a few sessions I wanted […]
2020-05-23
108 reads
Is 100% Security Possible?
A security breach at Microsoft is disconcerting, especially when they don't share details.
2020-03-05
290 reads
Azure Sphere
The Azure Sphere project is a great piece of research at Microsoft that might help us data professionals with security.
2019-11-25
212 reads
2019-11-11
347 reads
A Mindset Shift
Microsoft has grown and changed their culture in the last few years, which greatly impresses Steve.
2019-11-01
315 reads
Evergreen SQL Server
Microsoft talks about evergreen SQL, where you never need to patch your database.
2025-05-14 (first published: 2019-07-24)
1,597 reads
DevOps and OSS Can Scale
Microsoft has embraced open source software, and has opened much of their code. They have also proven that DevOps development can scale in this environment.
2019-07-17
207 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
Query compile/runtime issue
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
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 n;See possible answers