It's free for everybody! Same with the Developer Edition of SQL.
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
https://www.microsoft.com/en-us/sql-server/application-development
SQL Server Management Studio + SQL Server Developer Edition. They're free.
why not just get SSMS and learn some basic SQL? its free
although LINQ to SQL is sexy. however free linqpad does not include intellisense so not having that and not knowing the depths of LINQ/lambda land its hard for a newbie to C# IMO
Have you considered using SQL Server Management Studio (SSMS) to configure your SQL database. It's a dedicated program from Microsoft to administer SQL databases
I've not used the inbuilt VS tools for SQL server for a long time but always found them a little lackluster.
? SSMS... expensive? It's free for the developer edition. You can always connect to LocalHost and start a DB service, without having to get a separate server spun up.
Microsoft has a similar developer-friendly business model as Oracle & Java. They have a very vested interest in making as many people familiar with their tools as possible, so employers can reliably get people with skills on their tech stack.
As others said download ssms and install it on your machine. Then connect to the server.
If you can't connect, it may be the SQL admin needs to add your account to the server and configure your permissions. Though you may already be in an Active Directory group with rights.
I would recommend the following:
Download and install SQL Server Developer Edition. Make sure to: A) keep the default instance name (which should be "MSSQLSERVER"), B) keep track of the sa user and the password for it, and C) open the server to network connections. The installer has options for all of these things.
Also install SQL Server Management Studio. ("SSMS" for short.)
Open SSMS and connect to your localhost server instance.
In the Object Explorer pane's treeview, expand the server node, right click on the Databases node, and choose the "Attach" option. Select the .MDF file your code-buddy gave you, and complete the attachment dialog. This may take a few seconds to a minute, depending on the database size.
Change your connection string to: Data Source=localhost; Initial Catalog={whatever your database is named}; Integrated Security=true
Go to the SSMS website. On the right side of the page is a link that says "Previous Versions".
Although I'm not sure why you're running Windows 10 from November 2015. That's frighteningly insecure.
Can you try installing a newer version? https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
I would try running a repair on the .NET framework or a sfc /scannow
SSMS is a free download from Microsoft and you don’t need SQL Server Express for it. You can just download the standalone application and connect it to any number of SQL Servers.
So many people ask this question. The solution for SQL is so simple: just start using it! I guarantee that in the space of 4 hours you will have a full page of SQL code that you created from nothing.
​
Try this:
Hmm, when people say "learn SQL" what they should be saying is learn how relational databases work, how to setup and configure at least one of them, and learn SQL.
SQL is not like other languages, theres an entire structure and set of standards that live underneath it that you have to at least somewhat understand in order to be make smart decisions.
As for how to actually learn that, I would..
Setup your own relational database management system (preferably in a virtual machine)
Start playing around with some tools to interface with the DB system
Then start poking into how a real database looks
That looks like a lot scarier of stuff than it actually is and I'm sure theres plenty of youtube tutorials to get you started.
So, that is a weird issue.. Sometimes, you could have broken permissions somewhere or it could be trying to access another file that it doesn't have permissions to for whatever reason.
Is your pc connected to a domain, is it a possibility that you installed it as a local user and logged in as a domain user? To check this you can always type whoami in cmd.
If you didn't change the default location of the database and log drives they should be located in or around : C:\Program Files\Microsoft SQL Server\MSSQLxx.MyInstance\ (Might say something other than Microsoft SQL Server, and the xx in MSSQL"xx" will be different depending on your installed version. If you didn't change the instance name that should be called something along the lines of SQLExpress from what I've seen on servers in the past. Have you tried event viewer? - That may give you more insight into what is going on.
So you should be okay reinstalling SSMS, it is just the program to access SQL. They are completely separate instances. You could also just download SSMS by itself and try the new version. After SQLServer 2016, they don't even include it in the installation anymore you gotta download it. I believe its 17.x.x at the moment.
I use it on most of my server and it has worked flawlessly.
edit: a bunch of stuff.
Start with SQL Server Express it's a free version of SQL Server that (assuming you have a fairly new laptop or desktop) you can install and run locally. You'll also need SQL Server Management Studio to manage and query the database.
Let us know if you have any questions! Good Luck!
PS: Join us over at /r/SQLServer/ for more specific stuff pertaining to Microsoft SQL Server.
The developer edition or SQL express are free to use. Installation is very straight forward if you don't have specific application requirements.
If I were you, I would download the developer edition of SQL here:
https://www.microsoft.com/en-us/sql-server/sql-server-editions-express
SSMS (SQL Management Studio) here (you need this to work with the database)
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
Then you can attach the ACT database to the database engine and run your extracts.
Hope that helps!
I've started making databases with Access and I find it's a good tool for beginners. Saying Access is bad because of problems professional programmers may have doesn't make sense for a junior. Microsoft offers good tools and tutorials to get started with SQL and database design.
In comparison I find phpMyAdmin cumbersome and prone to errors. MySQL Workbench or the MySQL console is better, but the documentation can be hard to navigate through. I've never head about SQL Buddy.
Edit : Now I've found the name back, I'd say forget Access and go straight to SQL Server Management Studio. Learning SQL with it was just awesome. It can import database schema made with Access.
Edit: orthograph.
Unfortunately Access has a 2GB limit - for table size and objects (queries etc), which is why it’s nifty for small data sets, packs in some nice features, however I have a feeling 8 million rows + whatever queries are ran on that will be greater than 2GB.
OP - looks like you’ve had some support in bearings, SQL server’s free editions (available here) and it’s accompanying software SQL server management studio (here) are a good place to begin, there are beyond a ton of YouTube videos on setup and use of you’re not sure what to do, I can link some (if you need them?)
I believe SQL Server Management Studio comes with local databases that are pretty easy to use.
I believe this is the link with the download. It struggled to load since I'm in a Les Schwab.
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
Have you tried updating SSMS to 18.9.2?
I still think it's ssms working against the version of SQL and not the other way around.
SQL Management Studio will likely already be installed on your SCCM server. It's the tool used to manage SQL Server, it depends a bit on where your SQL DB is, but a lot of installations of SCCM have SQL and SCCM on the same box. You can find out where SQL is in the console. Go to the admin node. Click Site Configuration. In here you'll see a list of servers and site system roles. One of these will have a role of "Site Database Server". That's your SQL server. If this server doesn't have SQL Management Studio installed on it, you can just put it on by downloading it from here Download SQL Server Management Studio (SSMS) - SQL Server Management Studio (SSMS) | Microsoft Docs
It sounds like you are already connecting to the database so you have SELECT-level access now for sure, at least to the specific DB / tables that your current script is hitting. Do you know the credentials? Try installing SSMS and see if you can get on the actual server - this will allow you much more freedom. Although probably faster and easier to check with your IT if they are accessible to you. Keep in mind that you will likely not have access to CREATE / ALTER / DELETE / DROP queries, tables, functions or stored procedures on the main database(s), however you can always request your own personal datamart / sandbox with all user entitlements available.
Definitely make some time to get more familiar with databases. If your local tech school has an IT program, they are probably doing free or deeply discounted online classes right now; take CPT-242 and then CPT-202 ASAP (or concurrently if your work schedule will let you handle it). You can probably grab an associates / DBA cert from them without too much trouble. Stay curious!
It depends on your operating system and the type of database you are creating.
Personally, I mainly work with MSSQL, so if I want to setup a local database for this, I would download SQL Express (the express version has a 10GB limit) and then I would recommend downloading something like SQL Server Management Studio (SSMS) to manage the server and run the queries.
If you end up wanting to go with MS SQL there is a ton of guides to setup local databases. I would just google "setting up sql express for *insert operating system here*"
a.) Your process is what's bad, not the program. As you already know, you need to move all that Excel data to a database, do the join in there, and connect power BI to that final big table.
b.) Provided that you have MySQL, what you need is actually SSMS. From there, you can easily import Excel spreadsheets as tables and run sql queries to join them. If you want to automate the process, use SSIS.
If you don't have MySQL, you can do the same with Microsoft Access.
Hi!
Assuming a microsoft variant then download SQL 2019 Developer edition: https://go.microsoft.com/fwlink/?linkid=866662
Install SSMS https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
Then follow a guide to add the northwind database https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases
That's the nuts and bolts you need, after that some google-fu should point you towards some beginners guides. Good luck!
Access isn't primarily a front end tool. It's a database engine in its own right, but much smaller scale then something SQL Server or MySQL or PostgreSQL. Since it's aimed at end users, and not developers, it has built in UI tools but they're more simplistic then what you could do with asp.net. If you're already willing to start working with SQL Server, I wouldn't recommend using Access as a front end.
I do have a question though, when you say "manage the database/run queries", do you mean things like adding users, starting or stopping the database engine, configuring file locations for the files that make up the database and running ad hoc queries (SQL queries that you write yourself)? If that's what you're talking about, what you're actually probably looking for is SQL Server Management Studio. Apologies if this is something you're already aware of, but based on your questions I wasn't sure you had a clear understanding of the different products do.
As to your last question, I guess it depends on what you mean by cover everything. Azure will certainly give you hardware to run all the software you're looking to use (you could even rent a virtual desktop to run Access) if that's what you mean.
I can't believe no one has mentioned this. Microsoft localdb server.
It's lightweight and the sql server management studio query tool should feel familar already based on your. Net background as it's based on visual studio.
Incidentally if you have vs already installed there is a good chance you already have the localdb server installed, depending on what workloads you are targeting.
If you decide to go this route feel free to send me any questions as I use ssms and tsql daily.
SSMS is now its own download. Works with any edition of SQL Server. I even use it to manage servers as far back as 2008 with no issues.
> The server that I need to do this only has a SQL 2016 Express instance so I am going to have to use a batch file to call the .sql files.
Why is that? Is the batch file the actual goal of the project? If not, you can download SSMS and use that. SQL Server Express typically installs to the SQLExpress instance. Other than that it's the same as connecting to any other SQL Server installation, so .\SQLEXPRESS as the host\instance should connect.
If your goal is to write the batch file, then I think you've got a lot more learning to do than just how to run sqlcmd.exe, though that's a place to start.
SQL Server Express is a free, resource-restricted edition (10GB max), which can be used in production. See https://www.microsoft.com/en-us/sql-server/sql-server-2017-editions. SQL Server Management Studio is an excellent tool for developing against SQL server: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017
The industry standard for querying and administration for MS SQL is SSMS (SQL Server Management Studio). It's free.
​
Microsoft is also developing a modernized alternative to SSMS called Azure Data Studio. It doesn't have all the bells and whistles that SSMS has, but they are slowing rolling out features. I still prefer SSMS to Azure Data Studio.
As hdsrob mentioned, SQL Server Express Local DB is a great option. You could also go one step further and install the full SQL Server Express edition. Installs it as a service and is always running. It has a few limitations compared to the paid license versions, but nothing that will hinder your development. SQL Server Express only installs the database services though, not the management programs, so you would also want to download SQL Server Management Studio. Visual Studio 2017 and VS Code can also connect to and manage your SQL instances.
Another option is MongoDB. Install it locally as a service, or run it on demand, and you have a document db available.
This could all vary based on your environment.
Haven't tried 2017.7 but did 2017.5 semi-recently and its perfectly fine.
e: SSMS-Setup-ENU.exe /ACTION=INSTALL /IACCEPTSQLSERVERLICENSETERMS /UpdateEnabled=0 /FEATURES=SQL,AS,RS,IS,MDS,Tools /PASSIVE /SkipRules=RebootRequiredCheck /log "InsertLogPathHere"
On the SSMS download page it says it's backwards compatible with all supported SQL Server versions. So 2008 and up. It says this about older versions "There is no explicit block for SQL Server 2000 or SQL Server 2005, but some features may not work properly. " https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
So you'll need to install an older SSMS version.