SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 – Part 2

Using MAP to inventory your servers When you start MAP, the application prompts you for a database name (see figure below). At the very beginning there will be no database to hold MAP inventory information, so you will need to specify a new database name. You can name it anything, but for our purpose, I […]

Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 – Part 1

Auditing and inventorying is not something new in any IT environment. Depending on the purpose, it can take many forms. Sometimes the auditing is about security and data access. Sometimes it is about software usage and licensing. Often it is about consolidation and cost saving. Whatever the reason, the strategic direction typically comes from top […]

Find Duplicate Indexes on SQL Server (Script)

Like other mainstream commercial database systems, Microsoft SQL Server allows you to create multiple indexes on the same column of a table. This  increases the likelihood of having duplicate indexes in the database because SQL Server does not prevent you from creating duplicate indexes, infect we can create up to 999 duplicate indexes on each […]

Forwarding Pointers in Heaps

When no clustered index is defined on a table, that table is said to be a Heap. Heaps are not ideal when it comes to performance but there are lots of instances where you have heaps.   Operations on heaps INSERT -  New rows can be placed in the first available page with sufficient space. […]

Getting Started Formatting SSRS Reports

Formatting SSRS Report Introduction The SSRS report once ready  needs to be formatted to make it pixel perfect for viewing and printing. The formatting can be classified into the following types: Conditional Formatting Unconditional Formatting Conditional Formatting The conditional formatting  is done using the  IIF and  switch  statements. For conditional formatting can be used to […]

Storage Modes in SSAS (MOLAP, ROLAP and HOLAP)

Introduction There are three standard storage modes (MOLAP, ROLAP and HOLAP) in OLAP applications which affect the performance of OLAP queries and cube processing, storage requirements and also determine storage locations. SSAS (2005 and 2008) supports not only these three standard storage modes but supports proactive caching, a new feature with SSAS 2005 which enables […]

A Journey from OLTP to OLAP

Introduction In this first Part  of the series I will discuss the OLTP and OLAP and the transition from OLTP to OLAP in pursuit performance improvements as well as the benefits of the each technology. Note**: This article is intended for the users who are new to the concepts of the data warehousing. What is […]

Managing and Connecting to AlwaysOn Availability Groups

From the previous AlwaysOn Availability Group article, we provided a name for the availability group listener which is simply a unique DNS name as a Virtual Network Name (VNN) to direct read-write requests to the primary replica and read-only requests to the read-only secondary replica. In this way the client doesn’t need to know which […]

Configuring and Creating An AlwaysOn Availability Group in SQL Server 2012

In the previous article on AlwaysOn Availability Groups in SQL Server 2012, we looked at The Environmental Setup for An AlwaysOn Availability Group. In this article we turn our attention to the creation and configuration of the Availability Group. There are two primary steps to creating an AlwaysOn availability group which has to be done […]

SQL Server 2012 AlwaysOn Availability Group Environmental Setup

Continuing from AlwaysOn Part 1 the series continues with a step-by-step guide to setting up the environment for an AlwaysOn availability group. In this article we will break down AlwaysOn environment preparation into three steps : Installation of SQL Server 2012 on each node/replica/server. Installation of the failover clustering feature on each node/replica/server. Creation of […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |