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

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.

While I was at UVA presenting at Datapalooza, Andy was at PASS 2018 recording DataPoints for DataDriven.tv along with roving reporter Tim McAliley.

Here’s a round up of their stuff.

SQl Server Managed Instance

PASS 2018 is this week in Seattle, Washington. Andy is on site and he even has a booth for Enterprise DNA! Rumor has it that there’s even a Data Driven logo on the booth! :)We are also excited to have Timothy McAliley as our very first “roving reporter” covering events and happenings all around the conference. Be sure to like us on Facebook to stay up to date and have access to all the bloopers we make while recording DataPoints!

Press the play button below to listen here or visit the show page at DataDriven.tv

Andy at Day 2 Keynote

Andy is at PASS 2018 waiting for the Day 2 Keynote to start.

Press the play button below to listen here or visit the show page at DataDriven.tv

Tim on PASS 2018’s Last Day

In this DataPoint, roving reporter Tim McAliley explains what he’s been up to on the last day of PASS 2018.

Press the play button below to listen here or visit the show page at DataDriven.tv

Andy on PASS 2018’s Last Day

Andy catches up with what he’s been up to at the PASS 2019 Summit, SQL Server 2019, and driving late at night.

Press the play button below to listen here or visit the show page at DataDriven.tv

 

Andy is at the inaugural Atlanta Azure Data Fest and, while talking to organizer Stu Ainsworth, a who’s who of Atlanta SQL community folks, including former guest Julie Smith, drop by and say hello. Press the play button below to listen here or visit the show page at DataDriven.tv

He also bumped into former guest, Joel Cochran. Press the play button below to listen here or visit the show page at DataDriven.tv

 

Veljko Vasic explains how Azure SQL Database uses built-in intelligence to continuously monitors database usage so that it can detect disruptive events that cause poor performance.

Once detected, a detailed analysis is performed generating a diagnostic log with an intelligent assessment of the issue, which consists of a root cause analysis of the database performance issue and recommendations for performance improvements where possible (i.e., intelligent insights).

For more information, see: