Sort by Curated

Article

.NET memory usage – 7 tips for better performance

7 tips for avoiding common pitfalls in .NET memory usage, from the .NET community.

Article

How to improve the performance of ASP.NET applications

9 tips on speeding up the code-side of ASP.NET applications, from the .NET community.

Article

.NET performance advice – 6 top tips

6 top tips on the best ways to start optimizing your code, from the .NET community.

Article

How to check third-party .NET code performance

To understand and improve .NET performance, you need to examine every aspect of your code. Bottlenecks sometimes lie in the way your co…

Article

ASP.NET application performance improvements on Azure

ASP.NET, Azure Web Roles, and Azure SQL Database provide a great way to build highly scalable, data-heavy applications, without having …

Case study

“Redgate tools save me hours and hours of work each week. They’ve cut out bugs and versioning accidents almost completely.”

— Michael Stoop, Database Developer, Calvi
Calvi, Europe's leading provider of telecom invoice management software, use SQL So…

Video

How to create your own custom SQL Server metrics in SQL Monitor

SQL Monitor’s Anne Edwards shows you how to set up a new custom SQL Server metric in SQL Monitor. She covers entering T-SQL code, cho…

Video

Adding custom metrics from SQLMonitorMetrics.com

Mark Champion shows how to install pre-written T-SQL custom metrics for SQL Server, from SQLMonitorMetrics.com, directly into SQL Monit…

Video

Availability Group Monitoring in SQL Monitor

Grant Fritchey shows you how to easily monitor your AlwaysOn Availability Groups using Redgate’s SQL Monitor. See instantly how your …

Video

How to check and compare baselines with SQL Monitor

SQL Monitor’s Anne Edwards explains how to check baselines for SQL Server performance metrics in Redgate SQL Monitor.

Video

Setting up and customizing alerts in SQL Monitor

Getting SQL Server monitoring in place is great, but to really make it pay off, you need to take the time and trouble to customize your…

Video

How to install SQL Monitor

See how to get up and running with SQL Monitor in 5 minutes and start monitoring your SQL Servers. This step-by-step guide shows you in…

Automating database deployments with SQL Toolbelt

Learn how insurers AFA Försäkring made substantial time savings with the SQL Toolbelt, freeing up the equivalent of an additional tea…

Video

SQL Change Automation & VSTS: 10 tips and tricks for database migrations – Part 2

Redgate's David Simner, Jon Hickford and Microsoft MVP Steve Jones present 10 tips and tricks for database migrations using SQL Change …

Video

SQL Change Automation Visual Studio Migrations demo

SQL Server MVP Steve Jones presents a walkthrough of SQL Change Automation, Redgate's tool for making SQL Server database changes in Vi…

Whitepaper

Redgate’s Database DevOps approaches – a comparison

A quick overview of the state-/model-based and migrations-based approaches to Database Lifecycle Management, and the advantages of both…

Video

How to split a column without data loss with migration scripts in SQL Server Management Studio

Technical author Owen Priestley explains how to deploy schema changes that involve data changes safely. He covers how to use migration …

Video

Profiling the performance of a .NET desktop executable with ANTS Performance Profiler

This video walks through profiling Redgate's ANTS Performance Profiler tool, showing how information on database queries and web reques…

Video

Understanding ASP.NET performance with ANTS Performance Profiler

ANTS Performance Profiler technical author Roger Hart demonstrates how you can look at performance information for specific web pages, …

Datasheet

SQL Prompt ROI Guide

See how SQL Prompt helps your development and DBA teams, and how that translates into ROI for your business.

Case study

“We no longer need to memorize column names, and joining tables is now just a click away”

Learn how one development team save time, cut errors, and respond to user requests fast, with SQL Prompt.

Case study

“We can now do live database deployments at the push of a button”

Find out how Nmbrs use DLM Automation to deploy database updates as easily as application changes.

eBook

45 Database Performance Tips for Developers

See the SQL Server performance tips and tricks recommended by some of the smartest minds in the Simple Talk community, including SQL Se…

Video

How to pull database changes from a Git remote repository

SQL Server MVP Steve Jones shows you how to pull changes from a Git remote repository straight into SQL Server Management Studio using …

Video

How to push database changes to a Git remote repository

SQL Server MVP Steve Jones shows you how to push changes to a Git remote repository straight from SQL Server Management Studio using Re…

eBook

Confessions of an IT Manager

From IT projects that have trampled all over the guiding principles of successful development, to tips on training your manager to the…

eBook

Don’t Just Roll the Dice

How do you price your software? Is it art, science or magic? How much attention should you pay to your competitors? This short handbook…

eBook

Exchange 2010 SP1 – A Practical Approach

As a practical field-guide to Exchange Server 2010, this book will tell you exactly what you need to know to get started with upgrading…

eBook

The Sysadmin Handbook: The Best of Simple-Talk

With over fifty articles packed into this book, it's an essential reference for any Systems Administrator, whether you have years of ex…

eBook

.NET Performance Testing and Optimization – The Complete Guide

The Complete Guide to Performance Testing and Optimizing .NET Applications (by Paul Glavich and Chris Farrell) covers everything from w…

eBook

Under the Hood of .NET Memory Management

This book will take you from the very basics of memory management, all the way to how the OS handles its resources, and will help you …

eBook

Mastering SQL Server Profiler

This book will make it easier for you to learn how to use Profiler, analyze the data it provides, and to take full advantage of its po…

eBook

SQL Server Stumpers Vol. 5

How much do you know about the different aspects of SQL Server? Some of these questions are arcane, some very common, but each of them …

eBook

How to become an Exceptional DBA, 2nd edition

This book is a career guide that will show you, step-by-step, specifically what you can do to differentiate yourself from the crowd, so…

eBook

SQL Server Tacklebox

In this book you'll find scripts that will allow you to automate and standardize SQL Server installation, document and report on your s…

eBook

Protecting SQL Server Data

In Protecting SQL Server Data, John Magnabosco demonstrates how sensitive data, stored in SQL Server, can be protected using an efficie…

eBook

The Best of SQLServerCentral.com Vol 7

Some of the best articles from the top SQL Server community site, SQLServerCentral.com, edited by SQL Server MVP Steve Jones.

eBook

Brad’s Sure Guide to SQL Server Maintenance Plans

Used carefully, SQL Server MVP Brad McGehee's Maintenance Plan tools represent powerful time-saving devices for any DBA.

eBook

Performance Tuning With SQL Server Dynamic Management Views

This book is here to de-mystify the process of collecting the information you need to troubleshoot SQL Server problems. It will highlig…

eBook

SQL Server Statistics

Reading Holger's booklet is a great way of brushing up on the subject of Statistics and query-optimization. It is reasonably short, and…

eBook

SQL Server Hardware

Ensure that your SQL Server instances can gracefully handle the CPU, memory and IO workload generated by your applications, and that yo…

eBook

Troubleshooting SQL Server: A Guide for Accidental DBAs

Learn the steps and techniques three SQL Server MVPs use day-to-day to troubleshoot real SQL Server performance problems.

eBook

SQL Server Backup and Restore

In this book you'll discover how to perform each of a DBA's essential backup and restore tasks using SQL Server Management Studio (SSMS…

eBook

SQL Server Concurrency: Locking, Blocking and Row Versioning

Your application can have world-class indexes and queries, but they won't help you if you can't get your data because another applicati…

eBook

The Art of SQL Server FILESTREAM

This book will help you master all essential aspects of programming and administering FILESTREAM-enabled databases.

eBook

SQL Server Transaction Log Management

This book shows you how to control the transaction log so it doesn't control you.

eBook

Tribal SQL

15 first-time authors answer the question: what makes you passionate about working with SQL Server?

eBook

Fundamentals Of SQL Server 2012 Replication

All you need to decide whether replication is the right feature to use and which type of replication is the most advantageous in your s…

eBook

SQL Server Internals: In-Memory OLTP (Second Edition)

Kalen Delaney explains how the new In-Memory OLTP engine works, how it stores and manipulates data, and how you can still guarantee the…

eBook

25 Secrets for Faster ASP.NET Applications

Learn 25 tips from the ASP.NET community to boost your ASP.NET performance in this free eBook

eBook

50 Ways to Avoid Find and Fix ASP.NET Performance Issues

Learn 50 tips from the .NET community to speed up your ASP.NET application in this free eBook.

eBook

52 Tips & Tricks to Boost .NET Performance

Learn 52 tips from the .NET community to speed up your .NET application in this free eBook

Case study

Content and performance drive Citywire website success

Find out how Citywire used ANTS Performance Profiler to find and fix .NET performance bottlenecks.

Case study

How ANTS Performance Profiler saved my hide

Find out how a financial institution used ANTS Performance Profiler to resolve an urgent crisis

Video

Capturing and understanding deadlocks

Grant Fritchey tells you how deadlocks can be captured and understood using SQL Monitor.

Case study

How to handle 25 million database changes a day

Monsoon Commerce use SQL Monitor to track the databases that power alibris.com, a web marketplace of 150 million items

Case study

Using SQL Monitor at Interactive Intelligence to save up to six hours of work each day

Interactive Intelligence use SQL Monitor to get alerted to problems before they impact customers

Case study

How Digital Outsource Services catch deployment problems and save 15 hours a week

When Digital Outsource Services switched to SQL Monitor to monitor 24 production servers, they saved 15 hours a week.

Article

SQL Server Performance Monitoring with SQL Monitor

This article provides an in-depth guide to the monitoring and alerting functionality available in Redgate's SQL Monitor. It explains ho…

eBook

The Art of XSD

This book starts with the basics of XML schemas and then walks you through everything you need to know, with examples and labs, in orde…

eBook

Defensive Database Programming

The goal of this book is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and …

eBook

The Redgate Guide to SQL Server Team-based Development

This book shows how to use a mixture of home-grown scripts, native SQL Server tools, and Redgate tools to successfully develop database…

eBook

Inside the SQL Server Query Optimizer

This book will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you …

Video

SQL Source Control – an intro with Steve Jones

Steve Jones, SQL Server MVP and founder of SQL Server Central, explains how to share simple database changes between developers, using …

Video

How to lock objects in Redgate SQL Source Control

Microsoft MVP Alessandro Alpi explains how to use the new locking feature in Redgate SQL Source Control 4.

Article

119 SQL Code Smells

Every SQL code smell we could think of, in one handy reference guide.

Article

Basic Defence Database Programming Techniques

How to go about producing resilient TSQL code that works, and carries on working under stress.

eBook

SQL Server Source Control Basics

This book provides just the right combination of theory and practical example to get you started quickly with database source control.

Whitepaper

How to set up continuous integration for databases with Redgate tools

Once database version control is in place, you can take the next step with database continuous integration, enabling every committed ch…