Poor Work Management
The future of work is uncertain, but not everyone is ready for remote work to continue.
2021-09-20
99 reads
Editorials
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
86 reads
2021-09-17
110 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
165 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
109 reads
The State of Data Growth
Data continues to grow at incredible rates. That's good for those of us that make a living with data.
2021-09-11
80 reads
New Old Architectures
The idea of event driven, rather than tightly coupled architectures is one that Steve thinks data professionals should learn more about.
2021-09-10
104 reads
Patterns and Potential Problems
We use patterns in software development to make things easier. This is especially true in database changes. Steve reminds you that all solutions might have a downside of which you need to understand.
2021-09-08
127 reads
Live Your Life
On this holiday in the US, Steve reminds us that living a life we want and enjoy isn't something we should delay for the future.
2021-09-06
103 reads
The Leaves Are Changing, But Why?
I've recently moved house from Massachusetts to Oklahoma. Long story. Anyway, sitting in my new office looking out at the trees, some of the leaves are starting to change. Ah, Fall. Lovely Autumn colors... WAIT! Actually, something else is going on. Only a few trees are changing color. Word is, we've been a little dry […]
2021-09-04
88 reads
Blogs
Daily Coping 21 Sep 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
#PowershellBasics: Bulk insert.
In my last post I talked about invoke-sqlcmd. It’s a nice easy way to...
Lambda Architecture in data systems and possible meaning of this name
By Rayis Imayev
(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...
Forums
SQL to display HTML for Dropdown
I have created a webpage with a form that allows people to register for...
Difference between SaaS and web application?
I'm currently interested in self-hosting and I recognized that mostly it's about alternatives for...
Reducing Temp Table Scans when joining two temp tables using OR conditions
Hi all. I have also posted this on DBA Stack Exchange, but I'm posting...
Ask SSC