Comparing Two Geospatial Series with Python
Learn how to use Python and pandas to compare two series of geospatial data and find the matches.
Email Issues with SQLServerCentral
We are experiencing some email issues with our sender. There are some spam reports for our newsletter, which are causing us issues. If you have any questions, please contact the webmaster@sqlservercentral.com.
Ten tips for building a collaborative DevOps culture
There is more to DevOps than tools and automation. In this article, Robert Sheldon explains how to create a DevOps culture based on collaboration.
Upgrade and Migrate SSRS Report Server and Retain Server Name
In this article we look at how to do a side by side install of SQL Server Reporting Services to minimize downtime for the migration.
Working in a Distributed Fashion
With many of us working in a distributed fashion, Steve wonders if things have changed for the process flow you follow.
Five facts about the SQL Server Tempdb Database
In this article we cover some interesting facts about the SQL Server TempDB database that could be useful to know.
SQL Templates and Code Snippets in SSMS and SQL Prompt
Phil Factor explains the uses and limitations of native SSMS templates and snippets, and then demonstrates the extra versatility that SQL Prompt snippets provide.
Why Doesn't Database Software Help Us?
Databases don't manage themselves, but Steve sees this as an opportunity, not a problem.
How to deploy and execute an SSIS package from the SSISDB catalog
Beginning with SQL Server 2012, SQL Server Integration Services packages can be deployed and executed from a SQL Server database named SSISDB, which serves as a repository for SSIS packages.
Tool Limits
Today Steve asks about the tools you use for your job and if they help or hurt your productivity.
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