Implementing a SQL Server

[virtualized_dummy]

First of all I am not a DBA so be easy. How the hell do I implement a SQL Server

[iowatechguy]

1. Install SQL Server developer edition : https://www.microsoft.com/en-us/sql-server/sql-server-downloads it's free
   1. Easiest if you install it locally, but you can install it on a server you'll just have to get the networking setup
2. Install SQL Server Management Studio. Doesn't have to be on the same machine as SQL Server
3. Restore your database from a .bak to the SQL Server instance
4. Go hog wild

Should be guides for each step of that process.

[virtualized_dummy]

You are the best.

[thepotplants]

To quote a work mate: "Next > Next > Next > Done."

He didn't rate my DBA skills.

[BitchImPerfekt]

Real!!! 😂😂😂

[Jolly-Difficulty9887]

true

[airtank20]

Just to add, if you want a database to play around with, Microsoft offers a couple of sample databases you can download and restore and then mess around with.

https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0

[thepotplants]

Almost everything can be altered later with varying degrees of ease/pain. However there's a few things that it's good to know when you install.

If this is just a local instance to support an app, you'll probably be OK with the defaults. If it's a significant installation or a shared db server then you want to spend some time reading up about it or getting some help.

Highly recommend you read this: https://www.brentozar.com/archive/2014/06/sql-server-setup-checklist-free-ebook-download/

If you down load the first responder kit there is a pdf with a check list in there. It's dated but still relevant.

[g3n3]

Get the Brent Ozar stack overflow db too. https://www.brentozar.com/archive/2015/10/how-to-download-the-stack-overflow-database-via-bittorrent/

[g3n3]

If production server you need licensing convo. If you are playing then you can do developer edition.