Tips

Tips

Microsoft SQL Server Administration

• 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

• Automate SQL Server Docker container configuration via Dockerfiles

  As many in IT have learned the hard way, building software containers for systems like SQL Server can be tough. That's where Dockerfiles come in to help automate the process.  Continue Reading

• Using SQL DATEPART, GETDATE, DATENAME functions

  SQL datetime functions DATEPART, GETDATE and DATENAME can retrieve the date and time or other individual parts of a value. Here's how to master these T-SQL tools.  Continue Reading

• What do new SQL Server Standard Edition features mean for IT?

  Which SQL Server edition is right for you? After Microsoft upgraded the Standard Edition with features from the Enterprise one, a lower cost choice might be possible in some cases.  Continue Reading

• Use these commands to deploy SQL Server Docker containers

  Containerized apps are everywhere, but you can also run databases in containers. Follow these commands to customize SQL Server images in Docker containers.  Continue Reading