Who Built This Thing?
Do the people that build SQL Server really work with it? Steve Jones shares a short story from a recent trip to the Pacific Northwest.
Do the people that build SQL Server really work with it? Steve Jones shares a short story from a recent trip to the Pacific Northwest.
How can you find good employees? Steve Jones offers a few tips on what has worked for him in the past.
How can you find good employees? Steve Jones offers a few tips on what has worked for him in the past.
How can you find good employees? Steve Jones offers a few tips on what has worked for him in the past.
Steve Jones looks at the performance of column changes, petaflop computing, and a few ways to beef up your DBA skills.
Steve Jones looks at the performance of column changes, petaflop computing, and a few ways to beef up your DBA skills.
Steve Jones talks about two competing priorities for many people that start at a new job and asks which one you value more in this Friday poll.
One of the very common questions posted about T-SQL is how to traverse a hierarchy in a set based manner. New author Craig Hatley brings us his techniques for handling the common scenario of employees and managers.
How many of you have written resursive queries in SQL? Or any language since school for that matter? Not many people write recusrive queries because of the complexity, the difficulty to understand how they work, and the chance for heap overflows. However, SQL Server 2005 implements Common Table Expressions and recursion in a way that is much easier to code and incorporates some safeguards. New author SQL Server MVP Frederic Brouard has written a fantastic article looking at resursive queries.
A short review of this book by Ben Forta giving you the basics of T-SQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
CSTelpon : 0853-73737551 Jl. Jend. Sudirman No.99, RT.001/RW.007, Kranji, Kec. Bekasi Bar., Kota Bks,...
Jl. Duri Utara No.37 B, Duri Sel., Kec. Tambora, Kota Jakarta Barat, Daerah Khusus...
Ruko Cikarang Plaza, Jl. Yos Sudarso No.5 Blok B, RW.6, Cikarang, Kec. Cikarang Utara,...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers