Life is Like a Manure Spreader
Things on the ranch inspire Steve Jones in the rest of his life. He's one you might not have thought about.
Life is Like a Manure Spreader
Things on the ranch inspire Steve Jones in the rest of his life. He's one you might not have thought about.
Life is Like a Manure Spreader
Things on the ranch inspire Steve Jones in the rest of his life. He's one you might not have thought about.
Dead LINQ - Database Weekly (Nov 3, 2008)
Steve Jones comments on a few pieces of interesting SQL Server news this week, including Service Pack 3.
Dead LINQ - Database Weekly (Nov 3, 2008)
Steve Jones comments on a few pieces of interesting SQL Server news this week.
Dead LINQ - Database Weekly (Nov 3, 2008)
Steve Jones comments on a few pieces of interesting SQL Server news this week.
Happy Halloween 2008!
Steve Jones is taking a break on this fine holiday, enjoy a few bloopers before you head out with the kids for trick-or-treating.
A Halloween Tale
A while back, in a Simple-Talk editorial meeting, someone bet Phil that he couldn't come up with a Halloween story. To our surprise he said he could, as long as he didn't have to keep to the strict literal truth.
Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet
This paper is an introduction to Earth-oriented coordinate systems, projections, models, and mapping. While not specific to any technology, this information provides valuable background for those who will use spatial data in SQL Server.
SQL Server 2008: The New Data Types
Brad continues his helicopter-level view of the most important new features of SQL Server 2008 with a look at the new data types, their use and their significance.
Blogs
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
Forums
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers