Team Blog

MSPs are smart to choose database solutions, including monitoring tools, that offer the same performance regardless of whether their clients' databases are located on-premises or in the cloud.
Together with support of Warwick Rudd and the team at SQLMasters Consulting, I will be appearing at nine events and venues in Australia and New Zealand. Let's meet in person and talk about SQL Server!
Paul White explains minimal logging for inserts into b-tree indexes using Fast Load Context, and why it might not always work as expected.
Aaron Bertrand talks about Learning Pathways, a new, innovative way to take advantage of the sessions offered at PASS Summit.
Erin Stellato discusses the performance impact of a predominately adhoc workload in SQL Server.
Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into an empty clustered table.
Aaron Bertrand shares his slides and demos from his most recent presentations at SQLDay in Wrocław, Poland.
Itzik Ben-Gan resumes his blog series on T-SQL bugs, pitfalls, and best practices, treating an issue with correlated column references in subqueries.

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More

Get a Free 2-Week Trial

Start your free trial of any of our products today.

Free Trial

2-Week Trial