2023-04-29
137 reads
Microsoft
New Cloud Licensing Limits
New licensing rules are coming for using your SQL Server licenses in the cloud.
2022-09-03
189 reads
2022-03-30
117 reads
What's Important to Your Organization
Some organizations see their IT organization as an expense, and not as valuable as it might otherwise be. Steve has a few comments on why this might not be a good idea, or a good place to work.
2021-08-13
278 reads
Power Apps Canvas Apps Examples
In this article we will focus on Power Apps canvas apps which are natively optimized for mobile devices and we will look at potential use cases for canvas apps.
2021-04-15
2021-03-11
113 reads
Microsoft Fights Back
Microsoft fights back against hackers after a recent vulnerability in a management framework.
2021-01-14
222 reads
2020-11-11
105 reads
2020-10-13
163 reads
Compatibility Level Confidence
The database compatibility level ought to provide some protection from database upgrade changes, but do you believe that?
2020-09-21
331 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
setting an ssis param dynamicaly when the sql agent job runs
hi i was hoping for a more elegant way of setting a pkg level...
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...
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