10 reasons to choose Flyway
Thousands of organizations use DevOps practices every day to deliver application changes. But what about the database? Excluding the database from your DevOps pipeline and processes risks application performance, data security and integrity. With Flyway, Redgate solves this challenge in one complete solution that sits inside your existing DevOps platform and processes. Find out the 10 reasons why organizations worldwide choose Flyway.
Different Ways to Format Currency Output in SQL
In this tutorial, we will show different ways to output different currency formats with the T-SQL language.
Be Prepared
I've been reading about the fires in Maui and the horrible loss of life there. My heart goes out to all involved. I hope, if you can, you donate to a good charity to help those poor people. It also inspired me to do another check on our emergency supplies and equipment. No, we don't […]
Removing Weak Security from SQL Server
The password options for BACKUP at deprecated, which Steve thinks is a good thing.
Managing the challenge of migrating to the cloud
Migrating to the cloud has many advantages … until you’re the one tasked with making it happen. For many data professionals, this will be a first step from the traditional, predictable challenges of managing on-premises servers to the many and varied databases and platforms in the cloud.
Screen Scraping with Python and BeautifulSoup Code Examples
BeautifulSoup (sometimes referred to as Beautiful Soup library) is one of several widely used screen scraping packages for a web page. It is highly regarded for its ease of use and power.
Screen scraping enables developers to create solutions that permit comparative analyses from all over the internet, such as web applications that look for the best price on an item from many different online stores.
Spot the Five Differences and Win a Summit Ticket
Spot all five differences below and enter our prize draw competition to be in with a chance of winning a 3-day pass to PASS Data Community Summit 2023.
Blogs
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Forums
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Encoding URLs
Comments posted to this topic are about the item Encoding URLs
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers