Fundamentals

Azure SQL SQL Server

Storage 101 for Azure SQL and SQL Server Engineers

Learn how storage impacts the performance of your database solution. In this episode with MVP Argenis Fernandez, go over the basics of I/O, what the different access patterns are for the database engine and how to tell when there is an issue with underlying storage for your database. Resources: Argenis’ blog on IO Block Size […]

Read More
AI Future

Elon Musk on Artificial Intelligence

This mini documentary takes a look at Elon Musk and his thoughts on artificial intelligence. Some interesting thoughts to consider.

Read More
T-SQL bugs, pitfalls, and best practices – determinism
Data

T-SQL Bugs, Pitfalls, and Best Practices – determinism

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. […]

Read More