Tips

Tips

Microsoft SQL Server Administration

• 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

• Tips on how to build your first SQL Server container

  Navigating the new world of containers might seem daunting, but the examples outlined here will walk you through the process of creating and managing containers for SQL Server.  Continue Reading

• Common SQL Server 2016 licensing scenarios and how they work

  Microsoft software licensing can be tough to manage -- so let's analyze some of the different situations for licensing SQL Server 2016 that enterprises will likely face.  Continue Reading

• What SQL Server for Linux says about Microsoft's future plans

  SQL Server on Linux may just be the start. After making PowerShell open source, Microsoft can build Linux versions of any of its server technologies. And it has reason to do so.  Continue Reading

• Options for scaling out SQL Server applications to boost workloads

  Scaling out a database to meet the needs of a heavy processing workload can be a challenge. Here are details on the SQL Server scalability methods available to ease the process.  Continue Reading

• Four trends that will impact SQL Server DBAs in 2017

  Flash storage adoption, cloud computing's growth, Linux's increased importance and broader big data integration are a few trends that stand to affect SQL Server users this year.  Continue Reading

• DATEADD and DATEDIFF SQL functions for datetime values

  DATEADD and DATEDIFF SQL functions allow you to easily perform calculations, like adding a time interval from a datetime value. Here's how to use those functions for that and more.  Continue Reading

• How to get the most out of virtual SQL Server with Microsoft Hyper-V

  SQL Server is a CPU-intensive technology, which can make it tricky to run in a virtualized environment. Keep your SQL Server virtual machines running smoothly with these tips on using Hyper-V.  Continue Reading

• Migrating SQL Server to Microsoft Azure SQL Database as a service

  Microsoft Azure SQL Database compatibility problems disappeared in V12, clearing the path for a SQL database migration to the cloud. Here's how to make the move.  Continue Reading