Standard Members

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 →
Development Pro Members Standard Members

Gearing up the Business for Data Analytics–Part III

by

Gearing up the Business for Data Analytics — Part III In the Part II of this series we briefly looked at the "Analytical Glossary of Requirements" Matrix. In this article we will try to understand how we construct the "Data availability matrix" for the requirement questions that were articulated in the "Analytical Glossary of Requirements". The term "data availability" is...

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 →
Development Pro Members Standard Members

Firing Employees as a Small Business Owner

by

Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have time to learn new technology or train their...

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 →
Development Pro Members Standard Members

How does a small business prepare for the holidays?

by

How Does a Small Business Prepare for the Holidays? Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t...

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

The Importance of Consistent Compliance and Ways to Achieve it

by

The Importance of Consistent Compliance and Ways to achieve it Why do we require consistent compliance? It has a very simple answer – audits can occur any time and you don’t want to be blacklisted by regulators. Stringent compliance policies were brought into action in the wake of exponential fiascos that uprooted businesses and public-sector organizations. Moreover, consistent compliance is...

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

by

SQL Server 2014 Snapshot Replication Optimization Tips Do not configure the Distribution Agent to run continuously. Try to schedule the Distribution Agent to run at regular intervals instead of running continuously. By using it, you can decrease the total SQL Server overhead. Consider placing snapshot folder on a disk that is not used to store database or log files. Placing...

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 … 63 64 65 66 67 … 110