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
277 reads
The future of work is uncertain, but not everyone is ready for remote work to continue.
2021-09-20
276 reads
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
197 reads
2021-09-17
153 reads
Your manager doesn't always know what you're doing, and rarely knows what you've done. That's your job.
2021-09-15
202 reads
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
243 reads
Data continues to grow at incredible rates. That's good for those of us that make a living with data.
2021-09-11
243 reads
The idea of event driven, rather than tightly coupled architectures is one that Steve thinks data professionals should learn more about.
2021-09-10
279 reads
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
171 reads
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
160 reads
Have you ever wondered where a certain field is used in a report? Or...
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Comments posted to this topic are about the item A Strange Query
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
I am using the following script to import data from a json file. This...
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers