How to license SQL Server and Pricing

Overview SQL Server 2019 is offered in two main commercial editions to accommodate the unique feature, performance and price requirements of organizations and individuals:• Enterprise Edition is ideal for applications requiring mission critical in-memory performance, security and high availability.• Standard Edition delivers fully featured database capabilities for mid-tier applications and data marts. The editions areContinue reading “How to license SQL Server and Pricing”

SQL Server – Always On

An availability group supports a replicated environment for a discrete set of user databases, known as availability databases. You can create an availability group for high availability (HA) or for read-scale. An HA availability group is a group of databases that fail over together. A read-scale availability group is a group of databases that are copied to otherContinue reading “SQL Server – Always On”

SQL Server Collation

Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data. Collations that are used with character data types, such as char and varchar, dictate the code page and corresponding characters that can be represented for that data type. A collation specifies the bit patterns that represent each character in aContinue reading “SQL Server Collation”

Types of Database

Types of Databases in SQL Server System Databases User Databases Following are SQL Server System Databases: System Database Description master Records all the system-level information for an instance of SQL Server. msdb Is used by SQL Server Agent for scheduling alerts and jobs. model Is used as the template for all databases created on theContinue reading “Types of Database”

Introduction to SQL Server

SQL Server is a relational database management system (RDBMS) developed by Microsoft. SQL Server supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. SQL Server supports ANSI SQL, which is the standard SQL (Structured Query Language) language. However, SQL Server comes with its own implementation of the SQLContinue reading “Introduction to SQL Server”

Types of services in SQL Server

Each service in SQL Server represents a process or a set of processes to manage authentication of SQL Server operations with Windows. This topic describes the default configuration of services in this release of SQL Server, and configuration options for SQL Server services that you can set during and after SQL Server installation. Most services andContinue reading “Types of services in SQL Server”

Application Roles – SQL Server

An application role is a database principal that enables an application to run with its own, user-like permissions. You can use application roles to enable access to specific data to only those users who connect through a particular application. In SQL Server, application roles cannot access server-level metadata because they are not associated with aContinue reading “Application Roles – SQL Server”

Linked Server

Linked server is configured to enable the SQL Server Database Engine to execute commands against OLE DB data sources outside of the instance of SQL Server. Typically linked servers are configured to enable the Database Engine to execute a Transact-SQL statement that includes tables in another instance of SQL Server, or another database product suchContinue reading “Linked Server”

Understanding SQL Server database recovery models

A recovery model is a database property that controls how transactions are logged, whether the transaction log requires (and allows) backing up, and what kinds of restore operations are available. Three recovery models exist: simple, full, and bulk-logged. Typically, a database uses the full recovery model or simple recovery model. A database can be switchedContinue reading “Understanding SQL Server database recovery models”

Tools – SQL Server

To manage your database, you need a tool. Whether your databases run in the cloud, on Windows, on macOS, or on Linux, your tool doesn’t need to run on the same platform as the database. You can view the links to the different SQL tools in the following tables. Recommended tools Graphical User Interface (GUI)Continue reading “Tools – SQL Server”