March/April 2006 Edition of SQL Server Standard Available
The March/April 2006 edition of SQL Server Standard magazine is now
available. This issue focuses on Transact-SQL for SQL Server 2005.
Though...
2006-04-03
1,509 reads
Blog Posts
12-inch grass stem?
Those of us in technology are very, very used to automated systems,
batch jobs, etc., all which run without human interaction...
2006-03-29
1,355 reads
Internet Explorer Vulnerability
If you're using Internet Explorer, be advised Microsoft has released a
security advisory for Internet Explorer. This would allow an attacker
to...
2006-03-28
1,560 reads
RegCreateKeyEX() error
I just began migrating SQL Servers (2000) to Windows 2003 from Windows 2000 a few months ago. In the past, I...
2006-03-27
2,934 reads
Is Documentation Dying?
The BOL for SQL Server 2005 has been interesting to read. On one hand there is a more comprehensive approach...
2006-03-24
1,514 reads
Blue Hat
Microsoft had their Blue Hat security conference recently, inviting hackers to take their shots at the Microsoft products. Mostly security...
2006-03-16
1,556 reads
Rights within the database
This is a follow-on to my post What are the actual rights?
First and foremost, I want to include membership in...
2006-03-14
1,418 reads
What are the actual rights?
One of the things I've started to work on are some scripts to quickly
be able to pull what a user's...
2006-03-14
1,447 reads
First Impressions of Professional SQL Server 2005 Integration Services
I received a copy of Professional SQL Server 2005 Integration Services
a few weeks back from Kathi. Because of illness and...
2006-03-13
1,483 reads
Tool Updates
Catching up on recent updates for tools I've looked at and/or recommended.
SQL Server Tools:
PromptSQL is now up to version 1.4....
2006-03-13
1,567 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
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