Why You Should Vote for My SQLRally Pre-Con
Self-marketing is not my strong suit. I don't feel very comfortable doing it, but Andy Warren (twitter | blog) suggests that we...
100 Years Ago, What Would You Be?
Today we have a guest editorial from Andy Warren asking what you might have done if you lived in the past.
An Example of Test-Driven Development
Developing a database can be an trying experience, and it's ways good to see how someone else builds a design. In this new article, MVP Andy Leonard shows us how to build a database using test-driven development for a weather database.
How to Import, Browse And Export Master Data Services' Data
Learn how to import data to Master Data Services (MDS) using Master Data Manager Portal UI to enter data manually or how to automate the import process by staging data into three different MDS staging tables.
SQL Server Connectivity Survey from Microsoft
A survey is available from the connectivity team at Microsoft that deals with ADO, ODBC, JDBC and more. Take the survey and help determine what is important for SQL Server.
Survey: what is the highest wait on your system?
SQL Server guru Paul Randal is conducting a short survey on wait states. Add your vote to the tally.
Worldwide Online TechDay/2010
Organized by Microsoft Brazilian Technical Community and relying on renowned international speakers, Worldwide Online TechDay/2010 promises to be the biggest technological online event ever seen. Oct 30, 2010
Protect the Excel files generated by SSIS package-Part I
It is not only the data within the database that requires protection but any report generated using SQL Server needs to be protected before being mailed
The Growth of Professional Development
Steve Jones talks about the more formal effort that it seems many people are placing to grow their careers.
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