SQL

Data

Redis in 100 Seconds

Redis is an extremely fast in-memory database often used as a cache. It has evolved into a multi-model database with support for graphs, JSON documents, full-text search, and more. Fireship explains it all in 100 seconds.

Read More
Developer

What is the Fastest Computer Language?

A constant source of debate for computer geeks, retired Microsoft engineer Dave Plummer takes us on a guided tour of 45 different computer languages and drag races each against one another using a prime sieve benchmark.

Read More
Azure SQL SQL Server

A Tour of SQL Workshops

Join Anna Hoffman and Buck Woody as they take a tour of the incredible learning resource the Microsoft Engineering team has put together. From labs to full hands-on workshops and much more, you’ll find a wealth of high-quality, free-cost training. You’ll also learn about many of the other valuable references and assets you can find […]

Read More
Data Security

Basics of SQL Injection – Penetration Testing for Ethical Hackers

In case you’re wondering why I am posting a lot of security related content today, the reason is simple: it impacts everyone. If you’re a data engineer and think that you are immune to security concerns, think again. SQL injection is a common hacking technique used to retrieve or destroy data from a database without […]

Read More
Azure SQL

Azure SQL from the Edge to the Cloud

SQL Server started as a departmental database engine. It is now a modern data platform and a force in the industry. In this episode of Data Exposed with Bob Ward, learn how Microsoft is innovating SQL Server from IOT edge devices to your data center to the Azure cloud. Resources: SQL Server and Azure SQL […]

Read More
Databricks Spark

Spark SQL Beyond the Official Documentation

This video with David Vrba focuses on some internal features of Spark SQL which are not well described in official documentation with a strong emphasis on explaining these features on some basic examples while sharing some performance tips along the way.

Read More
Databricks

Delta Lakehouse Data Profiler and SQL Analytics Demo

Coming from a data warehousing and BI background, Franco Patano wanted to have a catalogue of the Lakehouse, including schema and profiling statistics. He created the Lakehouse Data Profiler notebook using Python and SQL to analyze the data and generate schema and statistics tables. He then uses the new SQL Analytics product from Databricks to […]

Read More
Data

Database Design Course for Beginners

This database design course by Caleb Curry will help you understand database concepts and give you a deeper grasp of database design. Contents / Time stamps: ⌨️ (0:00:00) Introduction ⌨️ (0:03:12) What is a Database? ⌨️ (0:11:04) What is a Relational Database? ⌨️ (0:23:42) RDBMS ⌨️ (0:37:32) Introduction to SQL ⌨️ (0:44:01) Naming Conventions ⌨️ […]

Read More
Azure Data

Build SQL Database Projects Easily in Azure Data Studio

In this episode with Drew Skwiers-Koballa, you will be introduced to a new experience for database development with the SQL Database Projects extension for Azure Data Studio.  Whether you are familiar with SQL Server Data Tools (SSDT) or new to SQL projects, you can start editing and building SQL projects in Azure Data Studio on […]

Read More