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