Incident Review
After an outage, how do you respond to the issue in the future? A good review of the incident should be a learning opportunity.
2021-09-29
147 reads
Editorials
Making Software Decisions
The process of building software for others involves lots of decisions. Ensuring that you are making good decisions can impact how others view your final product.
2021-09-27
190 reads
Volunteer For Something
I spent a chunk of the day yesterday, after work, but before working on a new book (yeah, I've got two jobs now), playing with my radios. I was programming the digital one to get it to use my Raspberry Pi as a hotspot (it used to work, now it doesn't). I also spent some […]
2021-09-25
214 reads
Thank a Mentor
There is almost always someone that helps us in our career with mentorship. Today Steve suggests you thank them.
2021-09-24
79 reads
To Inifinity and Beyond With 1=1
There is some code that might work, but could lead others astray in the future. Today Steve notes that we ought to write code that sets a good example, and a loop that potentially runs forever isn't that type of code.
2021-09-22
287 reads
Poor Work Management
The future of work is uncertain, but not everyone is ready for remote work to continue.
2021-09-20
290 reads
All the Tools in Your Toolbox
I recently began writing an article to compare the performance of several window functions to traditional query methods. I began with my favorite function, LAG, but soon found that there were so many other ways to write the query that the article never covered the additional window functions. The article was quite fun to write, […]
2021-09-18
210 reads
2021-09-17
173 reads
Help Your Manager
Your manager doesn't always know what you're doing, and rarely knows what you've done. That's your job.
2021-09-15
206 reads
Unix vs PowerShell
I saw an article on using awk, sed, and grep on Linux. I used to know how to use those, though I was by no means an expert. However, working with a stream of text with an input and output was a valuable skill I've used over and over in my career. There are plenty […]
2021-09-13
266 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers