Latest Entries »

SQL Query Tutorial VideoBefore you can begin using SQL Server, you have to install it.

The following video walks you through the installation of SQL Server 2008 R2 Express:

Video: How to Install SQL Server 2008 R2 Express

View full article »

Advertisements

Find your Installed SQL Server Versions and Instances

It’s more common than you would expect to have SQL Server installed on your machine without knowing the exact version or edition. With tools and applications installing SQL Server behind the scenes, you may have unknowingly installed SQL Server. In this post, I’ll try to quickly explain some easy ways to investigate this question. This will include:

  • Using the Programs and Features control panel tool.
  • Understanding and viewing SQL Server instances.
  • SELECT @@VERSION

View full article »

In a blog about learning SQL Server, it can be tempting to start with the basics of installing and using SQL Server. But the “why” should always be covered before the “how”. Why use a database? What problems does it solve? When can it help you? If you already have your own answers to these questions, then feel free to skip this post and move onto other posts on this blog that more practically dive into SQL Server concepts and skills.

The following video attempts to address these questions:

Video: What is a Relational Database?

View full article »

Welcome to the Learning SQL Server Blog

Thanks for visiting this new blog. As the name suggests, the focus is on helping you learn SQL Server. Even so, we hope that experienced users can find useful tips and tricks. For an extended explanation about what this blog is all about, go here. To find useful links to other resources, see the Resources page. And for information about our “Learning SQL Server” video series, see the Video Series page.

Thanks, and let us know what you think!

Learning SQL Server Team
learningss@microsoft.com