Standard Members

Development Pro Members Standard Members

How can a company plan for growth in this upcoming business year?

How Can a Company Plan for Growth in this Upcoming Business Year? 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 4

General facts of SQL SERVER – Part 4 Common language runtime (CLR) The Common Language Runtime (CLR) is an utmost important module of the .NET framework. It offers a podium for the systems to execute. The Common Language Runtime (CLR) offers services like error or bug controlling, safety, correcting the code plus version sustenance to the systems. A number of...

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

Some tips to work with SQL Server 2014 alerts

Some tips to work with SQL Server 2014 alerts SQL Server writes the events to the Windows Application log. SQL Server Agent checks the Windows application log for SQL Server events. An alert is an automated response to events raised by SQL Server. When an event occurs, the SQL Server Agent checks if the appropriate alert exists and if so...

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 1)

Incorporating logging, error handling, and reliability into your SQL Server Integration Services (SSIS) package design – (Part 1) Author: Basit A. Farooq SQL Server Integration Services (SSIS) – A very brief overview SQL Server includes SQL Server Integration Services (SSIS). It was first introduced in SQL Server 2005 as a replacement for the Data Transformation Service (DTS). 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 the Business for Data Analytics–Part IV

Gearing up the Business for Data Analytics–Part IV In the previous articles we were focused on Analytics requirements and data availability for analytics. In this article we delve deeper into the topic and examine whether the available data is of the required quality or not. What is Data Quality? The two most important characteristics that determine the quality of data...

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

Should I separate my personal and professional values?

Should I Separate My Personal and Professional Values? 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...

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 3

General facts of SQL SERVER – Part 3 Database engine The database engine offers sustenance to stock, enquiry, fabricate plus protect the information on the database server. The database engine is comprises of databases plus database objects for an example tables, store procedures, triggers, view, etc. This database engine permits an individual to produce as well as handle the database...

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 stored procedures in SQL Server 2014

Tips for using stored procedures in SQL Server 2014 Try to avoid using temporary tables and DDL (Data Definition Language) statements inside your stored procedure. Using temporary tables or DDL statements inside stored procedure reduces the chance to reuse the execution plan. Call stored procedure using its fully qualified name. The complete name of an object consists of four identifiers:...

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

Installing and Configuring SQL Server 2014 on Windows Server 2012 – (Part 3)

Installing and Configuring SQL Server 2014 on Windows Server 2012 – (Part 3) 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
Pro Members SQL Server Standard Members

General facts of SQL SERVER – part 2

General facts of SQL SERVER – Part 2 Three – tier (3 – tier) structural design As soon as one starts executing difficult commercial way outs in a two – tier (2 – tier) structural design, the tier that implements the corporate guidelines turns out to be overloaded. As an outcome, it needs extra period of time to accomplish 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