Manage

Manage

Learn to apply best practices and optimize your operations.

• How SQL Server containers in Docker can ease database deployment

  Docker containers can make the SQL Server deployment process more efficient and flexible. Here's what they are and how to get started on creating containers for SQL Server databases. Continue Reading

• Microsoft technology refresh touches SQL Server, integration tooling

  Microsoft is at work on a delicate technology refresh affecting database tuning and architecture, as well as data integration and business intelligence. 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

• The ins and outs of using R in SQL Server 2016 and 2017

  What does the R analytics language offer to users, and how does it fit into SQL Server 2016 and 2017? Get answers to those questions and details on Microsoft's various R technologies. 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

• 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

• Conquer real-time operational analytics in SQL Server 2016

  Analytics helps improve business operations, and SQL Server 2016 users can master it -- in real time, using operational data in a transactional database.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

• 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

• SQL Server Installation Center steps for SQL Server 2016 upgrades

  Consultant Michael Otey provides a step-by-step guide to upgrading from SQL Server 2014 to the 2016 release using the SQL Server Installation Center and Microsoft's upgrade wizard.Continue Reading

• SQL Server 2016 licensing tips to help you steer clear of trouble

  SQL Server licensing is always complicated, and licensing for SQL Server 2016 adds new wrinkles. Expert Michael Otey provides guidance on licensing for different editions and situations.Continue Reading

• Configure SQL Server at database level with new scoping syntax

  SQL Server 2016 adds ALTER DATABASE SCOPED CONFIGURATION to its new T-SQL statements. The statement lets DBAs control database configuration at the level of a single database.Continue Reading