SQL Server Performance Newsletter
Monday, June 24, 2019
" . "

As the demand for more frequent deployments increases, management of SQL Server availability needs to evolve

In this free whitepaper, learn how SQL Server monitoring can help you:

  • Maintain availability at all stages of the development process
  • Keep communication flowing between DBA and dev teams
  • Remove bottlenecks
  • Identify and respond to deployment-related performance issues


Get your FREE copy now


Unit Testing, Databases, And You
SimpleTalk
As database changes are added to the DevOps pipeline, unit testing of those changes becomes crucial. In this article, Adam Hafner describes unit testing and how it applies to databases. READ MORE...
Why Order Isn’T Guaranteed Without An ORDER BY
Brent Ozar
Start with the Stack Overflow database, with no nonclustered indexes. If you’ve been playing around with demos, run my DropIndexes proc just to clear things out, which leaves the clustered indexes in place. READ MORE...
Filtering Object Explorer Detailed Information In SSMS
Database Journal
In my last tip Displaying the Object Explorer Details Pane in SQL Server Management Studio, you learned how to bring up the Object Explorer Details pane. READ MORE...
Largest Tables On An Instance
Steve Stedman's Blog
Here is a quick script that I find myself using frequently to find the largest tables on an entire SQL Server instance. READ MORE...
Blogs
Agile Newsletter
4281 Express Lane
Suite L7710
Sarasota, FL 34238