What size Nvme M.2 is besst capacity wise. I have a Minis Forum NAB I9 12900H CPU 32 gig ram 1TB NVme as my C drive no other available drives to be able to put in it outside of replacing with a larger one.
Also can not seem to find where to sign up for the $1.00 lissons and the 5.99 one on your website
Sami Shamma
@Reply 4 months ago
Rodney what you currently have is sufficient and perhaps more than sufficient for installing SQL Server. That assumes that the size of the database that you are creating is not that huge.
I have customers running production software with a significant amount of transactions and their SQL database is still in tens of megabytes
Matt Hall
@Reply 4 months ago
Rodney what Sami Said. That is really a solid machine. The GPU is the most limiting aspect and you shouldn't have an issue with that, unless you try gaming or rendering graphics. For an SQL Server back end, that should be more than sufficient. I have mine test-running on an old laptop with much lower specs including graphics, without issue. For reference, I have about a 30 tables. A half dozen have 25,000-60,000 records and a couple of those exceed 25 fields.
For what you're doing, 1TB is already plenty, especially if this machine is mainly for learning SQL Server and running development or small production databases. SQL Server itself doesn't take up that much space, and most Access-style backends or training databases stay relatively small unless you're storing large files or years of transaction history.
If you're thinking about upgrading, I usually tell people 2TB is the sweet spot right now for price vs capacity on an NVMe M.2. It gives you breathing room for database growth, backups, VM images, and other projects without going overboard. 4TB is nice but tends to cost a lot more per gig and is only really worth it if you know you'll use the space. Since your system only has one slot, just make sure you've got a good backup before cloning or swapping the drive.
As for the lessons, you can purchase directly on the Order page, or you can sign up for the Learning Connection and get one every week at a 50% discount, or you can get them as your free monthly class for being a Gold member. Lots of options.
Matt Hall
@Reply 4 months ago
You are right about that. The SSD prices have spiked in the last 6 months, like more than double. For the current cost of a 4 TB SSD, you can start looking for Nas systems to get more secured storage.
Rodney MaedkeOP
@Reply 4 months ago
Thanks for all the feedback from all of you. At going to be 76 March 1 and highly visually impaired like Richard and Gordi.
I am working on all different DB's example church and our small cemetery now just to keep my memory functioning with all the challenges that old age brings us.
By the Grace of God, all is well Thanks again. Looking forward to Quick Quies and tech help and other lessons as my limited income allows.
Jerry Fowler
@Reply 4 months ago
Rodney, you give me hope. I'm about to turn 68 and love learning new things every day! At a young age, my eldest brother taught me "the only bad day is a day that you don't learn something." I've lived my life by that and Richard makes sure I have a means to do so.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Data Entry.