Leaving aside, for a second, Freud’s psychoanalytical definitions, the term “ego” generally refers to a person’s sense of self, and their self-esteem. In casual usage, however, it usually appears in the adjectival form, “egotistical” (most often followed by “jerk”). You don’t need to be a jerk to be a DBA; humility is important. However, ego is important […]
2021-06-26
285 reads
Of all the valuable attributes of a DBA, from passion to humility to practicality, perhaps one of the most important attributes may turn out to be the most seemingly nebulous: foresight. According to Free Dictionary, foresight is the "perception of the significance and nature of events before they have occurred". Foresight does not come naturally to most people, as the […]
2021-05-15
310 reads
Releases of on-premises SQL Server arrived quite rapidly for a few years with seven releases during the years spanning 2008 and 2019. While it has technically been less than two years since SQL Server 2019 reached general availability in November 2019, it feels like ages since we have heard any news about what’s coming next. […]
2021-04-24
1,822 reads
2021-04-10
120 reads
Databases don't manage themselves, but Steve sees this as an opportunity, not a problem.
2021-03-20
100 reads
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
160 reads
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,778 reads
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
107 reads
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
112 reads
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
I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow...
By Steve Jones
I had a suggestion from somone on a place where AI helps them and...
Disclaimer: this post is not sponsored by Redgate 🙂 For those who’ve missed it,...
Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...
Comments posted to this topic are about the item Does Version Control Scare You
Comments posted to this topic are about the item Unlimited Text
If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?
See possible answers