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