Standard Members

Development Pro Members Standard Members

Gearing up your Business for data analytics – Part VI

Gearing up Your Business for Data Analytics – Part VI Having cleared our minds of possible confusions with regard to single view of customer and single view of data in the previous article in this series, let us move on to the study of data quality problems. For instance, if the customer data contains an email id, the same must...

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

Is it better to take a bad job with a good boss or a good job with a bad boss?

Is it better to take a bad job with a good boss or a good job with a bad boss? 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...

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
Pro Members SQL Server Standard Members

Analysis of Service Broker in line of Message Based Communication – Part 1

Analysis of Service Broker in line of Message Based Communication – Part 1 Introduction For a multi – tier (N – Tier) structural design, the client as well as the server may be positioned at an isolated site. The server, which applies the corporate guidelines, can offer services to the several clients in a single point of time. Hence, 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
Pro Members SQL Server Standard Members

Tips for using query hints in SQL Server 2014

Tips for using query hints in SQL Server 2014 If you want to set any hints for your query, do not remember to test the query with hint and without the hint and compare results. Because SQL Server 2014 query optimizer usually proposes the best execution plan, you should test the query with hint and use this hint only when...

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
Pro Members SQL Server Standard Members

Collations for supporting multiple languages in the instance of SQL Server

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

How should you handle email objections that don’t correlate with your requests?

How should you handle email objections that don’t correlate with your requests? 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...

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
Pro Members SQL Server Standard Members

General facts of SQL SERVER – part 5

General facts of SQL SERVER – Part 5 Classifying SQL SERVER opportunities SQL SERVER offers several options which can support an individual to increase the effectiveness of database formation. The SQL SERVER MANAGEMENT STUDIO (SSMS) is a system which aids in building plus retaining database’s different objects. The SQL SERVER BUSINESS INTELLIGENCE DEVELOPMENT STUDIO is an additional system which aids...

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
Pro Members SQL Server Standard Members

Tips for using table hints in SQL Server 2014

Tips for using table hints in SQL Server 2014 One of the ways to increase the queries performance is using the SQL Server 2014 table hints. The table hints specify a locking method to be used by the query optimizer with this table, specify the locking granularity for a table, or one or more indexes to be used by 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
Pro Members SQL Server Standard Members

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

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

Gearing up your Business for data analytics – Part V

Gearing up Your Business for Data Analytics – Part V In the previous articles we were looked at data requirements and data use at arm’s length. In this article we take a more granular approach to the analysis of data. We look at the quality of data with reference to any requirement questions that may have been raised by 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