It never hurts to practice the fundamentals and understanding SQL is fundamental to any well-rounded data scientist. Here’s an interesting closeup look at T-SQL, the SQL “dialect” found in SQL Server.

Like any programming language, T-SQL has its share of common bugs and pitfalls, some of which cause incorrect results and others cause performance problems. In many of those cases, there are best practices that can help you avoid getting into trouble. I surveyed fellow Microsoft Data Platform MVPs asking […]

Kirill Gavrylyuk joins Scott Hanselman to discuss new improvements for Azure Cosmos DB SDKs, including the new, idiomatic .NET SDK with friendlier, more intuitive programming model, better testability, better performance, .NET Standard 2.0 support, and now open sourced.     

 

Never miss an episode:

In this course on freeCodeCamp.org, take look at database management basics and SQL using the MySQL RDBMS.

The course is designed for beginners to SQL and database management systems, and will introduce common database management topics. The course looks at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and more.

This video from the Microsoft Developer YouTube channel gives a thorough overview of CosmosDB, a globally distributed multi-model database-as-a-service. It provides NoSQL foundation with comprehensive SLAs on throughput, availability, consistency and latency and exposes data through SQL, MongoDB, Cassandra, Table and Gremlin APIs. Learn how to take advantage of it in your apps today and leverage the economy of scale tomorrow!