How to Create Databases in SQL Server

Articles, Videos and Courses on: SQL Server, .NET, Programming, C#, Python, SQL, Java and more! - EssentialDevTips.com

In this post, we will see how to easily create databases in SQL Server. To this end, we will see a relevant example along with a short video.   Connecting to SQL Server with SQL Server Management Studio (SSMS) The first step, prior to creating the database, is to connect to SQL Server, in our … Read more

Software Review: SQLNetHub’s Snippets Generator

Articles, Videos and Courses on: SQL Server, .NET, Programming, Azure, C#, Python, SQL, Java and more! - EssentialDevTips.com

Introducing: Snippets Generator This software review is about SQLNetHub’s Snippets Generator. Snippets Generator is a productivity tool that can help you work faster and more efficient, when working with SQL Server Management Studio developing SQL scripts.   Snippets Generator, via its intuitive Graphical User Interface (GUI), enables you to easily create SQL snippets which you … Read more

What are T-SQL Snippets in SSMS?

Articles, Videos and Courses on: SQL Server, .NET, Programming, C#, Python, SQL, Java and more! - EssentialDevTips.com

Hi friends, in this article, we will be discussing about T-SQL snippets in SSMS (SQL Server Management Studio).   What is a T-SQL Snippet? In the Computer Programming world, a snippet is a piece of reusable source code that can be easily incorporated into larger sections of code. Similarly, in SQL Server, a T-SQL snippet … Read more

Securing your SQL Server Instances

Hi friends, in this article, we will be discussing about the necessity and process of securing your SQL Server instances. SQL Server and Azure SQL Database are two of the most complete and powerful data platforms in the world. With SQL Server and Azure SQL Database you can store and organize structured, semi-structured and unstructured data and … Read more

Using Dynamic Memory Allocation in Java

Articles, Videos and Courses on: SQL Server, .NET, Programming, C#, Python, SQL, Java and more! - EssentialDevTips.com

Hi friends! In this article, we will be discussing about, how you can use Dynamic Memory Allocation in Java, and see a relevant code example.   What is Dynamic Memory Allocation in Java? In Java, Dynamic Memory Allocation, is the ability for a program, to obtain more memory space during it’s execution when needed (i.e. … Read more

How to Read a Text File in Python – Live Demo

Articles, Videos and Courses on: SQL Server, .NET, Programming, Azure, C#, Python, SQL, Java and more! - EssentialDevTips.com

Hi friends! In this article, we will talk about, how you can read a text file in Python. Also, we will see a relevant live demo.   Reading Files in Python with the open() Function Python has the built-in function “open()“. As the name implies, using the open() function, you can open files in order … Read more

IndexError: list index out of range – How to Resolve it in Python

Articles, Videos and Courses on: SQL Server, .NET, Programming, Azure, C#, Python, SQL, Java and more! - EssentialDevTips.com

Hi friends, in this post, we will be discussing about, how you can easily resolve the “IndexError: list index out of range” error when coding in Python. This is a common runtime error message you might get under certain circumstances, when coding in Python.   Reproducing the “IndexError” Python Error In order to better understand … Read more

Difference Between SQL and SQL Server

Articles, Videos and Courses on: SQL Server, .NET, Programming, C#, Python, SQL, Java and more! - EssentialDevTips.com

What is the difference between SQL and SQL Server? This question is a very common one among people that just started working with databases. This short post answers this question.   What is SQL? SQL stands for Structured Query Language. It is a language that is used for accessing and managing data stored in Relational … Read more