Fill Out The State of the Database Landscape Survey and Maybe Win
If you’re like me, you sometimes wonder how different other environments are from the one I work in. Well, the ones I used to work in. These days I...
2023-08-15
15 reads
The Voice of the DBA
Decrypting Stored Procedures The Cumbersome Way
I had a client that was struggling with some encrypted stored procedures. They needed to decrypt them, which I know is a pain in the #@$%@#$@#$#@. I had to...
2023-09-04 (first published: 2023-08-14)
1,967 reads
Friday Flyway Tips: Searching Migrations
When a Flyway Desktop (FWD) project (or Flyway project) has been around for a long time, there can be a lot of migration scripts. That can be a pain...
2023-09-15 (first published: 2023-08-11)
114 reads
A New Word: Aubadoir
aubadoir – n. the outworldly atmosphere just before 5 am, when the bleary melodrama of an extremely late night becomes awkwardly conflated with the industrious flourescence of a very...
2023-08-11
204 reads
Webinar: Unlock the Full Potential of Flyway to Achieve Automated Database Releases
On Aug 22, 2023, I’m co-hosting a webinar with Anderson Rangel, Redgate Solution Engineer in Brisbane. You can register here for the 11am AEST webinar. No, I’m not going...
2023-08-11
25 reads
The 2023 Redgate UK DevOps Roadshow
Years ago Redgate did some traveling events under the SQL in the City brand. These were a lot of fun and kind of amazing. One of the longer tours...
2023-08-10
34 reads
Finding Encrypted Stored Procedures–#SQLNewBlogger
I had a client ask about how to deal with encrypted stored procedures in their database. This post looks at how to find them and I’ll have future posts...
2023-08-09
296 reads
T-SQL Tuesday #165–Job Titles
This T-SQL Tuesday is from a new host, Josephine Bush, leader of the Boulder group just North of me. It’s an interesting invitation, asking what our job titles really...
2023-08-08
215 reads
A Multitude of Summary Views in SQL Compare 15
A client asked for a summary of changes, so I wrote a post to show where to find this in SQL Compare 15. As I was checking out the...
2023-09-08 (first published: 2023-08-07)
215 reads
100 Days to the Data Community Summit Keynote
The start of learning at the 2023 PASS Data Community Summit is 100 days away. I checked. The Summit starts for many of us on Monday with precons or...
2023-08-07
43 reads
Blogs
AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared
Both SQL Server and PostgreSQL are moving fast into AI territory — and if...
Monday Monitor Tips: AI Alert Analysis
By Steve Jones
We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
Forums
Bank BCA KCU Tanjung Pinang telp 0817 844 112
WhatsApp Cs,0817844112 Jl. Sunaryo, Kemboja, Kec. Tanjungpinang Bar., Kota Tanjung Pinang, Kepulauan Riau 29112
Bank BCA KCU Batam telp 0817 844 112
WhatsApp Cs,0817844112 Jl. Raja Ali H. No.18, Sei Jodoh, Kec. Batu Ampar, Kota Batam,...
Bank BCA KCU Pekanbaru telp 0817 844 112
WhatsApp Cs,0817844112 Jl. Jend. Sudirman No.448, Tanah Datar, Kec. Pekanbaru Kota, Kota Pekanbaru, Riau...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers