Why Doesn't Database Software Help Us?
Databases don't manage themselves, but Steve sees this as an opportunity, not a problem.
2021-03-20
100 reads
Database Weekly
New Options for Training and Learning
In 2008, I managed to achieve the goal of becoming a Microsoft Certified Trainer. Once I achieved the status, Microsoft shipped me a binder with dozens of DVDs containing lab VMs and class materials for all the current classes. At some point, instead of receiving DVDs, you were expected to download images which was quite […]
2021-03-13
159 reads
Common Table Expression Misunderstandings
I frequently use Common Table Expressions (CTEs) when I demo windowing functions and get questions about them. Windowing functions are limited to the SELECT and ORDER BY clause which means that you can’t filter or group on them directly. Using a CTE is one way to separate the logic of the query into multiple steps […]
2021-02-27
3,068 reads
Looking to Role Models
Each of us can inspire and be a role model for others. Steve notes that the WIT group is doing that with an event on March 5th.
2021-02-13
106 reads
Let it go
I’ve been digging through the 18 years’ worth of articles, editorials, blogs, contests, interviews, promotions, and announcements over at Simple Talk. There are over 5000 posts, and many are quite outdated, especially those announcing beta versions of software or other time-sensitive content. Some articles haven’t seen the light of day for 10 years, yet some […]
2021-02-06
111 reads
Who is my customer?
My final job in my previous career was at a hospital. I worked there for five years in the 90s before getting my first position as a developer. While I didn’t love the career I was leaving, I did appreciate what I learned from that last job. Part of the onboarding included a short class […]
2021-01-16
121 reads
Easy Data Access Plus Security
As I type this, I've got my right leg propped up on a stool. That's because if I sit for any length of time with the knee bent, I have a great deal of pain on standing. Seems there's something horribly wrong with my knee. I still don't know what yet. I've had an MRI […]
2021-01-09
57 reads
2021-01-02
78 reads
Goodbye to PASS
On December 17, the PASS organization announced the news that it would cease operations on January 15, 2021. Since the announcement, folks have been scrambling to figure out how to keep their user groups and events going or downloading recordings. By the way, if you need assistance with your user group, please reach out to […]
2020-12-26
195 reads
2020-12-19
78 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...