Lifehacking – Not such a good idea?
I read the confessions of a recovering Lifehacker and thought it was an interesting read. It seems that the author...
2012-05-23
1,020 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
The Tally Table and Expanding Rows
Suppose you had some data like this:
Class Limit
————— ———–
Calculus 5
History 4
Physics 2
But what you really want is this:
Class ...
2012-05-22
1,463 reads
The TCO of the Cloud
When is the cloud right for your databases? Steve Jones talks about some metrics and ways you can measure your usage to determine when it makes sense.
2012-05-22
108 reads
Continuous Releases
The idea of continuous development, integration and release can be a way to get your software in use by clients quicker. Steve Jones talks about releases, and some benefits you might get.
2012-05-21
154 reads
Password Handling
A system administrator can set a good example with the passwords they give to users or a bad example. Which one do you set?
2012-05-18
247 reads
Rocky Mountain Tech Trifecta 2012
My fourth visit to the Rocky Mountain Tech Trifecta will be tomorrow where I’ll deliver two talks:
Branding Yourself for a...
2012-05-18
1,117 reads
Do Interviews Work?
Interviews are the way we primarily make hiring decisions but as Steve Jones notes, we don't really end up doing a very good job of picking good employees in many cases.
2012-05-17
320 reads
What is Big Data?
The definition of Big Data is rather murky, despite all the press and attention given to it. Steve Jones talks about what Big Data means for relational databases.
2012-05-16
733 reads
Self Service SQL
Self service in IT is something Steve Jones likes, but it doesn't solve all problems, and might end up creating more issues.
2012-05-15
233 reads
The Cloud is Nothing New
Cloud computing doesn’t seem to have any great definition. Like the physical structures is is named for, it is amorphous,...
2012-05-15
1,453 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers