Manage

Microsoft SQL Server Performance Monitoring and Tuning

• 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

• 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

• 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

• 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

• 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 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

• 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

• SQL Server best practices for handling the post-installation blues

  The job isn't over after a successful SQL Server installation. These SQL Server best practices will help you optimize your new SQL Server installation from the start.Continue Reading

• SQL Server tempdb configuration simplified in 2016 release

  With SQL Server 2016, tempdb will get enhancements to help speed up applications. Find out about the changes and learn how to properly configure tempdb in SQL Server 2016.Continue Reading

• How to set up the SQL Server buffer pool extension feature

  SQL Server 2014 includes the buffer pool extension feature, which can speed up query performance. Ashish Mehta explains the benefits of the feature and how to enable and disable it.Continue Reading

• Built-in tools for monitoring and optimizing OLAP cubes

  Optimizing online analytical processing performance is critical. Fortunately, tools are available to help monitor and improve how OLAP cubes perform.Continue Reading

• Built-in tools troubleshoot SQL Server memory usage

  Having enough memory is critical to SQL Server's performance. To ensure optimum SQL Server performance, you need to monitor SQL Server memory usage regularly. This article describes built-in tools that can make the job easier.Continue Reading

• Mavis Tire goes SANless with SIOS DataKeeper

  With DBAs rewarded for server performance and SAN specialists rewarded for server capacity, there can be a tug of war. Mavis Tire goes SANless with SIOS DataKeeper. SIOS Technology releases a survey about high availability and SAN.Continue Reading

• When it comes to database security, beware lazy developers

  Don Jones discusses how database developers are taking the easy road for database security and going with the lowest common denominator instead of taking into account the unique security of each database platform.Continue Reading

• The dark side of Microsoft SQL Server Express

  Don Jones explains why Microsoft SQL Server Express can be more dangerous than you'd think and why it might be worth it to invest in the paid edition.Continue Reading