Videos

SQL Server 2017 Adaptive QP

7 days ago
This week’s Data Exposed show welcomes Joe Sack into the Channel 9 studio. Joe is a Principal PM on the SQL Server team, and is in the Channel 9 studios today to show us the awesome Adaptive Query Processor technology, the ability of the database to adapt based on customer characteristics in real-time conditions. Joe […]

SQL Server 2017 Built-in Diagnostics

1 week ago
Bob Ward and Parikshit Savjani (Parik) are in the Data Exposed Channel 9 studio today to talk about and show off the best built-in diagnostics in the industry. It’s Bob Ward, so of course we’re talking about SQL Server. And in this episode, we’re talking about SQL Server 2017. [00:15] – Introductions, fun, and what […]

Redis Tutorial for Beginners 9 – Redis Sets

2 weeks ago
SADD key member [member …] Add one or more members to a set SCARD key Get the number of members in a set SDIFF key [key …] Subtract multiple sets SDIFFSTORE destination key [key …] Subtract multiple sets and store the resulting set in a key SINTER key [key …] Intersect multiple sets SINTERSTORE destination […]

Connecting On-premises Hadoop to Azure Data Lake Store

2 weeks ago
This week’s Data Exposed show welcomes Cathy Palmer into the Channel 9 studio to show how to connect an on-premises Hadoop cluster to Azure Data Lake Store in 3 easy steps! [01:38] – Azure Data Lake Store at a Glance [04:50] – Find out More… [06:00] – Demo Overview and DEMO!

Redis Tutorial for Beginners 8 – Redis Lists

3 weeks ago
BLPOP key [key …] timeout Remove and get the first element in a list, or block until one is available BRPOP key [key …] timeout Remove and get the last element in a list, or block until one is available BRPOPLPUSH source destination timeout Pop a value from a list, push it to another list […]

Microsoft Excel: Basics and beyond (productivity demo)

3 weeks ago
Brian Moring, productivity trainer with Microsoft IT Showcase, demonstrates how to use Excel for collaboration and increased productivity in the cloud. Find out how to create an Excel workbook, save it to OneDrive, use formulas and functions, and visualize your data in charts and graphs. See how to insert PivotTables and learn how to access […]

SQL Unplugged – May 2017 Edition – Live at BUILD

3 weeks ago
Rohan Kumar and Scott Klein and SQL Unplugged are LIVE from //BUILD. Great topics that were talked about and announced at //BUILD are discussed with some great audience questions! This show is your avenue for chatting with the individuals who own the relational database at Microsoft. Tune in each month as Scott and Rohan answer […]

SQL Unplugged – July 2017 Edition

3 weeks ago
Rohan Kumar and Scott Klein are back LIVE on SQL Unplugged. Great topics (including SQL Server 2017, SQL DW, Built-in AI, Postgress/MySQL, and more!) and some great audience questions! This show is your avenue for chatting with the individuals who own the relational database at Microsoft. Tune in each month as Scott and Rohan answer […]

Azure SQL Database Elastic Pools and Elastic Jobs

3 weeks ago
This week’s episode of Data Exposed Scott welcomes two awesome individuals, Torsten Grabs and Morgan Oslake (Principal PM in the SQL product group), to talk about the great topic of Azure SQL Database Elastic Pools and Elastic Jobs. We also have a surprise guest on the show, but we’ll get to that shortly. 😉 [00:32] – […]

Redis Tutorial for Beginners 7 – Redis Hashes

4 weeks ago
Redis Hashes are maps between string fields and string values, so they are the perfect data type to represent objects . HDEL key field [field …] Delete one or more hash fields HEXISTS key field Determine if a hash field exists HGET key field Get the value of a hash field HGETALL key Get all […]

Redis Tutorial for Beginners 6 – more commands (SETEX, SETNX, INCR, DECR, MSET…)

4 weeks ago
SETEX key seconds value Sets the value with the expiry of a key SETNX key value Sets the value of a key, only if the key does not exist SETRANGE key offset value Overwrites the part of a string at the key starting at the specified offset STRLEN key Gets the length of the value […]

Redis Tutorial for Beginners 5 – Redis strings commands

4 weeks ago
1 SET key value This command sets the value at the specified key. 2 GET key Gets the value of a key. 3 DEL key This command deletes the key, if it exists. 4 FLUSHALL Delete all the keys of all the existing databases, not just the currently selected one. 5 KEYS pattern Returns all […]