SQL Server 101
SQL Server 101
  • Видео 169
  • Просмотров 2 145 786
Marking rows in an SQL Server table as duplicates
Have you got duplicate rows in your data? Here's how you are can find them and mark them as duplicate.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/querying-microsoft-sql-server
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/microsoft-powerpivot-ssas-ta...
Просмотров: 351

Видео

Install SQL Server 2022 Developer and SQL Server Management Studio (SSMS) for Free (2024 video)
Просмотров 5 тыс.3 месяца назад
In this video, we'll have a look at how to install SQL Server 2022 Developer edition and SQL Server Management Studio (SSMS) - for FREE. My SQL Server Udemy courses are: 70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/querying-microsoft-sql-server 98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/database-fundamentals 70-462 SQL Server Database Administration ...
Installing SSMS version 20, and solving certificate chain not trusted problem in SQL Server.
Просмотров 3,6 тыс.4 месяца назад
In this video, we will look at the major changes that have happened with the release of SQL Server Management Studio (SSMS) version 20. My SQL Server Udemy courses are: 70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/querying-microsoft-sql-server 98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/database-fundamentals 70-462 SQL Server Database Administration (...
How do you pronounce "SQL", as in "SQL Server" or "MySQL"?
Просмотров 5016 месяцев назад
Do you pronounce "SQL" as "es-queue-el" or "SEQUEL"? My SQL Server Udemy courses are: 70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/querying-microsoft-sql-server 98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/database-fundamentals 70-462 SQL Server Database Administration (DBA): rebrand.ly/sql-server-dba Microsoft SQL Server Reporting Services (SSRS): reb...
Beyond SQL Server: Key Apps and Services for SQL Server Users
Просмотров 1906 месяцев назад
What should you learn to go beyond your SQL Server skills? My SQL Server Udemy courses are: 70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/querying-microsoft-sql-server 98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/database-fundamentals 70-462 SQL Server Database Administration (DBA): rebrand.ly/sql-server-dba Microsoft SQL Server Reporting Services (SSRS...
Use Artificial Intelligence to create sample data for SQL Server.
Просмотров 4867 месяцев назад
In this video, we'll create some random data, ready to use in SQL Server. My SQL Server Udemy courses are: 70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/querying-microsoft-sql-server 98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/database-fundamentals 70-462 SQL Server Database Administration (DBA): rebrand.ly/sql-server-dba Microsoft SQL Server Reporting...
Solving connection problems with Azure SQL Database
Просмотров 3807 месяцев назад
Solving connection problems with Azure SQL Database
Unleashing the Power of AI: Creating SQL Server Queries with ChatGPT
Просмотров 1,9 тыс.8 месяцев назад
Unleashing the Power of AI: Creating SQL Server Queries with ChatGPT
Practice Activity: Adding the column from one query into another query in SQL Server.
Просмотров 2928 месяцев назад
Practice Activity: Adding the column from one query into another query in SQL Server.
Our Thanksgiving sale is now on. Learn SQL, Power Platform, Power BI, Azure and more
Просмотров 1889 месяцев назад
Our Thanksgiving sale is now on. Learn SQL, Power Platform, Power BI, Azure and more
How to add features to an existing installation of SQL Server
Просмотров 2,1 тыс.9 месяцев назад
How to add features to an existing installation of SQL Server
How to check or change the server mode of SSAS (SQL Server Multidimensional or Tabular)
Просмотров 2,1 тыс.10 месяцев назад
How to check or change the server mode of SSAS (SQL Server Multidimensional or Tabular)
Calculate the next working day (excluding weekends and vacation/holidays) in SQL Server
Просмотров 1,5 тыс.10 месяцев назад
Calculate the next working day (excluding weekends and vacation/holidays) in SQL Server
Retrieve all invoices in SQL Server with a date between now and a month from now
Просмотров 41111 месяцев назад
Retrieve all invoices in SQL Server with a date between now and a month from now
Creating a time table in SQL Server
Просмотров 1 тыс.11 месяцев назад
Creating a time table in SQL Server
Practice Activity: Splitting a string into separate rows in SQL Server
Просмотров 74311 месяцев назад
Practice Activity: Splitting a string into separate rows in SQL Server
Practice Activity: How to retrieve the top 80% of items in SQL Server (the Pareto principle)
Просмотров 821Год назад
Practice Activity: How to retrieve the top 80% of items in SQL Server (the Pareto principle)
Practice Activity - Joining SQL Server daily data with irregular periodic data
Просмотров 369Год назад
Practice Activity - Joining SQL Server daily data with irregular periodic data
Practice Activity - Joining SQL Server daily data to weekly data
Просмотров 649Год назад
Practice Activity - Joining SQL Server daily data to weekly data
SQL Server in the Cloud: Creating a Microsoft Azure SQL Database (2023 Version)
Просмотров 12 тыс.Год назад
SQL Server in the Cloud: Creating a Microsoft Azure SQL Database (2023 Version)
Practice Activity: Which employees are being paid more than their managers (using a self-join)
Просмотров 284Год назад
Practice Activity: Which employees are being paid more than their managers (using a self-join)
How to import data from Microsoft Excel into Microsoft SQL Server
Просмотров 33 тыс.Год назад
How to import data from Microsoft Excel into Microsoft SQL Server
How to install sample data into SQL Server (2023 version) - AdventureWorks
Просмотров 4,9 тыс.Год назад
How to install sample data into SQL Server (2023 version) - AdventureWorks
Uncover the Secret to Solving That "Trust Server Certificate Connection Error" in Azure Data Studio!
Просмотров 6 тыс.Год назад
Uncover the Secret to Solving That "Trust Server Certificate Connection Error" in Azure Data Studio!
Uncovering the Alternative to the Missing SQL Server Native Client - What You Need to Know!
Просмотров 19 тыс.Год назад
Uncovering the Alternative to the Missing SQL Server Native Client - What You Need to Know!
Unveiling the Mystery of Azure Data Studio - Download and Install and how to use Tutorial!
Просмотров 12 тыс.Год назад
Unveiling the Mystery of Azure Data Studio - Download and Install and how to use Tutorial!
Unlock the Power of SQL Server Management Studio (SSMS): An In-Depth Look
Просмотров 2,3 тыс.Год назад
Unlock the Power of SQL Server Management Studio (SSMS): An In-Depth Look
It's a rap
Просмотров 162Год назад
It's a rap
SSMS 18 Not Working? Here's What You NEED To Do If You Have SQL Server 2022
Просмотров 4,4 тыс.Год назад
SSMS 18 Not Working? Here's What You NEED To Do If You Have SQL Server 2022
FREE TRIAL: Get a FREE Azure Subscription to Try Out Microsoft's Cloud Services
Просмотров 2 тыс.Год назад
FREE TRIAL: Get a FREE Azure Subscription to Try Out Microsoft's Cloud Services

Комментарии

  • @anukutty9820
    @anukutty9820 2 дня назад

    Very useful ❤

  • @SamWanderlust
    @SamWanderlust 2 дня назад

    Thx!!

  • @ghostwarrior7922
    @ghostwarrior7922 3 дня назад

    Tnx this video was really helpfull

  • @Development-fz5vq
    @Development-fz5vq 5 дней назад

    The CSV route appears much simpler. Is there any benefit in keeping the file as .xlsx and using the import Data method? Thank you. I purchased your SQL Server course on Udemy. :)

    • @SQLServer101
      @SQLServer101 2 дня назад

      Hi Development. Thank you for your question. The main reason is if you don't want to save it as an CSV file. However, importing CSV files are generally a lot easier than importing Excel files. Thanks for joining me in our Udemy course. Phillip

  • @geethikanori9449
    @geethikanori9449 7 дней назад

    Installed just the way you walked through. No issues faced at all, loved the smooth installation. Thanks a mil!!❣

  • @baluachari1984
    @baluachari1984 7 дней назад

    Your step by step guide helped a lot. Thank you very much!

  • @davestorm6718
    @davestorm6718 8 дней назад

    Thank you so much for this tutorial. Once I got past the intimidating pay models and other gobblygook, it looks fairly painless (1st experience for Azure databases) and works like a charm (it's actually faster than I thought it would be)

    • @davestorm6718
      @davestorm6718 8 дней назад

      I spent the last 20 years installing, configuring, and programming SQL Server on physical servers, and I'm glad to find most of this is nothing new to me!

    • @SQLServer101
      @SQLServer101 2 дня назад

      Hi Dave. Thank you for your comments. I'm glad you got it up and running, and it looks fairly routine now! Given your on premises experience, if you continue with Azure, you might want to look into the requirements for Microsoft's DP-300 certification, as it can give you more tools for administrating your Azure database. See idodata.com/dp-300-administering-relational-databases/ for more details. Enjoy Azure. Phillip

    • @davestorm6718
      @davestorm6718 2 дня назад

      @@SQLServer101 Now I'm too broke to continue the Azure stuff, lol!

  • @VigneshwaranS-x4l
    @VigneshwaranS-x4l 13 дней назад

    USEFULL CONTENT THANK YOU SO MUCH

  • @T.shiamo.
    @T.shiamo. 22 дня назад

    hey, so how would you import data from a excel file using this version because it doesn't seem to work with the method used on the old version

    • @SQLServer101
      @SQLServer101 15 дней назад

      Hi T. Thank you for your question. Please see ruclips.net/video/iGzBgd0qwT4/видео.html . Phillip

  • @peterpekun
    @peterpekun 23 дня назад

    Nice

  • @no.more.official
    @no.more.official 24 дня назад

    Thank you

  • @ghauan
    @ghauan 25 дней назад

    I prefer to use s q l and I am 50 years old (and from Norway)

    • @SQLServer101
      @SQLServer101 24 дня назад

      Hello near neighbour! I'm about that age and also use S Q L as my default. Phillip

  • @patricknornyibey7144
    @patricknornyibey7144 27 дней назад

    Can I install both express and developer on my computer?

    • @SQLServer101
      @SQLServer101 24 дня назад

      Hi Patrick. You can, but one of them would be a "named instance" instead of the "Default instance". If the default instance was addressed as COMPUTERNAME, the named instance would be addressed as COMPUTERNAME\SERVERNAME. Phillip

  • @JorgeJaramaReategui
    @JorgeJaramaReategui 28 дней назад

    doesnt work for me

    • @SQLServer101
      @SQLServer101 24 дня назад

      Hi Jorge. Why doesn't it work for you? Phillip

  • @maheshkarpenter7616
    @maheshkarpenter7616 28 дней назад

    Thanks nice video

    • @SQLServer101
      @SQLServer101 24 дня назад

      Hi Mahesh. You are most welcome. Phillip

  • @DCh-ks6ug
    @DCh-ks6ug Месяц назад

    i do not have the task option in my list even when pressing on the database itself what should I do ?

    • @SQLServer101
      @SQLServer101 28 дней назад

      Hi DCh. Thank you for your question. Can you please elaborate. Phillip

  • @gadshoaib2402
    @gadshoaib2402 Месяц назад

    Thanks, you nailed it especially in 2:55

  • @traafnphuscnguyeen
    @traafnphuscnguyeen Месяц назад

    Thanks a lot for this video

  • @urbanpro2494
    @urbanpro2494 Месяц назад

    It helped. Thank you so much

  • @busyshah
    @busyshah Месяц назад

    Thats a really good video. However I am getting below error while creating any new database or uploading adventureworks backup -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TITLE: Microsoft SQL Server Management Studio ------------------------------ Create failed for Database 'TestMaster'. (Microsoft.SqlServer.Smo) For help, click: go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=17.100.40.0&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) For help, click: docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-262-database-engine-error ------------------------------ BUTTONS: OK ------------------------------

    • @SQLServer101
      @SQLServer101 Месяц назад

      Hi Busy. Thank you for your question. It sounds like you don't have the permissions to create a database. Please contact your Database Administrator. Philip

  • @franciswtng
    @franciswtng Месяц назад

    Exactly what I am looking for. Thank you.

  • @krishnakamalgogoi9893
    @krishnakamalgogoi9893 Месяц назад

    with cte3 as (select *, ROW_NUMBER() over(partition by Region order by Pricedate desc) as region_rnk from tblhouseprices) select * from cte3 where region_rnk = 1

  • @ardhendusekharpatra6627
    @ardhendusekharpatra6627 Месяц назад

    Thank you sir

  • @marinabenny616
    @marinabenny616 Месяц назад

    I have followed the exact steps from the video but when I try to find the file through SQL it says it doesn't exit. Bu when you go to the file location in file explorer you can see it. Not sure how to get past this.

    • @SQLServer101
      @SQLServer101 Месяц назад

      Hi Marina. Thank you for your question. I would move to a simple folder, such as C:/b/, and see if you still have the same problems. Phillip

  • @benjicanones1454
    @benjicanones1454 Месяц назад

    Superb!!!

  • @Preethi-i2z
    @Preethi-i2z Месяц назад

    Hello, thank you for uploading this video its really helpful and very detailed. I really appreciate your work. I need some help, in the OLE DB Destination Editor, it shows blank, and I don't have any option to choose. How can I proceed further

    • @SQLServer101
      @SQLServer101 Месяц назад

      Hi Preethi. Thank you for your question. Try rebooting your computer, or running Visual Studio as an administrator. Phillip

    • @Preethi-i2z
      @Preethi-i2z Месяц назад

      ​@@SQLServer101 Thanks Phillip. Its working now.

  • @FaberLSH
    @FaberLSH Месяц назад

    Thank u so much for the helpful tutorial. I was looking for this.

  • @shahad-kv9hc
    @shahad-kv9hc Месяц назад

    thank u its really helpfull

  • @hatemmohammed9362
    @hatemmohammed9362 Месяц назад

    What does SQL server do for me as a SolidWorks User?

    • @SQLServer101
      @SQLServer101 Месяц назад

      Hi Hatemmohammed. I'm afraid I don't know, as I'm not a SolidWorks user. Phillip

    • @Kitty_Cosmic
      @Kitty_Cosmic Месяц назад

      @@SQLServer101 To pirate Solidworks and get all the features you need to download and install sql server and use this video to set up some parts of the application, like the electrical components.

  • @vekijem
    @vekijem Месяц назад

    Just one little Information for other People that might have the same Problem: In my case i had to choose microsoft ole db PROVIDER for sql server and NOT the DRIVER. I dont know why but thats how it worked for me. Maybe that helps someone else.

  • @robertue1
    @robertue1 Месяц назад

    Thank you! Very helpful.

  • @amararuna7298
    @amararuna7298 Месяц назад

    i failed to install database service engine and integration service. could you please help me with that.

    • @SQLServer101
      @SQLServer101 Месяц назад

      Hi. Thank you for your question. I'm afraid that you haven't given enough information. I would look at the error code (probably about 8 characters), and then Google it. Phillip

  • @georgejetson9801
    @georgejetson9801 Месяц назад

    I pronounce it s q l and I'm in my 60s

  • @kedapeyjennifer8311
    @kedapeyjennifer8311 Месяц назад

    Hello I’m trying to install sql server on my Pc but it keeps giving this pop up.( There was an error while checking Rules of sql server setup) Any help please?

    • @SQLServer101
      @SQLServer101 Месяц назад

      Hi Kedapey. Thank you for your question. Please see learn.microsoft.com/en-us/answers/questions/1072293/sql-server-setup-fails-oops-there-was-an-error-whi . Phillip

  • @lalatorvike6077
    @lalatorvike6077 Месяц назад

    This is the perfect video. Very well explained. Thank you

  • @prithvipampana1492
    @prithvipampana1492 Месяц назад

    Help but if we want to split based on length,60 characters in each row

    • @SQLServer101
      @SQLServer101 Месяц назад

      Hi Prith. Thank you for your suggestion. That's a good idea - I'll add it to my "to do" list. Phillip

  • @njamrutharikka4105
    @njamrutharikka4105 Месяц назад

    Hi....my pc has 2021 version of excel,when I try to import data from excel workbook to sql server by selecting excel version to 2016 which is the highest version available .it gave me an error -"The operation could not be completed,the microsoft ACE.OLEDB.16.0 provider is not registered with the local machine".How can get rid of this error.Please help me out from this

    • @SQLServer101
      @SQLServer101 Месяц назад

      Hello. Thank you for your question. Please see answers.microsoft.com/en-us/msoffice/forum/all/the-microsoftaceoledb160-provider-is-not/45dd60f3-69f5-4e9c-ba8d-2b2bcc4bc78c . Phillip

  • @truvisionn2313
    @truvisionn2313 Месяц назад

    i keep getting this message pop up error decompressing SQL server media

    • @SQLServer101
      @SQLServer101 Месяц назад

      Hi Tru. I would try downloading it again. Phillip

  • @nocturnetheatre3954
    @nocturnetheatre3954 Месяц назад

    thank you!

  • @navidshm7424
    @navidshm7424 Месяц назад

    thanks for ending my misery :) (it took me 11 hours ...)

  • @sakshirathi2225
    @sakshirathi2225 Месяц назад

    2nd half helped me out, thank you for the videos!

  • @genesisrojas6217
    @genesisrojas6217 Месяц назад

    Omg!!!!! THANKS!!!! Finally a useful video

  • @bryan1995ism
    @bryan1995ism Месяц назад

    Very thanks !! Pretty good explanation

  • @qasimawan3569
    @qasimawan3569 Месяц назад

    You are a brilliant teacher Phillip! Thanks for the video and awesome courses on Udemy!

  • @greetika-mb4rq
    @greetika-mb4rq Месяц назад

    Thank you 🙏😊 so much for this ,,, really it solves my problem queries regarding importing data

  • @permanentmarkerone
    @permanentmarkerone Месяц назад

    My machine got a catastrophic error because of this video lol

  • @permanentmarkerone
    @permanentmarkerone Месяц назад

    Thank you Mr. Burton. Do you have any RUclips videos on Normalization and Normal forms in databases?

    • @SQLServer101
      @SQLServer101 Месяц назад

      Hello Permanent. It is included in several of my courses, including my 9-hour T-SQL course: rebrand.ly/database-fundamentals . Phillip

    • @permanentmarkerone
      @permanentmarkerone 27 дней назад

      @@SQLServer101 Thank you!

  • @permanentmarkerone
    @permanentmarkerone Месяц назад

    Another banger video by Mr. Burton! Thank you sir, you are a life saver!

  • @johnbruncher9972
    @johnbruncher9972 Месяц назад

    Thanks