• End of support guidance for Windows Server & SQL Server 2008 and 2008 R2
    Articles,  Blog

    End of support guidance for Windows Server & SQL Server 2008 and 2008 R2

    >>End of support for both Windows Server and SQL Server 2008 and 2008 R2 is coming up fast. The first deadline is July 9th, 2019. While that may sound like a far off future, it’s important to plan your migration and upgrade strategy today. The first reason not to wait is security. Once end of support hits, security updates stop, which means companies will be on their own in a threat landscape that’s more dangerous than ever. Security breaches happen every day. If it happens to you, how would you like to explain to your CEO and shareholders that you were running unsupported software and that it might have led…

  • How to Find Your SQL Server Instances (Server Name) and Versions
    Articles,  Blog

    How to Find Your SQL Server Instances (Server Name) and Versions

    Hi. I’d like to just quickly show you how to determine what versions of SQL Server you have on your machine. In the control panel, you can always type in “SQL Server” in the search box. And you can get a list of the different SQL Server installations. But this isn’t entirely the whole story. What I’d like to do instead, once you know that you have some type of SQL Server on your machine, is go to the “Start Menu”, click “All Programs”, go to “SQL Server 2008 R2”. Then open up “Configuration Tools”, and launch the “SQL Server Configuration Manager”. When the SQL Server Configuration Manager comes up,…

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

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