What’s Using Space in Tempdb?
It happens, not often, but I do regularly see people talking about their tempdb growing too large. Often that means...
2009-11-30
14,991 reads
Blog Posts
When it rains…
It pours.
I come back from 4 days unwired, a bunch of writing done, to a laptop that’s head, a site...
2009-11-30
1,424 reads
XQuery For Idiots
I’m still struggling with learning XQuery. My latest little revelation was small, but vital.
The difference between:
@inXML.nodes('/rss/channel/item')and
@inXML.nodes('/rss[1]/channel[1]/item')Is the difference between a...
2009-11-30
1,745 reads
Featured Blogger: Rob Garrison
I met Rob via email early this year as a volunteer helping with content for PASS, and I’ve been following...
2009-11-29
1,417 reads
Kevin Kline on PASS
Brian Moran (incoming Board member) did a nice interview with Kevin, worth reading, and some good stuff about areas where...
2009-11-29
1,384 reads
Link: Top 200 Developer Blogs
Ran across this list a while back, Jurgen posted his Top 200 Developer Blogs list and an OPML file of...
2009-11-29
1,399 reads
weekly update
Well I said that I would try to post regularly and seeing as its Sunday and I haven’t posted for...
2009-11-29
589 reads
Picking a Branch
Do you know that there are actually two branches of SQL Server 2008 code right now? Actually I would bet...
2009-11-27
987 reads
Adios
If all goes well, by the time you read this on Thanksgiving I’ll be up in the mountains of Colorado....
2009-11-26
769 reads
Book Review: Let’s Create (for children)
I’m fond of browsing the discount shelf at the bookstore, it’s another way to see books that I might otherwise...
2009-11-26
577 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers