Contract or Perm
If you are accepting a DBA position, does it make sense to work as a contractor or permanent employee?
SQL Saturday
The SQL Server community has a new event to attend in local markets. The Orlando Users Group put on SQL Saturday recently and here's a short look at how this event came about, and how you might run your own event.
SSW Tech Breakfast - SharePoint (MOSS)
If you are near Sydney, Australia, Marten Ataalla will provide an introduction to Microsoft SharePoint 2007 with the aim of evaluating its effectiveness for Enterprise Content Management (ECM).
XML Workshop XI - Default Namespaces
The eleventh installment of the XML Workshop continues looking at namespaces. This time Jacob Sebastian examines default namespaces and how they impact your XML processing.
Featured Blog: CHECKDB From Every Angle: Can CHECKDB repair everything?
What can't be fixed by CHECKDB? Read this great entry from the former SQL Server Storage Engine lead.
Beginning Database Design - Spot the Flaws
A new series by Steve Jones that tackles a basic design of a few tables. Read the scenario, look over this design, and see if you can find the problems.
.NET Building Blocks: Build a Configurable Database Credential Selector
This handy control gives you everything you need to control how users input usernames, passwords, select servers, and choose connection types.
Enterprise Architecture: Connect-Dots for Adults, Part 2
This article, the second in a series, discusses what items could be contained in the enterprise architecture and touches briefly on how to organize the objects.
Monitoring on a Budget
Have you ever been asked for information you couldn't provide because you didn't have an historical monitoring tool? Try this
Open Enrollment
It's the time of year where employment benefits renew for many US employees. Steve Jones talks about how much your company should care about your health.
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