Viewing 15 posts - 16 through 30 (of 508 total)
In today's cloud world vendor lock-in is an issue with most stored procedures being DB platform specific (MSSQL vs PLSQL vs MySQL). Having to deploy an additional server...
March 6, 2020 at 4:40 pm
First, what David Poole said. 🙂
In my career I've been primarily a lone wolf developer. Meaning I've had to be ruthless in finding every trick to lessen my workload. Databases...
March 6, 2020 at 3:07 pm
And yet we rush to the cloud, increasing our attack surface to an unimaginable degree.
The basic problem is two fold. One, the whole problem is far too complex. Developers pile...
March 5, 2020 at 2:08 pm
Your examples simply point out the wrong questions were being asked. Of course if you leave later you tend to be late. Unless, of course, the intent of the question...
March 3, 2020 at 1:09 pm
amen to customers screwing up CSV files, adding columns etc. 🙂
and I get the difference in import format files (csv, XML etc) and that you have to create new...
March 2, 2020 at 7:55 pm
Yes, I totally agree unfortunately that is not possible to have the format changed ...
Sometimes we have to work with what we are given ....
🙂
Actually, you can...
March 2, 2020 at 4:48 pm
Yes, I totally agree unfortunately that is not possible to have the format changed ...
Sometimes we have to work with what we are given ....
🙂
Actually, you can cheat a...
March 2, 2020 at 2:38 pm
Yep, everyone knows rule #1 of The Culture. 🙂
Steve, remember the importance of Me time. Sometimes tech types are a little OCD and focus too hard on the new shiny...
February 28, 2020 at 2:04 pm
Playing devil's advocate for a moment, perhaps we're nearing the point of public backlash. They are already starting to come down hard on data being collected, it wouldn't take much...
February 27, 2020 at 1:05 pm
Hi,
I noticed the author used an ID column of IDENTITY as the PK in every table. This appears to be a best practice based on what i've read online....
February 18, 2020 at 9:38 pm
Nice article!
My only quibble is your last example, adding a zip code table. The problem is that zip code and city do not have a 1:1 correspondence. It...
February 18, 2020 at 9:20 pm
Nice article!
My only quibble is your last example, adding a zip code table. The problem is that zip code and city do not have a 1:1 correspondence. It is entirely...
February 18, 2020 at 2:13 pm
Maybe upskilling is a worry for some, but frankly a developer who doesn't understand how to leverage SQL Server to their advantage will not even see the need for DevOps....
February 12, 2020 at 1:45 pm
Code review is wonderful. Wish I could get it. Code review is impossible for lone wolf developers like me because there literally is no one else who can review my...
February 7, 2020 at 1:51 pm
Call me old fashioned but I'm still using TortoiseSVN tied into both Visual Studio (for the front end) and Windows Explorer for the SQL scripts.
Which, to be honest is only...
February 4, 2020 at 6:59 pm
Viewing 15 posts - 16 through 30 (of 508 total)