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...
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...
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...
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...
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,...
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...
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...
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...
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...
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...