SQL Server
- Blog
- SQL Server
About SQL Server
SQL Server, developed by Microsoft, stands as one of the industry's leading relational database management systems (RDBMS). Introduced in the late 1980s in partnership with Sybase, SQL Server has undergone significant transformations to become an integral solution for various businesses worldwide. With a primary function to store, retrieve, and manage large volumes of data, SQL Server integrates seamlessly with numerous applications, making it a prime choice for different enterprise requirements. Its features encompass advanced analytics, business intelligence, data warehousing, and robust transaction processing, ensuring data integrity and security.
FUNDAMENTALS
-
What Is SQL Server?: Understanding SQL Server and its Different EditionsSQL Server is a relational database management system (RDBM) developed by Microsoft that competes with Oracle, IBM DB2, MySQL, PostgreSQL,… -
SQL Server Essentials: What Is a Relational Database?SQL Server is a relational database. But what is a relational database exactly? Mike Otey, our resident SQL Server expert,… -
What is SQL Server Reporting Services?SQL Server Reporting Services (SSRS) is a set of on-premises tools and services that enable you to create, deploy, and…
GETTING STARTED
-
SQL Server Essentials: Core SQL Server Data TypesIn this article we’ll cover the essential SQL Server data types and discuss their common usage. Data is at the…
-
String Data Types in SQL Server: VARCHAR vs. CHARYour database is made of data; data is defined by data types. Data types are so fundamental yet they're often…
-
SQL ALTER TABLE – Modifying Table Structure in SQL ServerThe T-SQL ALTER TABLE statement is used to modify the structure of a table. Using the T-SQL ALTER TABLE statement…
TUTORIALS
-
SQL Server Essentials: Create a SQL DatabaseDatabases are the primary containers for your SQL Server relational database objects. Some of the main relational database objects that are contained in SQL Server…
-
SQL Server – How to Add a Table Using SQL CREATE TABLEOnce you have created a user database, you can begin to create tables using the SQL CREATE TABLE statement. Databases typically have many…
-
Master SQL Server: SQL Server Management Studio TutorialIn this SQL Server Management Studio tutorial (SSMS), I will show you the primary database management and development capabilities provided…
