• SQL Server 2019 | Query faster from any database. (Microsoft Ignite)
    Articles,  Blog

    SQL Server 2019 | Query faster from any database. (Microsoft Ignite)

    (logo sliding) (upbeat music) – Welcome to Microsoft Mechanics Live. (audience clapping) Hoo. Coming up, we take a closer look SQL Server 2019, now generally available. We’ll look at its expanded role as a data integration platform allowing you to bring in data from any source including on the Edge for analysis. In fact, we’ll show you how data location becomes irrelevant with a scenario that goes from the ground to the cloud, and introduce you to Azure SQL Database Edge. So, I’m please to be joined today by Buck Woody, an applied data scientist from the SQL engineering team. Welcome! Thanks for having me on the show. – It’s…

  • Articles

    Getting Started with T-SQL Queries using SQL Server Management Studio

    Hi. I’m Jason Roth. In the previous videos, we installed SQL Server 2008 and began using SQL Server Management Studio. In this video, I’m going to show you how to write basic database queries in SQL Server 2008. I’m also going to provide some tips and tricks along the way. Let’s start by launching SSMS. On the “Start Menu”, expand “Microsoft SQL Server 2008 R2”, and then click “SQL Server Management Studio”. Type the name of your SQL Server instance, and then click Connect. In our first video, “What is a Relational Database?”, we introduced a fictional database that contained experiment data. This database has three tables: Experiements, Runs, and…