DBA 101: Tuning lookups
Sometimes it helps to go back to the basics and indexing is always a great topic. SQL Server has a...
2017-05-09 (first published: 2017-04-27)
3,110 reads
Confessions of a Microsoft Addict
Query tuning 101: What’s a probe residual?
Query tuning is an important process that will probably never go away and sharpening your tuning skills is always a...
2017-04-26 (first published: 2017-04-17)
3,335 reads
DBA 101: Comparing two SQL plans
Simple post today: How to compare two plans in SSMS.
This task is a task that is often done by a...
2017-04-18 (first published: 2017-04-14)
2,045 reads
Way Off-topic: Why cutting the cord was right for me
FYI: This one is way off topic so don’t expect to find any fancy SQL tips here.
I did it. I...
2017-04-14
491 reads
T-SQL Tuesday: Finding issues with your query plan
This is my first time blogging with a T-SQL Tuesday topic. If you follow my blog you’ve probably noticed that...
2017-04-11
493 reads
Wait Stats, Here and gone again?
Microsoft recently introduced a handy new feature to query plans: waitstats. That’s right, you can get actual runtime waitstats for...
2017-04-05
501 reads
New SSMS bug?
It seems like SSMS has seen better days. Many developers I have worked with recently complain about Out of Memory...
2017-03-22
628 reads
DBA 101: File growth
Maintaining a database is an important job of the DBA role. One of the many maintenance tasks is ensuring that...
2017-03-03
468 reads
DBA 101: Unique Constraint vs Unique Index
Designing a rock solid application and database can be difficult. New features and overlapping features mean that you’re able to...
2017-03-21 (first published: 2017-03-03)
3,561 reads
DBA 101: What you may be missing with “Missing indexes”
If you’ve read my blog, I’m sure by now you know that I have no love for GUI tools. I...
2017-02-15 (first published: 2017-02-08)
3,377 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