SQL Server performance tuning: Nine best practices
SQL Server performance tuning can seem overwhelming when you don’t know where to start. In this article Robert Sheldon explains 9 best practices for performance tuning.
2021-06-16
Additional Articles
How Can Redgate Tools Help with a Cloud Migration?
The cloud migration tools and processes that will help you move a database to the cloud, from planning, implementation and validation through to extending existing development and deployment processes to the new cloud platform.
2021-06-14
How to Find Unused Databases in SQL Server
In this article we look at how to identify if SQL Server databases are not being used and a process to take these unused databases offline.
2021-06-14
Simple Talk Storage 101 by Robert Sheldon
The only way to derive meaning from the massive amounts of data collected today is to develop innovative high-performing, high-capacity storage solutions. In this book, Robert Sheldon explains the many types of storage currently available and what's on the way.
2021-06-11
The four best features to look out for in SQL Monitor
In this blog, David Yard at Kingston Technology shares his favorite SQL Monitor features and how they’re helping him to make sure their large SQL Server estate performs at its best.
2021-06-11
SQL Server Resource Governor Game
Learn about the SQL Server Resource Governor and how it can be used to manage your SQL Server workloads via this game format that can help your team gain better insights.
2021-06-09
The changing landscape of continuous database integration
Considering introducing continuous database integration? Learn the principles in this ThoughtWorks webinar hosted by Pramod Sadalage, expert in this discipline and author of several books about database refactoring and development.
2021-06-09
DBA in training: SQL Server high availability options
DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses those options in this article.
2021-06-07
Redgate Streamed: Embracing technology trends for database success
Innovating in the database is crucial for success, and we’re seeing new trends impact the database, like cloud migration, SRE, and the growing need for big data and tools to support growing estates. On 23 June, Redgate Streamed brings you organizations who have implemented these database technology trends, including speakers from Google, Microsoft, and AWS, who will share their success stories and tips for embracing technology changes.
2021-06-07
The changing landscape of continuous database integration
Considering introducing continuous database integration? Learn the principles in this ThoughtWorks webinar hosted by Pramod Sadalage, expert in this discipline and author of several books about database refactoring and development.
2021-06-04
Blogs
Monday Monitor Tips: Learning While Using the Tool
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
Act on Your Certification Test Results
By Brian Kelley
Pass or fail, act on your certification test results.
Catching Up On SQLOrlando
By Andy Warren
Somehow two years have elapsed since my last update; hopefully it won’t be that...
Forums
Switch partition: NULL boundary id
I have table: t1 in schema1 with 19 billion records. I have another table...
Minimally Viable Security
Comments posted to this topic are about the item Minimally Viable Security
Encoding NULL
Comments posted to this topic are about the item Encoding NULL
Question of the Day
Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers