Get started

Get started

Bring yourself up to speed with our introductory content.

• 2 ways to attach SQL Server database files to Linux containers

  SQL Server files can be stored outside of Docker containers in host directories or volumes. Here's how to set up SQL Server on Linux databases and attach them to containers. Continue Reading

• Get started with SQL Operations Studio in 7 steps

  Microsoft's newest tool, SQL Operations Studio, provides DBAs with a free, lightweight option for managing SQL Server and Azure databases. Use these tips when trying it out. Continue Reading

• Quick start tips for using the new MSSQL-CLI SQL query tool

  The new MSSQL-CLI command-line tool provides many enhancements over SQLCMD CLI that enable you to quickly write and run T-SQL queries across Linux, macOS and Windows. Continue Reading

• Tips and tricks to cut your SQL Server cloud costs

  Running SQL Server in the cloud can be expensive, but it doesn't have to be. These tips show you where wasteful spending happens and how to keep your database cloud bill low. Continue Reading

• How to attach databases to custom SQL Server containers

  Deploying SQL Server in Docker containers for production applications typically requires custom containers. Here are guidelines on how to attach databases to them. Continue Reading

• Definitions to Get Started

  • U-SQL
  • Microsoft Azure Cosmos DB
  • Microsoft SQL Server
  • Microsoft SSIS (SQL Server Integration Services)

  • T-SQL (Transact-SQL)
  • flat file
  • Microsoft Visual FoxPro (Microsoft VFP)
  • data mining

  View All Definitions

• Six sample databases for SQL Server and how to find them

  SQL Server sample databases are useful for test and dev, but they can be difficult to parse. Use this SQL database sample overview to decide which to use and how to access them.Continue Reading

• Why running SQL Server on Docker is no longer frowned upon

  Microsoft now lets SQL Server databases run in Docker containers, a capability that depends on using volumes to store data in a persistent way outside the containers.Continue Reading

• How much do you know about the components of SQL Server?

  From SQL Server Machine Learning Services to the SQL Server Operating System, there's a lot to know about SQL Server. Test your SQL Server knowledge with our quiz.Continue Reading

• U-SQL

  U-SQL is a Microsoft query language that combines a declarative SQL-like syntax with C# programming, enabling it to be used to process both structured and unstructured data in big data environments.Continue Reading

• Microsoft SQL Operations Studio eases SQL Server admin tasks

  SQL Operations Studio simplifies routine administration of SQL Server and Azure SQL databases, making database development and management easier for users who aren't full-time DBAs.Continue Reading

• Microsoft Azure Cosmos DB

  Azure Cosmos DB is a Microsoft cloud database that supports multiple ways of storing and processing data. As such, it is classified as a multimodel database.Continue Reading

• Microsoft SQL Server

  Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environmentsContinue Reading

• How to use a SQL Server create database script to set up databases

  You can create SQL Server databases manually, but knowing how to do a scripted database setup is valuable. Here are the steps involved in executing a create database script.Continue Reading

• Microsoft SSIS (SQL Server Integration Services)

  Microsoft SSIS (SQL Server Integration Services) is an enterprise data integration, data transformation and data migration tool built into Microsoft's SQL Server database.Continue Reading

• How to use Python in SQL Server 2017 to run analytics applications

  From installation to implementation, here are the basic details on how to take advantage of the Python programming language in SQL Server 2017.Continue Reading