I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter asked about the difference between Min() and First_value. This post looks at a few cases....
2024-12-13 (first published: 2024-12-04)
706 reads
Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since that time, we have observed an intriguing phenomenon when encountering a login failure. To demonstrate...
2024-12-13 (first published: 2024-12-10)
506 reads
Can an AI help me with some database API work? Let’s see. This is part of a series of experiments with AI systems. The Scenario One of the things...
2024-12-11
128 reads
This post comes off the back of my last, where I looked at issues caused by explicitly declaring a large number of values in an IN clause. The query...
2024-12-11 (first published: 2024-12-04)
929 reads
The post Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch appeared first on Joyful Craftsmen.
2024-12-11 (first published: 2024-12-05)
1,057 reads
SQL Server has evolved a great deal since I first started working with SQL Server 6.5 in 1998. Unfortunately I continually come across newer systems that are configured with...
2024-12-10
81 reads
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether you're in data analysis, data science, or any field that uses data. Trust me, it's...
2024-12-10
261 reads
It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve gotten to #181. That’s over 15 years of monthly blog parties. This month we have...
2024-12-10
39 reads
One of our internal people was looking to test some process in (I assume) Redgate Monitor and needed more job history than they had in msdb.sysjobhistory. They wanted to...
2024-12-09 (first published: 2024-11-27)
239 reads
Have you ever wondered where a certain field is used in a report? Or maybe you need an easy way to find broken field references in a report? Certain...
2024-12-09 (first published: 2024-11-27)
418 reads
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
By gbargsley
This is Week 1 of PowerShell Strikes Back – a four-week May series for...
By Steve Jones
This happened to me recently after being busy with non-data modeling tasks for a...
BCA Finance - Depok HUB.Tlpn.0821•3111•185 Komplek Perkantoran, Ruko Pesona View, Jl. Pesona Khayangan Jl....
BCA KCU KALIMALANG HUB.Tlpn.0821•3111•185 Jl. Tarum Barat Blk. E No.5, Wil. Kota, Kec. Duren...
BCA KCP Buaran Raya HUB.Tlpn.0821•3111•185 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers