Author: Basit Aalishan Masood-Al-Farooq

Pro Members SQL Server Standard Members

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

by

Installing and Configuring SQL Server 2014 on Windows Server 2012 – (Part 4) Autor: Basit A. Farooq Installing instance of SQL Server 2014 on Windows Server 2012 In the part-1 of this five part article series, we discussed the SQL Server 2014 installation prerequisites and the steps that we must perform for the installation of SQL Server 2014 instance. In...

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

Incorporating logging, error handling, and reliability into your SQL Server Integration Services (SSIS) package design – (Part 3)

by

Incorporating logging, error handling, and reliability into your SQL Server Integration Services (SSIS) package design – (Part 3) Author: Basit A. Farooq In the first two parts of this three part article series on "Incorporating logging, error handling, and reliability into your SQL Server Integration Services (SSIS) package design", we discussed how to design and implement logging into your SQL...

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

Collations for supporting multiple languages in the instance of SQL Server

by

Collations to enable multiple language support in SQL Server instance Author: Basit A. Farooq SQL Server uses collations to determine how to compare and sort strings. When you understand sort orders and comparisons, you ensure that queries against the database perform the way you expect them to. Collations are also important when you are supporting multiple languages. In this article,...

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

Incorporating logging, error handling, and reliability into your SQL Server Integration Services (SSIS) package design – (Part 2)

by

Incorporating logging, error handling, and reliability into your SQL Server Integration Services (SSIS) package design – (Part 2) Author: Basit A. Farooq In the first of the three part article series on "Incorporating logging, error handling, and reliability into your SQL Server Integration Services (SSIS) package design", we discussed how to design and implement logging in a SQL Server Integration...

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

Incorporating logging, error handling, and reliability into your SQL Server Integration Services (SSIS) package design – (Part 1)

by

Incorporating logging, error handling, and reliability into your SQL Server Integration Services (SSIS) package design – (Part 1) Author: Basit A. Farooq SQL Server Integration Services (SSIS) – A very brief overview SQL Server includes SQL Server Integration Services (SSIS). It was first introduced in SQL Server 2005 as a replacement for the Data Transformation Service (DTS). SQL Server Integration...

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 3)

by

Installing and Configuring SQL Server 2014 on Windows Server 2012 – (Part 3) Autor: Basit A. Farooq Installing instance of SQL Server 2014 on Windows Server 2012 In the first of the five part article series, we discussed the SQL Server 2014 installation prerequisites and the steps that we must perform for the installation of SQL Server 2014 instance. In...

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 security best practices checklist – Part -2

by

Microsoft SQL Server security best practices checklist – Part – 2 Author: Basit A. Farooq Editor’s Note: This is the second part of my two part article series on SQL Server security best practices. SQL Server Administration Avoid managing SQL Server instances using sa or any other SQL login account that has been granted CONTROL SERVER permission, or is a...

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 security best practices checklist – Part -1

by

Microsoft SQL Server security best practices checklist – Part -1 Author: Basit A. Farooq Database technologies are an essential component of many information systems because they store a large amount of sensitive corporate data such as customer information and other confidential business data. Because of this, it is not wrong to say that databases such as SQL Server are the...

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 2)

by

Installing and Configuring SQL Server 2014 on Windows Server 2012 – (Part 2) Autor: Basit A. Farooq Installing instance of SQL Server 2014 on Windows Server 2012 In the first of the five part article series, we discussed the SQL Server 2014 installation prerequisites and the steps that we must perform for the installation of SQL Server 2014 instance. In...

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 5

by

SQL Server 2014 Replication – Part 5 Author: Basit A. Farooq Editor’s note: In this final part of my SQL Server 2014 Replication article series, you’ll learn about working of Peer-to-Peer replication. You’ll also learn about how to modify publication properties, and how to monitor replication. Peer-to-peer transactional replication Peer-to-peer transactional replication allows a SQL Server instance to act as...

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 … 4 5 6 7 8 … 15