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.
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.
Data Sovereignty Issues
As legal requirements grow and change, cloud computing might require a new consideration: where we physically store data.
Scheduling PowerShell Using Jenkins
Introduction PowerShell is a task-based command-line shell and scripting language; it is designed specifically for system administrators and power-users, to rapidly automate the administration of multiple operating systems (Linux, OSX, and Windows) and the processes related to the applications that run on those operating systems. For system administrators (DBAs\Wintel Admins), creating PowerShell scripts is a […]
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.
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.
Is there a Difference in Virtual Events?
Steve wonders if any of you see much of a difference between any of the virtual events taking place today.
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.
Free eBook: Inside the SQL Server Query Optimizer
This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.
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.
Blogs
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
Forums
String_agg not working as needed
I'm trying to get this string_agg to put all the 'comments' into one result...
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers