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

  • How to Create MS SQL Database Using SQL Server Management Studio – For Beginners
    Articles,  Blog

    How to Create MS SQL Database Using SQL Server Management Studio – For Beginners

    Hello, Good evening, my name is Kindson Munonye, the application developer, the telecoms engineer the computer engineer whatever you like to call me first I’d like to thank my subscribers. you are really doing great and i promise you i’ll be uploading higher quality videos after now well, this video are making it as a very short one and i’m just going to take you through how to create the a simple database using Microsoft’s SQL server 2008, the same procedure apply to 2005 2012 so just follow along It’s not going to be an elaborate one but if you like to learn how to create a database in Microsoft…

  • Registered Servers and Central Management Servers in SQL Server (Part 1)
    Articles,  Blog

    Registered Servers and Central Management Servers in SQL Server (Part 1)

    Hi everyone! Today I’m going to introduce you to Registered Servers and Central Management Servers. These are two features built into SQL Server and Management Studio to organize and manage your server infrastructure. They help you by scaling some of the features you’re already familiar with from one server to multiple servers. While neither Registered Servers nor Central Management Servers are what I might call a “complete solution” to server management, they’re still useful and powerful, and most importantly, they’re available automatically when you install Management Studio. At their core, both Registered Servers and Central Management Servers are designed around the task of saving and organizing connection strings to your…

  • Registered Servers and Central Management Servers in SQL Server (Part 2)
    Articles,  Blog

    Registered Servers and Central Management Servers in SQL Server (Part 2)

    Hi everyone! In the first part of the series, I introduced you to Registered Servers and Central Management Servers and how to set up the server lists. Today in the second part, I’m going to show you how to put these features to work. If you’re not familiar with the basics of these features, please watch the first part of the series by clicking the annotation here. The link will also be in the video description. So, let’s get right into the demo now. After the server hierarchy has been set up initially, we can start using it to manage the servers. I’m first going to show you the functionality…

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

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