Database Updates: Rolling Back and Fixing Forward
Phil Factor's take on the best ways to reverse or accelerate your way out of the problems caused by a failed database update.
2020-12-11
Additional Articles
SQL Developer – A great tool and better ways to use it
SQL Developer is a popular free tool for working with Oracle databases. In this article Srinivasan Suresh explains several features of SQL Developer that can make you more productive.
2020-12-11
Deploy Database Objects to Multiple SQL Server Instances Using PowerShell
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
2020-12-10
More Gems from the SQL Prompt Treasure Chest
Join Microsoft MVP Grant Fritchey and Redgate's Owen Standage on a journey through the hidden treasures of SQL Prompt. Discover features of the unknown that will enable you to write, format, analyze and refactor your SQL effortlessly.
2020-12-10
DBA in training: Backups, SLAs, and restore strategies
There are a handful of options when backing up SQL Server databases. A DBA must understand the differences and come up with a plan that protects the organisation’s data. In this article, Pamela Mooney explains service level agreements, recovery models, and some strategies to ensure that the data can be restored quickly.
2020-12-09
Take the 2021 State of Database DevOps survey
It's your last chance to take part in the 2021 State of Database DevOps survey! If you or your organization uses databases, we want to hear from you! Complete the survey for advance access to the final research report, and to be entered into a prize draw for a $500 Amazon voucher. Plus, for each submission we receive, we’ll donate $1 to the World Health Organization’s COVID-19 Solidarity Response Fund. Take the survey here.
2020-12-09
Azure SQL Database TDE Customer Managed Keys
In this tip we will go through the steps for setting up customer managed keys or Bring your own key (BYOK) to be used for transparent data encryption for an Azure SQL Database.
2020-12-08
Join us for this year’s final Redgate Summit
With 2020 coming to a close, it's time to look at the new year ahead. Join our final 2020 summit this December 10th, to discover how to implement a generative culture for successful IT teams and how database DevOps will drive growth and ROI in a remote world. Register to tune in live or watch the recordings.
2020-12-08 (first published: 2020-12-02)
Export SQL Server Data to Multiple Excel Worksheets with C#
In this article we look at how to export data from different SQL Server tables or queries into multiple Excel sheets in the same file.
2020-12-07
How to Execute SSIS Packages from SQL Server Agent
Learn about best practices for developing SSIS packages that you want to execute from SQL Server Agent and the steps to follow.
2020-12-07 (first published: 2020-12-01)
Blogs
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Forums
Layanan BCA KCP Lemabang Cs 0823-7497-7784
Wa:082374977784 Jl. Laksamana Yos Sudarso No.128/4F, 3 Ilir, Kec. Ilir Tim. II, Kota Palembang,...
Alamat Telp BCA KCP Iskandar +62 838-4945-0961
Wa:083849450961 Jl. Letkol Iskandar No.51-52, 24 Ilir, Kec. Bukit Kecil, Kota Palembang, Sumatera Selatan...
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers