Author: Basit Aalishan Masood-Al-Farooq

Pro Members SQL Server Standard Members

Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 1)

by

Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 1) Author: Basit A. Farooq Editor’s Note: This is the two part article series on designing and implementing online analytical processing (OLAP) architecture. In this article series, I will first discuss how to design and implement logical multidimensional solution architecture. After that, I will explain the design considerations for online...

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 index related dynamic management views and functions – (Part 3)

by

SQL Server index related dynamic management views and functions – (Part 3) By Basit A. Farooq Editor’s Note: This is the part-3 of this three part article series on index-related dynamic management and functions. In this part, I’ll be covering following index-related dynamic management views (DMVs) that are helpful to find missing indexes inside databases. Introduction: With the release 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

Tips for Minimizing Deadlocks

by

Tips for Minimizing Deadlocks By Basit A. Farooq The Database servers are configured in such a way that they can service multiple requests from multiple users. Obviously this increases the likelihood of conflicts because multiple processes can request access to same resources at the same time. This type of conflict is also known as block or blocking. The blocking 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

XML Support and SQL Server (Part 6)

by

XML Support and SQL Server (Part 6) By Basit A. Farooq Editor’s Note: This is the sixth part of my XML support and SQL Server article series. In this part, you will learn about the XML primary indexes and secondary indexes. XML indexes As we all know that XML query processing is resource-intensive, because SQL Server parses the XML instance...

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

The Public Role — a potential high risk security concern for DBAs

by

The Public Role – a potential high risk security concern for DBAs By Basit A. Farooq In this article, I’ll discuss the security issues associated with the public database role, and how you can quickly find privileges granted to the public database role in each database. Finally, I’ll discuss how you can properly revoke the privileges granted to public 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
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server index related dynamic management views and functions – (Part 2)

by

SQL Server index related dynamic management views and functions – (Part 2) By Basit A. Farooq Editor’s Note: This is the part-2 of this this three part article series on index-related dynamic management and functions. In this part, I’ll be covering index-related dynamic management function (DMF): sys.dm_db_index_physical_stats. Introduction: SQL Server uses indexes to sort and organize table data. It creates...

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 index related dynamic management views and functions – (Part 1)

by

SQL Server index related dynamic management views and functions – (Part 1) By Basit A. Farooq Microsoft SQL Server provides DBAs and Developers with several index related dynamic management views and functions, which they can use to maintain, modify, tune and identify missing indexes. Some of these dynamic management views (DMVs) and dynamic management function (DMFs) you might use are...

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: Purging msdb History Tables to Control msdb Database Growth

by

SQL Server: Purging msdb History Tables to Control msdb Database Growth By Basit A. Farooq From time to time, I see the following question posted on various SQL Server forums by different users asking why the msdb database on their SQL Server instance is too big. As we all know, msdb is a system database that supports 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

XML Support and SQL Server (Part 5)

by

XML Support and SQL Server (Part 5) By Basit A. Farooq Editor’s Note: This article is the fifth part of my XML support and SQL Server article series. In this part, I’ll discuss the basic XML queries and data manipulation. I’ll also give the brief introduction to the XQuery language and the use of query(), value(), exist(), nodes(), and modify()...

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

by

XML Support and SQL Server (Part 4) By Basit A. Farooq Editor’s Note: This article is the fourth part of my XML support and SQL Server article series. In this part, I’ll talk about XML data type. I’ll also demonstrate how you can create XML variables and XML columns, and compare between typed and untyped XML. With the release 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 →
1 … 10 11 12 13 14 15