Author: Basit Aalishan Masood-Al-Farooq

Pro Members SQL Server Standard Members

SQL Server 2014 – Log Shipping Feature Overview

by

SQL Server 2014 – Log Shipping Feature Overview Author: Basit A. Farooq SQL Server log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary standby server instances. In Log Shipping, a database on secondary standby server instance is a mirror image of...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Understanding the sqlcmd utility – to run scripts, stored procedures, and Transact-SQL commands from the command line.

by

Understanding the sqlcmd utility – to run scripts, stored procedures, and Transact-SQL commands from the command line Author: Basit A. Farooq The sqlcmd utility is a Microsoft Win32 command prompt utility, which you can you to run scripts, stored procedures, and Transact-SQL commands from the command line. The sqlcmd utility establishes an OLE-DB connection to the database. To use sqlcmd...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2014 Replication – Part 4

by

SQL Server 2014 Replication – Part 4 Author: Basit A. Farooq Editor’s note: In this fourth part of my SQL Server 2014 Replication article series, you’ll learn about how to configure Merge replication. You’ll also learn about Merge replication conflict management. Creating a Merge publication The steps for creating a Merge publication are similar to creating a transactional publication. However,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Handling errors in T-SQL code

by

Handling errors in T-SQL code Author: Basit A. Farooq Like other programming languages, Transact-SQL provides a sophisticated mechanism that captures and handles errors during execution. The mechanism for handling errors during execution includes the Transact-SQL tradition error handling function @@ERROR and object-oriented-programming-style TRY…CATCH construct. In this article, you’ll examine both techniques. Traditional error handling Earlier versions of SQL Server supported...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2014: Stored Procedures

by

SQL Server 2014: Stored Procedures Author: Basit A. Farooq Introduction A stored procedure is a named, precompiled collection of SQL statements, variables, and control-of-flow statements. You can create stored procedures that accept input parameters and return values and status information. Typical uses for stored procedures include automating repetitive tasks, ensuring tasks are performed consistently, enhancing application and user access security...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2014 Replication – Part 3

by

SQL Server 2014 Replication – Part 3 Author: Basit A. Farooq Editor’s note: In this third part of my SQL Server 2014 Replication article series, you’ll learn about working and configuration of Transactional replication. You’ll also learn about working of Merge replication. Transactional replication Transactional replication sends incremental changes and transactions to the Subscribers. Transactional replication gives you a shorter...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Database Design Interview Questions

by

Database Design Interview Questions Author: Basit A. Farooq In this article, we will outline questions suitable for a Database Developer/Database Analyst interview to assess the candidates skills related to database design. Question 1: What is Database Management System (DBMS)? Answer: The software that manages the storage and access to the data in the databases. Question 2: Describe the main phases...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2014 Replication – Part 2

by

SQL Server 2014 Replication – Part 2 Author: Basit A. Farooq Editor’s note: In this second part of my SQL Server 2014 Replication article series, you’ll first learn about different types of replication agents and there security context. Next, you’ll learn how configure Distributor. Finally, you’ll learn how to configure Snapshot replication. Replication agents Replication agents perform the activities necessary...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Installing and Configuring SQL Server 2014 on Windows Server 2012 – (Part 1)

by

Installing and Configuring SQL Server 2014 on Windows Server 2012 – (Part 1) Author: Basit A. Farooq Introduction Microsoft SQL Server is an enterprise database server that is the cornerstone of modern business applications and is in the center of the business processes of many leading organizations. The latest release of Microsoft SQL Server, SQL Server 2014, has many new...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Microsoft SQL Server 2014: Database Engine key new features – (Part 3)

by

Microsoft SQL Server 2014: Database Engine key new features – (Part 3) Author: Basit A. Farooq This is the third part of my article series on Microsoft SQL Server 2014: Database Engine key new feature. In this part, I will talk about following two SQL Server 2014 features: Encryption for Backups and Resource Governor Enhancements for Physical I/O control. Encryption...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
1 … 5 6 7 8 9 … 15