Author: Basit Aalishan Masood-Al-Farooq

Pro Members SQL Server Standard Members

Microsoft SQL Server 2014: Database Engine key new features – (Part 2)

by

Microsoft SQL Server 2014: Database Engine key new features – (Part 2) Author: Basit A. Farooq This is the second part of my article series on Microsoft SQL Server 2014: Database Engine key new feature. In this part, I will talk about SQL Server 2014 columnstore indexes. Updateable clustered columnstore index With the release of SQL Server 2012, Microsoft introduced...

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

SQL Server 2014 Replication – Part 1

by

SQL Server 2014 Replication – Part 1 Author: Basit A. Farooq; You use replication to move data between servers. Replication is important in distributed environments, when archiving data, and as an inexpensive way to support high availability. In this topic, you will learn about the different types of replication, the components involved in replication, and the steps necessary to configure...

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

Microsoft SQL Server 2014: Database Engine key new features – (Part 1)

by

Microsoft SQL Server 2014: Database Engine key new features – (Part 1) Author: Basit A. Farooq Earlier this year, Microsoft released SQL Server 2014. Like previous releases of SQL Server, Microsoft further enhances the SQL Server Database Engine. Microsoft not only improved existing SQL Server Database Engine features, but also introduces many new Database Engine features, including new in-memory OLTP...

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

Developing Report Models – (Part 1)

by

Developing Report Models – (Part 1) Author: Basit A. Farooq A report model is a metadata description of a data source. It contains a business model of a data, a physical model of the underlying database, and a mapping between the two. The business model, also known as a semantic model, describes the data by using familiar business names, usually...

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

Guidelines and Best Practices for developing and implementing a Reporting Solution with SQL Server 2014 – (Part 2)

by

Guidelines and Best Practices for developing and implementing a Reporting Solution with SQL Server 2014 – (Part 2) Author: Basit A. Farooq Editor’s Note: In the first of this three part article series, I discussed the considerations for creating reports. In this part, I will talk about the guidelines and best practices for implementing data sources and report layouts. Guidelines...

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

Guidelines and Best Practices for developing and implementing a Reporting Solution with SQL Server 2014 – (Part 1)

by

Guidelines and Best Practices for developing and implementing a Reporting Solution with SQL Server 2014 – (Part 1) Author: Basit A. Farooq Introduction Your reporting solution design should match technologies provided by Microsoft SQL Server™ 2014 Reporting Services to the requirements and abilities of users, and the requirements of the business. The documents that make up your reporting specification should...

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

Handling blocks and deadlock in SQL Server

by

Handling blocks and deadlocks in SQL Server Author: Basit A.Farooq A database server should be able to service requests from a large number of concurrent users. When a database server is servicing requests from many clients, there is a strong possibility that conflicts will occur because different processes request access to the same resources at the same time. A conflict...

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

Understanding the purpose of SQL Server Agent – (Part 2)

by

Understanding the purpose of SQL Server Agent – (Part 2) Author: Basit A. Farooq Creating a job with Transact-SQL You can also use the store procedures in the msdb database. SQL Server includes system stored procedures for managing jobs, schedules, operators, and alerts. These are: dbo. sp_add_job, dbo.sp_add_job_step, dbo.sp_add_schedule,dbo.sp_attach_schedule, and dbo.sp_add_jobserver. Creating job using SQL Server system stored procedures To...

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

Understanding the purpose of SQL Server Agent – (Part 1)

by

Understanding the purpose of SQL Server Agent – (Part 1) Author: Basit A. Farooq The SQL Server Agent is a Windows service that runs scheduled jobs. A job is a set of one or more management tasks.The SQL Server Agent service depends on the SQL Server service. In this article, you will learn how to configure the SQL Server Agent...

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

SQL Server Integration Service (SSIS): Import and Export wizards

by

SQL Server Integration Service (SSIS): Import and Export wizards Author: Basit A. Farooq SQL Server includes SQL Server Integration Services (SSIS). SSIS is primarily a data transform and load utility, but its functionality goes beyond that. SSIS provides a flexible development environment that you can use to identify sources and destinations, processing actions, and decision logic. Several SQL Server 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
Continue Reading →
1 … 6 7 8 9 10 … 15