Most of Us Are Vulnerable
Security is hard, and while data professionals might not be responsible for network issues, we ought to be aware that there could be vulnerabilities that might attack our systems.
2022-01-19
130 reads
Editorials
It Isn't Worth Automating
Every year I'm responsible for a portion of the Database Weekly newsletters. I used to do half, but right now Kathi, Grant, and I are on a rotation. Our boss puts out a schedule each year, which tells me the weeks for which I am responsible. Each January I then set up a recurring appointment […]
2022-01-17
108 reads
T-SQL Requires the Right Approach
Some of the most problematic T-SQL code I’ve seen over the years originated because the developer approached T-SQL with techniques more suitable for developing applications. I often saw these issues in my consulting days and always took the opportunity to teach the customer instead of only fixing the problems. One reason is that SQL is […]
2022-01-15
135 reads
2022-01-14
117 reads
Coding for the Future
Writing code that solves problems and adapts to the future is a challenge, but it's something we should think about.
2022-01-12
117 reads
Teams Security Issues
There are a few security issues in the Teams application from Microsoft, and Steve notes that some of the push for new features can be a problem in this area.
2022-01-10
110 reads
Where the World Takes You
We're launching into a new year and there are lots of "looking into the future" articles out there. Personally, I'm pretty jazzed for the coming year for any number of reasons (can you say "SQL Server 2022"?). However, I also get a little retrospective at times like this. Now, I'm not going to talk about […]
2022-01-08
55 reads
What Were Your 2021 Wins
The first poll question of the year has Steve asking you to look back at 2021 and pick something good that happened.
2022-01-07
51 reads
Challenging Trends
Steve notes the changes in the world might affect how to view and use data in our work.
2022-01-05
101 reads
Data Cleanup
Steve wishes we could do some data cleanup and archival every year. Or even more often.
2022-01-03
146 reads
Blogs
Creating a new User-Defined Data Type–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
A new chapter begins
In 2012 when I originally founded Born SQL, I never imagined I would find...
Daily Coping 19 Jan 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Recursive Triggers
I know there is, somewhere, T-SQL that will allow me to update (keep in...
How to get cummulative sum per column?
Hi, I have a statement per period. I want the periods to be cumulate. ...
Ask SSC