SQL Server Performance Newsletter
Monday, June 24, 2019

How monitoring can help keep your SQL Server estate secure

With attacks on data systems like SQL Server becoming increasingly creative and sophisticated, you need a monitoring solution that doesn't just find known attacks, but spots signs of improper access as well.
In this new whitepaper you'll learn:

  • Why standard monitoring alone leaves you vulnerable
  • How to defend against unknown attacks with a broader monitoring approach
  • How to set up a monitoring system to spot, investigate, and stop attacks

  • Download the whitepaper

Unit Testing, Databases, And You
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...
Agile Newsletter
4281 Express Lane
Suite L7710
Sarasota, FL 34238