Tips

Tips

Microsoft SQL Server Administration

• 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

• 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

• A quick tutorial on SQL Server maintenance plans

  SQL Server maintenance plans get a bad rap, but for DBAs who need a simple way to maintain databases, Microsoft's built-in tools are a good place to start.  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

• 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

• Five SQL Server maintenance steps you should take -- ASAP

  Putting off SQL Server administration tasks can lead to problems. Do these often-neglected database maintenance items to help keep your systems running smoothly.  Continue Reading

• Microsoft Cosmos DB takes Azure databases to a higher level

  Azure Cosmos DB brings a new element to the database lineup of Microsoft's cloud platform, offering multiple data models and a scalable environment for distributed applications.  Continue Reading

• Five SQL Server database trends to be prepared for in 2018

  Here's a list of notable trends related to SQL Server that IT teams should be ready for over the next 12 months. Among them: increased use of the cloud, AI, Linux and containers.  Continue Reading

• Dissect the SQL Server on Linux high availability features

  SQL Server 2017 on Linux gives IT shops greater flexibility, but there are some limitations and changes to the way high availability and failover are performed on Linux vs. Windows.  Continue Reading

• How to use a SQL Server graph database to map data relationships

  Here are the basics you need to know to use the graph database features added in SQL Server 2017 to represent the relationships between different data elements in a graph structure.  Continue Reading

• How to choose the right SQL Server on Azure deployment option

  There are two options for deploying SQL Server on the Azure cloud. Here's a look at how they differ to help you choose between using Azure SQL Database and running SQL Server on an Azure VM.  Continue 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

• New SQL Server 2017 features give good reasons for fast upgrades

  The new SQL Server 2017 adds support for Linux and a variety of other new features that could justify upgrades to the revamped database platform, even coming so soon after the 2016 release.  Continue Reading