Manage

Manage

Learn to apply best practices and optimize your operations.

• Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

  In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL queries that incorporate OUTER JOINs. Continue Reading

• How SQL Server DevOps processes help break down data silos

  DevOps can help organizations dismantle data silos in SQL Server and other database systems -- and replace organizational silos with cross-functional teams. Continue Reading

• Key features to create a SQL Server audit trail in databases

  SQL Server offers a set of built-in auditing tools that can help make the process of tracking logins and other database activities easier for database administrators. Continue Reading

• database management system (DBMS)

  If the database is a file of information, then the DBMS is the file folders, the file labels and the file cabinet. Continue Reading

• SQL Server performance tuning best practices for DBAs

  Tuning database performance is a complex process, but consultant Joey D'Antoni details a list of SQL Server performance tuning best practices that can make it easier. Continue Reading

• SQL Server auditing best practices: 3 key questions for DBAs

  Acing a SQL Server database audit starts with careful monitoring of how sensitive data is accessed and used so you can answer the top questions that auditors ask.Continue Reading

• 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