Service Broker security Author: Basit A. Farooq You can secure a dialog between two separate instances of SQL Server using Service Broker. You have three options to create a dialog: • Without security • Authenticates the destination server and encrypts the data • Provides mutual authentication and encrypts the data To allow for encrypted communication with a service on a […]
Author: Basit Aalishan Masood-Al-Farooq
Distributed queries – (Part-2)
Distributed queries – (Part-2) Author: Basit A. Farooq Linked server for another SQL Server To create a linked server object for another SQL Server, using SQL Server Management Studio: · In Object Explorer, expand Server Objects. · Right-click Linked Servers and choose New Linked Server. · Enter the name of the linked server. · Select SQL Server. · Click Security. […]
Distributed queries — (Part-1)
Distributed queries – (Part-1) Author: Basit A. Farooq Distributed queries are queries that involve data from data sources on multiple computers or multiple instances of SQL Server. SQL Server supports distributed queries through OLE-DB, a library that allows connections to any data sources that has an OLE DB provider. In this two part article series, you’ll learn how to […]
Microsoft SQL Server Database Design Principles — (Part 2)
Microsoft SQL Server Database Design Principles – (Part 2) Author: Basit A. Farooq Relationships Relationships identify associations between data stored in different tables. Entities relate to other entities in a variety of ways. Table relationships come in several forms: · One-to-one relationship · One-to-many relationship · Many-to-many relationship One-to-one relationship A one-to-one relationship represents a relation between entities in which […]
Microsoft SQL Server Database Design Principles — (Part 1)
Microsoft SQL Server Database Design Principles – (Part 1) Author: Basit A. Farooq Database design is one of the most important tasks in the systems development life cycle (SDLC), also referred to as application development life-cycle (ADLC). That’s because, the databases are essential for all businesses, and good design is crucial for any business critical high performance application. Poor database […]
Understanding Service Broker to perform asynchronous operations (Part-2)
Understanding Service Broker to perform asynchronous operations – (Part-2) Author: Basit A. Farooq Creating queues Next, you create the queue using the CREATE QUEUE statement. You must specify queue_name as a fully-qualified name unless you are creating it in the current database using your default schema. The syntax is: CREATE QUEUE [ WITH [ STATUS = […]
Understanding the architecture of SQL Server Relational Engine
Understanding the architecture of SQL Server Relational Engine Author: Basit A. Farooq Editor’s note: In this article, learn about the architecture of SQL Server Relational Engine. Relational Engine also known as the query processor because it produces the optimal execution plan for your query or each query stored in a batch or stored procedure, and then executes this […]
Understanding Service Broker to perform asynchronous operations – (Part-1)
Understanding Service Broker to perform asynchronous operations – (Part-1) Author: Basit A. Farooq Editor’s note: In this multiple part article series, you learn how to configure Service Broker components. You will create a message type to define the format of a message, a contract to define communication between services, a queue to store and deliver messages, and a service to […]
Understanding Database Indexes — (Part – 3)
Understanding Database Indexes – (Part – 3) Author: Basit A. Farooq Full-text indexes A full-text search is a word search based on character string data. The Microsoft Full-Text Engine for SQL Server creates and maintains a full-text catalog automatically when you enable a table for full-text search. For more information about full-text indexes, see SQL Server Books Online topic: “Populate […]
Understanding Database Indexes — (Part – 2)
Understanding Database Indexes – (Part – 2) Author: Basit A. Farooq Covering Index with included columns SQL Server 2005 introduces included columns in indexes also known as covering indexes. Included columns are non-key columns. Query performance improves when all columns in a query are included in the index as either key or non-key columns. The SQL Server Database Engine stores […]