Standard Members

Pro Members SQL Server Standard Members

RDBMS Concept In Normalization & De-normalization of Data — Part 2

by

RDBMS Concept In Normalization & De-normalization of Data – Part 2 As stated in the last article that “In the forthcoming article we will be noticing particular fine point’s concerning diverse Normal Forms (1NF and 2NF)”, here is the article. Defining Different Normal Forms:- The First Normal Form (1NF):- Emp_Code Emp_Department Emp_Department_Head Emp_Project_Code Emp_Hours E001 Marketing E011 P147 P541 P210...

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

Attribute Discretization Part I: Introduction and Overview

by

Attribute Discretization Part I: Introduction and Overview This is the charter article of the SSWUG Elemental SQL Server Analysis Services Multidimensional 2012 series. – In this and subsequent parts of the article, we will introduce attribute discretization in SQL Server Analysis Services (“SSAS”) – Multidimensional, focusing upon the purpose and benefits of this capability, which, as we shall see, affords...

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

What to do before leaving and after returning from vacation

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

Tips for using backup and restore in SQL Server 2014

by

Tips for using backup and restore in SQL Server 2014 Consider using SQL Server backup (restore) to (from) URL. In SQL Server 2014 you can use SQL Server Management Studio to backup to or restore from Windows Azure Blob storage service. This new option is available both for the Backup task, and maintenance plans. Use SQL Server 2014 backup encryption....

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

RDBMS Concept In Normalization & De-normalization of Data — Part 1

by

RDBMS Concept In Normalization & De-normalization of Data – Part 1 Introduction: A database design is trailed by a significant investigation of data to certify that the data in the database tables are reliable and appropriate. Normalization is a procedure of dropping the recurrence of data in a Relational Database Management System (RDBMS). However occasionally, a database designer may possibly...

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

Database Design Interview Questions

by

Database Design Interview Questions Author: Basit A. Farooq In this article, we will outline questions suitable for a Database Developer/Database Analyst interview to assess the candidates skills related to database design. Question 1: What is Database Management System (DBMS)? Answer: The software that manages the storage and access to the data in the databases. Question 2: Describe the main phases...

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

Problem business partner

by

Problem Business Partner 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...

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

Tips for using constraints in SQL Server 2014

by

Tips for using constraints in SQL Server 2014 Use CHECK constraints instead of rules. Rules are provided for backward compatibility and have been replaced by CHECK constraints. Constraints are much more efficient than rules and can boost performance. Rules have some restrictions. For example, only one rule can be applied to a column, but multiple CHECK constraints can be applied....

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 I

by

Data Analytics is not as simple as it is often imagined to be. I have come across people who tell me that there is nothing to it because there are a number of tools available in the market to help you mine your data. It is a good idea to remember that off-the-shelf tools are built to cater to organizations...

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

Mono-tasking Versus Multi-tasking? Which is better?

by

Mono-tasking Versus Multi-tasking? Which is better? Hello, this is Laura Lee Rose. I am a speaker and author. My background is 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...

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 … 67 68 69 70 71 … 110