eBook

The Art of SQL Server FILESTREAM

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

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

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.

The Business Benefits of SQL Source Control

Whitepaper

The California Consumer Privacy Act and how it will affect your business

This whitepaper covers the six most commonly asked questions about the CCPA and provides clear answers to each. Download it so that you…

Blog post

The conflict between data protection and DevOps

Data breaches are the new normal, prompting data privacy legislation to pop up everywhere. Sarbanes-Oxley (SOX) and HIPAA are being joi…

Article

The GDPR: 6 principles that impact SQL Server teams

You'll learn how Redgate's solutions help to ensure the ongoing protection of personally identifiable information (PII) in SQL Server, …

Whitepaper

The new world of data privacy and protection for SQL Server

This whitepaper looks at what the changing data privacy and protection landscape means for organizations.

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

The Redgate Guide to Working with a Personal Assistant

by Lottie Mackintosh A truly effective assistant knows their manager’s priorities, concerns and responsibilities as well as they do themselves. They know how to...

Whitepaper

The State of Database Monitoring

How are 2500+ of your database professional peers meeting current and upcoming challenges? In these four insights reports, we examine …

Article

The State of SQL Server Monitoring (redirect)

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…

Video

The Value of Monitoring at BMW

With 100s of servers spanning multiple continents, BMW needed a way to efficiently monitor their large and growing estate. Learn how th…

Case study

The Value of Monitoring at BMW

With 100s of servers spanning multiple continents, BMW needed a way to efficiently monitor their large and growing estate. Learn how th…

Super SQL Tips

Tip #1: Save, customize, and share frequently used SQL snippets

Data Platform MVP Steve Jones explains how to use SQL Prompt to create and customize snippets for frequently used code, to save you tim…

Super SQL Tips

Tip #10: Don’t get lost in SQL – highlight all matching objects intelligently

Data Platform MVP Grant Fritchey explains how to use SQL Prompt to highlight matching objects, which'll help you clearly differentiate …

Super SQL Tips

Tip #11: Quick SQL Prompt actions at your fingertips

Redgate product marketing manager Carly Meichen explains how to quickly jump to some really handy SQL Prompt actions in the query windo…

Super SQL Tips

Tip #12: Safely refactor stored procedures in a flash

Data Platform MVP Ike Ellis explains how you can refactor SQL code quickly by creating a new stored procedure from within an existing s…

Super SQL Tips

Tip #13: Script objects as ALTER in two clicks

Data Platform MVP Steve Jones explains how to use SQL Prompt to script out objects as an ALTER statement in just a couple of clicks.

Super SQL Tips

Tip #14: Pay it forward – avoid ambiguity by renaming variables clearly

Data Platform MVP Grant Fritchey explains how to use SQL Prompt to rename all uses of a variable in one quick step.

Super SQL Tips

Tip #15: Pick just the columns you need for speedy results

Data Platform MVP Steve Jones explains how to use SQL Prompt to retrieve just the columns you need in a SELECT statement for speedy res…

Super SQL Tips

Tip #16: Write SQL quickly in Visual Studio: make the most of $placeholders$

Data Platform MVP Steve Jones explains how to use SQL Prompt in Visual Studio, to write SQL quickly and accurately with the help of pla…

Super SQL Tips

Tip #17: Write SQL quickly in Visual Studio: reorder $placeholders$

Data Platform MVP Steve Jones explains how to use SQL Prompt in Visual Studio to write SQL quickly and accurately with the help of plac…

Super SQL Tips

Tip #18: Write SQL quickly in Visual Studio: save time with code snippets

Data Platform MVP Steve Jones explains how to use SQL Prompt in Visual Studio to write SQL quickly and accurately with the help of code…

Video

Tip #19: Restore closed tabs with Tab History

In this tip Data Platform MVP Grant Fritchey explains how to use SQL Prompt to restore your tabs, even if you closed them by mistake!

Super SQL Tips

Tip #2: Popular snippets: SSF (SELECT * FROM)

Data Platform MVP Steve Jones explains how to make best use of one of SQL Prompt's most popular snippets, SSF.

Super SQL Tips

Tip #20: Know which environment you are working in with Tab Coloring

In this Super SQL Tip Data Platform MVP Grant Fritchey explains how to use SQL Prompt to color your tabs so you always know which envir…

Super SQL Tips

Tip #21: Create your style using the new formatting options in SQL Prompt

In this Super SQL Tip Software Engineer Andrei Rusitoru explains the fantastic new formatting options available in SQL Prompt 8 from Re…

Super SQL Tips

Tip #22: How to control code completion suggestions in SQL Prompt

In this Super SQL Tip Redgater Jamie Wallis explains how you can easily customize your code completion suggestions to pop-up less frequ…

Super SQL Tips

Tip #23: How to use code analysis in SQL Prompt

In this Super SQL Tip Redgater Jamie Wallis explains how you can get suggestions to improve as you type with new code analysis rules in…

Super SQL Tips

Tip #3: Are you sure you want to execute that UPDATE statement?

Bob Pusateri explains how SQL Prompt execution warnings can prevent you from making a costly change to your database.

Super SQL Tips

Tip #4: Popular snippets: CDB (CREATE DATABASE)

Data Platform MVP Steve Jones explains how to make best use of one of SQL Prompt's most popular snippets, CDB, to create new databases …

Super SQL Tips

Tip #5: Work quickly with data from the Results grid

Data Platform MVP Cathrine Wilhelmsen explains how to use SQL Prompt to quickly work with data from the Results grid in SQL Server Mana…

Super SQL Tips

Tip #6: #StopBadSQL: expand the wildcard and only retrieve columns you need

Data Platform MVP Steve Jones explains how to use SQL Prompt to expand wildcards and select only the columns you need, so you retrieve …

Super SQL Tips

Tip #7: Find invalid objects to catch problems early

Data Platform MVP Ike Ellis explains how to use SQL Prompt to find invalid objects, so you can catch problems earlier in development an…

Super SQL Tips

Tip #8: Safely refactor SQL code with Smart Rename

Redgate product marketing manager Carly Meichen explains how to use SQL Prompt to quickly and safely refactor SQL code.

Super SQL Tips

Tip #9: Popular snippets: II (INSERT INTO)

Data Platform MVP Steve Jones explains how to make best use of one of SQL Prompt's most popular snippets, II, for INSERT INTO statement…

Top 20 Toolbelt Tips

Tom Austin shares his top 20 tips for improving productivity, effectiveness and consistency across your development team with the help …

Article

Tracking SQL Server Agent Job Duration

We need to know not only when jobs fail, but also when they display uncharacteristic behavior. We need a way to track SQL Server Agent …

Training Session Recording – How and When to Use the Hybrid Workflow of SQL Source Control with SQL Change Automation Migrations – April 22nd 2020

Training Session Recording – How and When to Use the Hybrid Workflow of SQL Source Control with SQL Change Automation Migrations – April 22nd 2020

eBook

Tribal SQL

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

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.

Unboxing SQL Clone slides

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 …

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, …

eBook

Understanding SQL Server Concurrency

When you can't get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you…

Article

Using baselines and custom metrics in SQL Monitor

SQL Monitor Technical Author Anne Edwards explains how to check baselines for SQL Server performance metrics, and how to set up a new c…

Video

Using Flyway with MongoDB and Studio 3T

Product Manager Adam Britt demonstrates Flyway in action with MongoDB and Studio 3T.

Video

Using SQL Compare with Dynamic Data Masking (DDM)

Dynamic Data Masking (DDM) is an exciting new feature in SQL Server 2016 that means you can centrally set a mask that's returned for a …

Video

Using SQL Compare with In-Memory OLTP tables

If you’ve decided to implement In-Memory OLTP tables, Redgate SQL Compare is ready to safely handle your database changes.

Video

Using SQL Compare with Row Level Security (RLS)

Row Level Security (RLS) is one of many new features in SQL Server 2016. It provides an easier, consistent, and maintainable solution f…

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

Video

Verify your backups – NOW!

Grant Fritchey explains why you need to verify and restore your SQL Server backups regularly, to avoid being hit by data corruption whe…

voiceofthedba.com/2020/04/23/live-stairways-day-1-homework/

Super SQL Tips

Welcome to Super SQL Tips

In this series of short videos Data Platform MVPs and SQL Server experts share their tips for getting the most out of SQL Prompt. We ar…

Article

What changed on my SQL Server instance?

Let's say a user reports that the performance on their application seemed slower than normal that morning. Was it? And if so, what chan…

Documentation

What is SQL Clone?

A high level overview of what SQL Clone is, and what it means for database provisioning.

Blog post

What SOX means to the DBA

The responsibilities of a database administrator can seem endless, so why should that already heavy workload be burdened with legislati…

Video

What’s New in SQL Monitor 8

Redgate’s Jamie Wallis talks you through the new features released in SQL Monitor V8, including the Grouped Alert Inbox, Distributed …

Article

Why Everyone Developing T-SQL Needs to Learn About Graphical Execution Plans

In this Simple Talk article Microsoft Data Platform MVP Kathi Kellenberger explains why understanding graphical execution plans is cr…

Article

Why Organizations Choose Flyway

If you’re looking to improve the speed and reliability of your organization’s database delivery, many options exist on the market. …

Video

Working with Flyway Enterprise and Snowflake

Adam Britt walks through how Flyway can be used with Snowflake and Github Actions

www.sqlservercentral.com/steps/stairway-to-dax-and-power-bi-level-3-the-dax-distinct-function-and-basic-distinct-counts

www.sqlservercentral.com/steps/stairway-to-dax-and-power-bi-level-6-the-dax-sum-and-sumx-functions

www.sqlservercentral.com/steps/stairway-to-dax-and-power-bi-level-7-function-iterator-function-pairs-the-dax-average-and-averagex-functions

www.sqlservercentral.com/steps/stairway-to-dax-and-power-bi-level-8-the-dax-count-and-countx-functions

Video

Yes you should monitor Azure SQL Database

In his session from SQL in the City Streamed Grant Fritchey explains why you need to be monitoring your Azure SQL databases, what you s…