-
Select Names Ending With Vowels in MS SQL Server
Introduction Sometime we may need to select the column results that the string ends with Vowels. In this article, We will have a look, How to select the columns results ending with Vowels. In one of the articles, we discussed how to select names Starting with Vowels, please refer that article here. Example As an…
-
Install Machine Learning Services for Python-Get Started with SQL Server Machine Learning Services – Part 2
Introduction This is Part 2 of “Get Started with SQL Server Machine Learning Services “. In the part 1 article, we discussed about the capabilities of Machine Learning in SQL Server. In this article, we will discuss “How to Install Machine Learning Services in SQL Server”. Note: If you are new to this article, recommending…
-
Difference Between Drop Table, Truncate Table & Delete Table in MS SQL Server – Zero to Hero Query Master – Part 6
Introduction In this article, we will discuss the difference between Drop Table, Truncate Table, Delete Table. To perform dropping, deleting and truncating a table, I am creating three tables. With these three tables let’s look into more: Students.StudentDetails Students.StudentMarks Students.StudentClass Drop Table The syntax for dropping a table in MS SQL is, Syntax Example When…
-
Tables in Database- MS SQL Server – Zero to Hero Query Master – Part 5
Introduction All the data in a database is stored in a Table, which is a data object. Data is organized in Rows and Columns in a table and each row represents a unique record while each column represents a field in the record Types of Tables SQL Server provides the following types of tables that…
-
How is Data Stored in SQL Database
Introduction Being Software Developer / DBA / Database Developer, its important to know or understand the concept How the Data is Stored in SQL Database. This knowledge is very important when we want to troubleshoot and fix SQL queries that are not performing well from the Tuning point. In this article, we will discuss how…
-
Get Started with SQL Server Machine Learning Services – Part 1
Introduction We know Humans learn from their past experiences. Mean while Machines follow Instructions given by Humans. But what if Human can train Machines to learn from the past data?. In simple, this is what Machine learning is !!!!. SQL Server has capabilities of Machine Learning. In this article, we will discuss about the capabilities…
Subscribe
Enter your email below to receive updates.
