Manage

Manage

Learn to apply best practices and optimize your operations.

• 5 trends for SQL Server environments as SQL Server 2019 looms

  SQL Server is undergoing new changes, as Microsoft prepares to release the 2019 version of the database software. Other changes are also on tap for SQL Server users. Continue Reading

• 5 FAQs on SQL Server containers and how to manage them

  Running SQL Server in containers creates new challenges for database administrators. The answers to these questions can guide you through some of them. Continue Reading

• Implement SQL Server security best practices in 4 easy steps

  Managing SQL Server security doesn't need to be difficult. These four best practices from Microsoft MVP and author K. Brian Kelley can help DBAs keep databases secure. Continue Reading

• The most useful new features in Microsoft SQL Server 2019

  SQL Server 2019 includes welcome new features, particularly updates to its indexing and high availability capabilities and added SQL Server on Linux functionality. Continue Reading

• PASS Summit 2018 spotlights new demands on SQL Server DBAs

  This year's PASS Summit comes as SQL Server 2019 looms and the cloud becomes a bigger factor. PASS board member Tim Ford talks about key trends ahead of it. Continue Reading

• 4 strategies to beat the SQL Server 2008 support cutoff

  The looming end of SQL Server 2008 extended support should spur database teams into action. Consider these four options to extend security updates or migrate your aging SQL Server systems.Continue Reading

• 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

• What the Microsoft GDPR compliance toolkit offers for SQL Server

  The set of GDPR compliance tools that Microsoft offers for SQL Server is designed to make it easier for users of the database software to adhere to the EU's new data rules.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

• 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