Manage

Manage

Learn to apply best practices and optimize your operations.

• How to classify the complexity of a Microsoft SQL Server upgrade

  Not all SQL Server upgrades are created equal and not all require the same level of effort. Learn when to go all out and when to conserve your energy by classifying your upgrades. 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

• How do the T-SQL commands TRUNCATE TABLE and DELETE differ?

  TRUNCATE TABLE and DELETE are T-SQL statements with similar functions, but that doesn't make them interchangeable. They operate differently and use different amounts of SQL Server resources. 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

• SQL Server for Linux shows Microsoft changing with the times

  SQL Server on Linux didn't come out of nowhere. The database's roots are in Unix, and Microsoft has been making a concerted effort to be less Windows-centric overall. Continue Reading

• SQL Server 2016 T-SQL features add to DBCC CHECKDB and more

  Expert Ashish Kumar Mehta shares some of the enhancements to T-SQL ahead in SQL Server 2016. This includes a DROP IF EXISTS option and MAXDOP for DBCC CHECKDB.Continue Reading

• Database trends to watch after SQL Server 2005 end of life

  Two database industry experts discuss infrastructure and analytics trends to consider for database upgrades following the end of SQL Server 2005 extended support.Continue Reading

• Why SQL Server 2005 end of life is good news for DBAs

  Two database experts explain how to take advantage of the opportunity created by SQL Server 2005 end of life and how to build a better database.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

• Shining a light on SQL Server storage tactics

  A good storage plan is key to proper database management no matter what system database administrators are working in. Without a sufficient SQL Server storage plan, the system may run out of space or process tasks too slowly. This handbook examines ...Continue Reading

• What's new in 2016's SQL Server AlwaysOn Availability Groups

  Microsoft has added Distributed Transaction Coordinator support, optimized log transport and other features to AlwaysOn Availability Groups in SQL Server 2016.Continue Reading

• DH2i containerization software gets Westminster, Colo., to clustering

  When Microsoft's licensing policy began costing too much, the City of Westminster used DH2i's containerization software to cluster its over 30 servers, standardize them and save money.Continue Reading

• SQL Server 2014 features enable hybrid cloud scenarios

  Microsoft continues to improve integration between on-premises data centers with Microsoft Azure. An expert looks at SQL Server 2014 features that enable hybrid cloud scenarios.Continue Reading

• Testers give an early view of Microsoft SQL Server 2016

  Community Technology Previews show the creation process for Microsoft SQL Server 2016. SQL Server experts Denny Cherry and Joey D'Antoni share what they've learned in beta testing.Continue Reading

• SQL Server 2005 end of life is closing in: Are you ready?

  Extended support for SQL Server 2005 ends in April. That's it. It's done. If your organization isn't prepared, your data could be at risk, cautions expert Robert Sheldon.Continue Reading