• Installed SQL Server?…Now What? (Getting Started)
    Articles,  Blog

    Installed SQL Server?…Now What? (Getting Started)

    Hi. I’m Jason Roth. In the last video we installed SQL Server 2008 R2. If you’re new to SQL Server, you may be thinking, “Now What?” In this video I’ll show you how to create your first database. We’ll then install a sample AdventureWorks database. And we’ll conclude by importing a spreadsheet into a database. This is not a video on database design, but it should give you some invaluable hands-on experience with the tools. And you can immediately begin using SQL Server. It all starts with a tool called SQL Server Management Studio. On the “Start Menu”, click “All Programs”, expand “Microsoft SQL Server 2008 R2”, and then start…

  • How to open an .MDF file? (Attach a Database in SQL Server)
    Articles,  Blog

    How to open an .MDF file? (Attach a Database in SQL Server)

    Hi. Let’s say somebody wants to share their SQL Server database with you. If they give you an .MDF and .LDF file, how do you actually look at the contents of that database? You might be tempted to try to open these files with a specific SQL Server program, like SQL Server Management Studio. But the correct approach is to “attach” these files to a specific instance of SQL Server. Let me show you how this works. First, you need a running instance of SQL Server on your machine. SQL Server 2008 R2 Express is a free edition of SQL Server. Once installed, you can open up SQL Server Management…

  • 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…