Choosing the right data platform is not an easy task. Warner Chaves compares the capabilities of the big three Database as a Service (DBaaS) offerings, Microsoft’s Cosmos DB, Google’s Cloud Spanner, and Amazon’s DynamoDB, to help you make the right choice for your application.
The DMV are very effective and important to administer ASDWH. In this article we will show some important DMVs.
Often we are encouraged to learn the latest things, but sometimes the old stuff is worth knowing too.
Brent demos a single query plan that asks for 2 identical indexes on the same table.
Shrink SQL Server databases quickly and with virtually no contention.
Kathi Kellenberger wonders what's keeping your business from upgrading.
Ameena Lalani looks at cascading updates and deletes when using temporal tables in SQL Server.
Learn how you can get the userid of someone connected to Reporting Services and use that information to determine if they can view the report.
Many technical people use Virtual Machines to build their own lab or test environment. Today Steve Jones asks how you've built your setup.
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers