Check our collection of essential database tips for software developers. The collection is being regularly updated with new tips.
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
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
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
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
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
This article, discusses what SQL Server Management Studio (SSMS) is and how you can use it for connecting to SQL Server. SQL Server Management Studio (SSMS) is an Integrated Environment that allows the user to manage, configure, administer and develop in Microsoft SQL Server. Downloading SQL Server Management Studio The latest SQL Server Management … Read more
In this article, we discuss about the different tasks you can perform, when using the Microsoft SQL Server Data Platform. SQL Server is one of the world’s leading data platforms. If you are just starting out with SQL Server, I’m sure that the first questions that comes in your mind is what can you do … Read more
Hi friends! In this article, you will learn what are SQL Server stored procedures, how you can define them, as well as how you can execute them. About SQL Server Stored Procedures A SQL Server stored procedure, is a batch of T-SQL statements, stored as a logical unit (programmability object) that has a name … Read more
Hi friends! In this article, we discuss about, how you can easily get started with the SQL Server Data Platform and SQL Server Management Studio (SSMS). Introduction SQL Server is one of the most powerful data platforms in the world. It is is Relational Database Management System (RDBMS) in which you can store, organize and … Read more
Hi friends! This article, discusses about the benefits of primary keys in database tables. A primary key is a special column (or set of combined columns) in a relational database table, that is used to uniquely identify each record. A database primary key cannot contain NULL values and each table can have only one primary … Read more