Viewing 15 posts - 31 through 45 (of 514 total)
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
Our industry is beset by chasing the shiny. It happens on all sides of the house, development, operations, support...and it's deadly. Yes, if a new tool comes along that obviously...
January 22, 2020 at 1:50 pm
Yes, because MONEY is a precise data type with 4 decimal places. It's implemented as a 64-bit integer, scaled down by 10000. That and DATETIME must be the two...
January 16, 2020 at 3:09 pm
I am intested to know how the people who answered this correctly figured it out 🙂
Run the code 🙂 Then try to figure out what the hell SQL did...
January 16, 2020 at 1:51 pm
Password managers are not a good idea. Sure, they let you use all the crazy random passwords per site, but they represent a single point of vulnerability. Hack them and...
January 15, 2020 at 1:51 pm
Automating processes is a double-edged sword. As one wit put it "It makes mistakes faster than ever!". 🙂
And yes, managers ALWAYS view automation as a way to cut payroll. Full...
January 8, 2020 at 1:29 pm
A couple of observations on the tools. First, the developers I know using Visual Studio Code are using it to develop using typescript and HTML. I personally wouldn't want...
December 19, 2019 at 8:43 pm
I use both SSMS and Visual Studio w/ Resharper, but then I do exactly zero cloud development (a security nightmare if there ever was one). And while Notepad++ is my...
December 19, 2019 at 1:25 pm
Are you going to have more than 2 million records in the table? If so, probably want that to be a bigint.
Heh... I know you...
December 3, 2019 at 6:06 pm
I think the topic has strayed from the original question so it may be worth making two points about customer identifiers. Firstly, IDENTITY is likely not very convenient as...
December 3, 2019 at 1:53 pm
Viewing 15 posts - 31 through 45 (of 514 total)