Sometimes a change is as good as a break : T-SQL Tuesday #134
James McGillivray (blog|twitter) wants us to give him a break. Well. Actually I guess he wants to know how we ... Continue reading
2021-01-12
141 reads
SQLStudies
SQL Homework – January 2020 – Create an End of Year/New Year checklist.
It’s a brand new year and hopefully it will be better than last year. While that may be particularly true ... Continue reading
2021-01-11 (first published: 2021-01-05)
362 reads
SQL Homework – January 2020 – Create an End of Year/New Year checklist.
It’s a brand new year and hopefully it will be better than last year. While that may be particularly true ... Continue reading
2021-01-05
14 reads
Hope!
2020 was a rough year. We’ve had friends and family leave us. Jobs lost. Health scares a plenty and that’s ... Continue reading
2020-12-31
65 reads
SQL Homework – December 2020 – Participate in the Advent of Code.
Christmas. Depending on where you live it’s a big deal even if you aren’t Christian. It pervades almost every aspect ... Continue reading
2020-12-03
85 reads
How do I tell what compression level my tables/indexes are?
It’s been a while since I worked with compression and the other day I needed to check which of my ... Continue reading
2020-11-27 (first published: 2020-11-17)
507 reads
A quick and dirty scan of a list of instances using a dynamic linked server.
Note: This is not exactly a dyanmic linked server. It just gets dropped and recreated in a loop. I recently ... Continue reading
2020-11-23 (first published: 2020-11-12)
339 reads
I get by with a little help from my friends : T-SQL Tuesday #132
Taiob Ali (blog|twitter) is our host for TSQL Tuesday this month and he’d like us to talk about how our ... Continue reading
2020-11-13 (first published: 2020-11-10)
266 reads
Adding a user to an Azure SQL DB
Creating a user is simple right? Yes and no. First of all, at least in SSMS it appears you don’t ... Continue reading
2020-11-19 (first published: 2020-11-05)
360 reads
SQL Homework – November 2020 – Help!
If you ask any senior IT person What is the most important tool you have? there is a decent chance that ... Continue reading
2020-11-10 (first published: 2020-11-03)
587 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
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Converting Money
Comments posted to this topic are about the item Converting Money
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
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