Have you ever wanted to ensure that keywords in your data are easily searchable? Have you struggled with full-text search? New author Michael Ahmadi brings us an interesting idea for a keyword tracking and searching subsystem based on T-SQL and triggers.
2008-02-21 (first published: 2007-04-09)
12,088 reads
This Friday Steve Jones asks about capital at work and does it affect the way you do business.
2008-02-21
29 reads
This Friday Steve Jones asks about capital at work and does it affect the way you do business.
2008-02-21
29 reads
This Friday Steve Jones asks about capital at work and does it affect the way you do business.
2008-02-21
36 reads
Part two of this article focuses on using the SQL Server Binary data type to store small image files.
2008-02-21
3,478 reads
This is the sixth article in a continuing series, and this installment discusses the establishment and role of a Data Governance Council.
2008-02-21
1,328 reads
SQL Server 2005 has greatly changed the security paradigm for SQL Server DBAs. The sa account still exists, but for many tasks
you can now avoid using it. New author Ken Johnson brings us some ides for properly securing this highly privileged account.
2008-02-20 (first published: 2007-03-14)
16,605 reads
In this article, we are going to explore the new HierarchyID data type. We are going to show how to implement hierarchies in SQL Server 2005 and than how same thing in can be achived in SQL Server 2008 using the HierarchyID data type.
2008-02-20
4,301 reads
By adding XML-based documentation capability to your SQL code, you can automatically extract and format tagged comments into a complete API documentation set for your SQL libraries.
2008-02-20
2,980 reads
2008-02-20
29 reads
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Hey all. I understand if this gets taken down due to the subject matter...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers