Manage

Microsoft SQL Server Performance Monitoring and Tuning

• 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

• Five tips to avoid a performance bottleneck or other SQL Server snares

  Basit Farooq provides five tips for SQL Server users, from avoiding a hardware performance bottleneck to dealing with database design.Continue Reading

• Dive deep into SQL Server 2014 in-memory OLTP

  Probably the biggest feature of the upcoming release, SQL Server 2014 in-memory OLTP has benefits that DBAs should know about. Learn how to set it up.Continue Reading

• Does SQL Server database size affect performance?

  Of course SQL Server database size matters, but there are steps DBAs and IT managers can take to mitigate growing data and maintain good performance.Continue Reading