T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests hosted by Brent Ozar. https://www.brentozar.com/archive/2017/01/announcing-t-sql-tuesday-87-sql-server-bugs-enhancement-requests/ I did not want to miss out...
2017-01-10
626 reads
This post is a response to this month's T-SQL Tuesday prompt. T-SQL Tuesday was created by Adam Machanic and is a way for SQL users to share ideas about...
2017-01-10
5 reads
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I...
2017-01-10
436 reads
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I wanted to highlight this one about adding the date...
2017-01-10
6 reads
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I wanted to highlight this one about adding the date...
2017-01-10
8 reads
On the second Tuesday of each month, the SQL Server universe all comes together to blog about a topic. Known...
2017-01-10
397 reads
This month’s T-SQL Tuesday is hosted by Brent Ozar and he’s asked everyone to find interesting bug or enhancement requests in Microsoft Connect related to SQL Server.
The Connect item doesn’t have...
2017-01-10
3 reads
Let’s kick off the new year with a T-SQL Tuesday! This month’s edition is hosted by Brent Ozar:
Announcing T-SQL Tuesday...
2017-01-10
477 reads
Data warehouse projects are among the most visible and expensive initiatives an organization can undertake. Sadly, they are also among...
2017-01-10
1,099 reads
SQL Saturday Vienna 2017 is only just around the corner.
On Friday, January 20, 2017, a lot of local and international...
2017-01-09
404 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers