Tips

Tips

Microsoft SQL Server Administration

• SQL Server high availability best practices in the cloud

  The cloud isn't immune to system failures. You can increase database uptime and prevent data losses with these high availability best practices for SQL Server in the cloud.  Continue Reading

• 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

• 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