Видео

Here are the steps to create SQL user logins: 1. Enable both Windows and SQL authentication in the server properties, then restart the SQL server. 2. In the Login folder, right-click and select "New Login." 3. In the popup, choose SQL authentication and enter the username and password. 4. In the User Mapping section, select the databases and assign the appropriate roles to the user. 5. Create the user and log in using SQL authentication. I’ll be creating a video on how to set up a SQL Server user login and use that login to authenticate in Azure Data Factory for data migration. Stay tuned for more updates, and happy learning!

@@DataCodex-07 thank you

In the video, I mentioned that "if I were to roll back, the changes would not affect the table." However, since this video focuses on the commit command, I did not execute a rollback and instead committed the changes to the table.

Will update this soon, Thanks for the support. Happy Learning!

Could you please provide more details about the error message you are encountering? Please find the below possibilities of the error Column Mismatch: The columns in the CSV file may not match the columns in the table, either in number or data type. Data Type Incompatibility: The data in the CSV file may not be compatible with the data types expected by the table columns. Constraint Violations: The data may violate table constraints such as primary keys, foreign keys, or unique constraints. Format Issues: The CSV file may have formatting issues, such as incorrect delimiters or inconsistent quoting. Null Values: The CSV file may contain null values or empty fields that are not allowed by the table schema. File Encoding: The encoding of the CSV file may not match the expected encoding, leading to data misinterpretation. File Path and Permissions: Issues with the file path or file access permissions can prevent the bulk insert operation from reading the CSV file. It would be helpful if you could provide more detailed information about the error you are encountering.

I did already please refer to this Shorts to load CSV data into tables ruclips.net/user/shortsIZGzDNvhwHU?feature=share Also you are able to load the data from Excel into tables with the help of this video ruclips.net/video/d-0OovGu5c0/видео.html Watch further videos in SQL Server playlist to Master your SQL skills Thanks for the support! Happy Learning

Thank you for your kind words and support regarding the ADF video. I appreciate your suggestion about integrating ADF with Snowflake. I will definitely consider creating content on this topic in the future. Happy learning 🎉!

What are you connecting to: an Azure SQL Database or a SQL Server Database? 1. If it is an Azure SQL Database, please verify that your IP address is permitted in the firewall rules. You can check this by connecting via SSMS or reviewing the firewall rules in the Azure Portal. 2. If you are connecting to a SQL Server Database, ensure that the Self-hosted Integration Runtime (IR) is correctly configured and running, and also verify the authentication type. Please let me know if you have any further questions.

Happy learning 🎉

Sure, Thanks for the support! Happy learning

Given the simplicity of these questions, I have refrained from providing the code on GitHub. However, should you find access to the source code beneficial, I am more than willing to accommodate. I can diligently work on compiling the necessary source codes, along with the requisite table creation scripts, and promptly make them available on GitHub. Rest assured, I will include the GitHub link in the description for your convenience. Thank you sincerely for your support! Wishing you a fulfilling journey of learning ahead.

Happy Learning 🎊

Dear Professor DJ, as you previously requested, I have significantly reduced the background music in my new videos. However, this particular video is a compilation of older clips, so I am unable to edit the background music in this instance. I will ensure future videos have better audio balance. Thank you for your support and happy learning!

I apologize for any inconvenience caused by the background music. Thank you for bringing this to my attention-it's helpful to receive your feedback. I will make adjustments to minimize the background music significantly or consider removing it entirely. I appreciate your understanding and wish you a pleasant and productive learning experience!

Indeed, it is possible to perform aggregation based on the id column by including it in the select list. You can try several ways!

Thank you for your interest in the scenario-based questions playlist! I appreciate your support and encouragement. Please feel free to watch the video for detailed explanations and refer to the GitHub repository for the table creation scripts, insert queries, and solutions. I've also included the PowerPoint presentation. Happy learning, and let me know if you have any questions or feedback along the way!

Thnk u

I have organized playlists on this channel covering topics like data engineering, data analytics, data science, and databases. The first playlist focuses on SQL Server, where I've covered a comprehensive range of SQL-related topics. Moving forward, I plan to delve into data integration and subsequently explore data analysis. I encourage you to complete the SQL Server playlist and practice the questions I've posted on GitHub for each session. Additionally, I'm curating a concise playlist of SQL Server commands. Your continued support and engagement are greatly appreciated as we continue to learn together. Thank you for your ongoing support!

It's wonderful to hear that you're an active subscriber who watches all the videos. In addition to watching each video, I kindly encourage you to also attempt the queries provided on GitHub for each day. You can find the GitHub link in the description of each video. By tackling these queries regularly, you'll enhance your mastery of SQL. Moreover, I'm considering creating a separate playlist for scenario-based question-solving sessions. Remember, the journey of learning is continuous, so keep exploring and practicing.

Certainly, I aim to create short videos in Tamil to explain each feature in detail, while I continue to post full-length videos in English.

Certainly, I will endeavor to enhance the clarity and ensure the video has a high resolution. Your continued support is greatly appreciated. Thank you.

Good effort, but using '>= ALL' returns 5 rows, whereas using '>= ANY' would yield 8 rows. Let's explore this difference further.