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
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
Comments posted to this topic are about the item What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers