Тёмный

How to Install and Use SQL Express 

Sean MacKenzie Data Engineering
Подписаться 13 тыс.
Просмотров 28 тыс.
50% 1

Опубликовано:

 

29 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 38   
@seanmackenziedataengineering
If you like this video, check this one out: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-12SZE4a4a8c.html In that one I talk about the first time I used SQL Server/Express as a backend and was blown away by how good it was.
@containerhobbyshop9735
@containerhobbyshop9735 Год назад
Man your access videos are the best!
@seanmackenziedataengineering
Thanks!!
@davidskilbeck588
@davidskilbeck588 6 месяцев назад
Thank you! Great lesson, would like to learn more about how to use SQL EXPRESS, keep those lessons coming please ;)
@seanmackenziedataengineering
@seanmackenziedataengineering 6 месяцев назад
More to come! Check out last week's backup and restore in this series if you didn't yet: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JTwBAztLnoU.html
@amankazu8933
@amankazu8933 Год назад
hello and thank you for your help with the creation of this video but I have a problem that after I download the server management studio the restart button didn't appear. however I closed and restarted my computer anyways just In case but once i got back when i open either of the two applications you downloaded neither shows me the option you have at 11:46 to open the server manager. is there any advice you can give
@seanmackenziedataengineering
It is possible that the installation did not complete. Can you find this location? C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7
@pspk70
@pspk70 Год назад
Very good explanation ! Tq Mr.MacKenzie
@seanmackenziedataengineering
Glad it was helpful!
@rocketi05
@rocketi05 5 месяцев назад
Thanks so much for the concise walkthough!
@seanmackenziedataengineering
@seanmackenziedataengineering 5 месяцев назад
No prob!
@Staytrue383
@Staytrue383 Год назад
could u elaborate more on how did the sql express start running once the ssms connect to it ? or does the sql express server starts on its own when the ssms is opened ?
@seanmackenziedataengineering
SQL Express is indeed a server, and it runs as a "service", which means that it is always on as long as the service is "started". When you start SSMS, you are just connecting to a service that is already running. Welcome to the wonderful world of managed data as opposed to file data.. it is awesome. You can go Start > Search bar > type Services > open the Services panel > scroll down until you see SQL Server SQL 2019X, or whatever the name of your instance is. You will see that it is running. You can click on it and then click the Stop service at the top left, or just right-click Stop. Right-click Start, etc. This is where you check if your server is running. Also make sure that the Browser service is running. SSMS is just a client to work with the server. If you logged into SSMS as a Windows admin, you can also right-click on the server in SSMS to Stop/Start the service. This is handy if something is wrong and connections or queries get funky.. you can stop the service and release everything, then start it again in order to resume or investigate what happened.
@josmaitconsult8913
@josmaitconsult8913 Год назад
Your video has helped a lot. Is there a way that i can bind the Sql database( table - back end) to access database (front end) and install them as one file? Hope you will be of help.
@seanmackenziedataengineering
Installers are not my strong point. If you're just looking to connect the tables, though, you can start by designing your tables for use with MS Access ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-X2S1L81r8MI.html
@zuyderrathaman2497
@zuyderrathaman2497 Год назад
Hi, while trying to upload data using the import wizard, I get errors, I've tried installing the Microsoft Access Database Engine 2016 Redistributable and nothing changes, kindly assist.
@seanmackenziedataengineering
Import wizard in SQL Express? Also, you only have the runtime version of Access? If you have the full version, you can export from Access. It might be easier.
@zoranstojanovski8407
@zoranstojanovski8407 25 дней назад
Can SQL server express be upgrade to SQL server standard?
@seanmackenziedataengineering
@seanmackenziedataengineering 25 дней назад
The database you create with Express can be backed up and then restored to a Standard instance, no problem. For constrained environments (ie. no space to do a backup), you can also just detach the database and log files and then reattach them to a Standard instance. Instant upgrade 🛠
@erytym
@erytym 8 месяцев назад
That helps! Thank you
@seanmackenziedataengineering
@seanmackenziedataengineering 8 месяцев назад
Glad it helped!
@WilliamNelson-s6i
@WilliamNelson-s6i Год назад
I see SQL Express 2022 is available in your search results. Should I stay away from that version and just choose 2019 ?
@seanmackenziedataengineering
2022 should be fine - generally I have never found an issue on new versions from an Access dev point of view. The reason is that your Access apps will generally work best with certain older, but standard datatypes as I show here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-X2S1L81r8MI.html Give it a try!
@dagthewog6290
@dagthewog6290 Год назад
Thank you! Subscribed. Clear and concise instructions that I can follow along, step by step.
@seanmackenziedataengineering
Thanks for the sub!
@avendanod
@avendanod 6 месяцев назад
Thanks, 1 year after !!!
@seanmackenziedataengineering
@seanmackenziedataengineering 6 месяцев назад
You're welcome! This week's video is also in the SQL Express series, so check it out too if you like: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JTwBAztLnoU.html
@PramodKumar-dr8nn
@PramodKumar-dr8nn 5 месяцев назад
Getting below error: The MOF Compiler could not connect with the WMI server. Please suggest next step.
@seanmackenziedataengineering
@seanmackenziedataengineering 4 месяца назад
You'll have to research that one. It seems to be related to previous or incomplete installations.
@behroozyazdani6023
@behroozyazdani6023 6 месяцев назад
Hi, thanks, good job.
@seanmackenziedataengineering
@seanmackenziedataengineering 6 месяцев назад
Welcome!
@odukoyayetunde2492
@odukoyayetunde2492 Год назад
hi, i cannot install sql server, i need your help
@seanmackenziedataengineering
What happened?
@odukoyayetunde2492
@odukoyayetunde2492 Год назад
@@seanmackenziedataengineering it keeps saying it cannot be installed
@usmankhan-sd2qe
@usmankhan-sd2qe Год назад
Sure more topics with fully priject deployment
@seanmackenziedataengineering
You bet!
@deanbullen9021
@deanbullen9021 4 месяца назад
I don't understand why you have got the name of the product wrong every single time you mention it. It's very clear from the whole video that the product is called SQL Server, Express Edition, not SQL Express.
@seanmackenziedataengineering
@seanmackenziedataengineering 4 месяца назад
You're almost right - the (latest) official name I see on their download page is SQL Server 2022 Express, though that is a bit long and the product is simply known as SQL Express in the industry. Like people just say Access database or SQL Server database instead of SQL Server Enterprise Edition database or something.
Далее
Nightmare | Update 0.31.0 Trailer | Standoff 2
01:14
Просмотров 686 тыс.
SQL Server 2022 Express Installation
17:04
Просмотров 20 тыс.
SQL Tutorial for Beginners
44:57
Просмотров 2,2 млн
Want to know how to install SQL Server Express 2022?
19:27
How To Install SQL Server on Mac (M1 | M2 | M3) (2024)
16:51
How to use Azure SQL Databases | Azure Fundamentals
13:46