Author: Basit Aalishan Masood-Al-Farooq

Pro Members SQL Server Standard Members

Partitioning Relational Data – (Part – 3)

by

Partitioning Relational Data – (Part – 3) By Basit A. Farooq This is the third part of the three part article series on partitioning relational data. In the first part of this three-part article series on partitioning relation data, I started the article by giving an introduction to partition relational data along with the reasons why you might want 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 Standard Members XML

XML Support and SQL Server (Part 3)

by

XML Support and SQL Server (Part 3) By Basit A. Farooq This article is the third part of the XML support and SQL Server article series. In this part, I’ll first talk about what fundamental problems we have in integration XML and SQL Server. Then, I’ll cover what storage options we have in SQL Server to store the XML 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 →
Pro Members SQL Server Standard Members

Partitioning Relational Data – (Part – 2)

by

Partitioning Relational Data – (Part – 2) By Basit A. Farooq This is the second part of the three part article series on partitioning relational data. In the first part of this three-part article series on partitioning relation data, I started the article by giving an introduction to partition relational data along with the reasons why you might want 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

Partitioning Relational Data – (Part 1)

by

Partitioning Relational Data – (Part – 1) By Basit A. Farooq Introduction A common requirement for dealing with large datasets is the ability to split the data into smaller blocks to help improve performance. Performance degradation is evident once the tables reach larger sizes, and therefore, it is sometimes appropriate to break large tables using a process called partitioning or...

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 Standard Members XML

XML Support and SQL Server (Part 2) – XML Schemas

by

XML Support and SQL Server (Part 2) – XML Schemas By: Basit A. Farooq XML schemas Although, it is possible to create an XML document that follows no formal structure if the document (or fragment) is for internal or your own use. However, this isn’t recommended. Because, as we all know, working without a formal design often leads to a...

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

Does my SQL Server database use any Edition specific features?

by

Does my SQL Server database use any Edition specific features? Author: Basit A. Farooq Introduction Today, I received a phone call from a friend who is thinking to downgrade the database hosted in SQL Server 2008 Enterprise Edition to SQL Server 2008 Standard Edition. He made me question whether this type of move is possible and is there any way...

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 Snapshots – A View of Database at a Specific Point in Time

by

Database Snapshots – A view of database at a specific point in time Author: Basit A. Farooq Introduction Beginning with SQL Server 2005, Microsoft introduced a new feature called database snaphots, which gives DBAs a way of presenting a consistent view of data at a certain time. So in other words we can say that it is a static, read-only...

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

XML Support and SQL Server (Part 1)

by

XML Support and SQL Server (Part 1) By Basit A. Farooq XML fundamentals Beginning with SQL Server 2005, Microsoft improved and expanded its eXtended Markup Language (XML) support, the activities that previously required complementary products now have native support. Native XML commands and utilities have been expanded to include new features. In this article, I’ll give you an overview 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
Continue Reading →
Pro Members SQL Server Standard Members

Planning for ETL

by

Planning for ETL solution By: Basit A. Farooq Introduction Because any business intelligence (BI) mainly deals with the data, without doubt, the solution includes an extraction, transformation and loading (ETL) components linking the data sources and destinations. After gathering business requirements, the first step in the ETL component design is to plan the data transfer and staging solutions that support...

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 Database Consolidation

by

SQL Server Database Consolidation By Basit A. Farooq Introduction The database expansion costs money, not just software licenses. It costs money in maintenance and hardware, and also impacting businesses by indirectly affecting the performance of other applications. Through database consolidation, companies can reduce the number of database servers that they have to manage and reduce the demand for servers and...

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 … 11 12 13 14 15