SQL Server

Pro Members SQL Server Standard Members

General facts of SQL SERVER – part 1

by

General facts of SQL SERVER – Part 1 Introduction:- The cutting – edge and modest atmosphere of each and every business necessities a wide – ranged, protected, trustworthy plus a fruitful information podium for its commercial systems. The SQL SERVER Database Management System offers this podium which permits constructing as well as handling information systems. Additionally SQL SERVER Database Management...

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 Merge Replication Optimization Tips (Part 2)

by

SQL Server 2014 Merge Replication Optimization Tips (Part 2) Do not forgive to script your replication configuration. Because scripting the replication configuration is a key part of any disaster recovery plan for a replication topology, you should script your replication configuration from the replication wizards or from the Replication folder in Microsoft SQL Server Management Studio. If you do not...

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

Using the SSIS Merge Join to Synchronize Tables – Part 2

by

November 2014 Using the SSIS Merge Join to Synchronize Tables – Part 2 By Rocco Mastrangelo This article is Part 2 of a two-part series that describes how to keep two database tables synchronized using the Merge Join transform within Microsoft SQL Server Integration Services (SSIS). This solution is particularly useful for any ETL process that requires refreshing a target...

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 Merge Replication Optimization Tips (Part 1)

by

SQL Server 2014 Merge Replication Optimization Tips (Part 1) Create an index on each of the columns that is used in the filter’s WHERE clause. If you do not use indexes on columns used in filters the SQL Server must perform a table scan, which can results in performance degradation. Set the "Maximize Throughput for Network Applications" option. This can...

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

Using the SSIS Merge Join to Synchronize Tables – Part 1

by

November 2014 Using the SSIS Merge Join to Synchronize Tables – Part 1 By Rocco Mastrangelo This article is Part 1 of a two-part series which describes how to keep two database tables synchronized using the Merge Join transform within Microsoft SQL Server Integration Services (SSIS). This solution is particularly useful for any ETL process that requires refreshing a target...

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 Transactional Replication Optimization Tips

by

SQL Server 2014 Transactional Replication Optimization Tips Consider locating both the publisher and the distributor on the same physical server. You can place the publisher and the distributor on the same physical server when the publisher server can perform the distribution tasks without any performance problems. By the way, using a separate SQL Server for the Distributor requires separate 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

Planning of Database Structure & Organization — Part — 2

by

Planning of Database Structure & Organization – Part – 2 As stated in the last article that “In the forthcoming article we will be noticing particular fine point’s concerning different associations available like 1 – to – 1, 1 – to – N or N – to – 1”, here is the article. Associations:- The planning of associations is determined...

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 … 82 83 84 85 86 … 115