Tally Table - Delimited list to Table
Dealing with delimited lists (Usually separated by a comma) in SQL is a problem easily handled by a simple function...
2010-02-27
3,774 reads
Blog Posts
Article in SQL Server Magazine on SQL IO Stastics.......
Article on I/O tips appearing on SQLMag.com
If you've followed my blog, you know I've written on various topics, including I/O...
2010-02-26
1,942 reads
Book Review: Orbit by John J. Nance
Just finished re-reading Orbit ($15 or less at Amazon) after picking it up for a $1 at Books a Million...
2010-02-26
1,568 reads
Dr. DMV Script for Rocky Mountain Tech Trifecta
Here is the script that has the diagnostic queries that I will be using during my presentation at the Rocky...
2010-02-26
2,769 reads
Driving Issues with software
This is an interesting piece, talking about some of the software issues with Toyota and how that might come to...
2010-02-26
1,465 reads
Help with Learning Powershell
If you’re not reading Buck Woody’s blog, why not? Today he posted a helpful hint for getting performance counters directly...
2010-02-26
1,397 reads
More Snapshot Backups
I got some more feedback from my Connect item on allowing snapshot backups. They took notice, but I heard the...
2010-02-26
1,557 reads
Suncoast Technology Forum Tech Fest Event 2010
I presented a 30 minute session at Suncoast Technology Forum Tech Fest on Windows Scripting Automation with Powershell: "This session will...
2010-02-26
1,754 reads
User Group Leaders: Who Are Your Members?
At the MVP Summit last week, I was talking with fellow Dallas-area tweep Sean McCown about our local SQL Server...
2010-02-26
1,637 reads
What I’ve Read and Recommend to Others – General Database and Theory by C.J. Date
Date on Database: Writings 2000-2006
This is a collection of writings by C.J. Date, one of the fathers of the relational...
2010-02-26
1,884 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...
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