This is an overview of what we have learned and the final outcome...

In the final part of the series, we learn how to use SQLDiag, some of it’s most useful input parameters and consume the multi-functional trace template we defined using the SQLDiag Configuration utility to generate SQL profiler trace and correlated Wind...

In this last section we will discuss using typography within our design and use basic techniques to create and interesting typographical look towards our design....

Raising the stakes a bit, we learn about the SQLDiag and the SQLDiag Configuration utility – an advanced utility that allows you greater control over your SQL trace by allowing you to define and customize a SQL trace, a Perfmon trace and the capture of ...

In this section we will learn how to learn the basic function of the Pen Tool. We will work with selections and also learn to use the eraser to erase items. ...

This tutorial will help in getting started with SSAS Multidimensional...

In this chapter, we learn how to use the SQL Profiler to create the T-SQL definition of any given trace template, customize it and execute it as a server-side trace using T-SQL. ...

The graphical UI of the profiler and the fact that it’s a client-side trace adds to additional load on an already ailing server. In this chapter, we look at the basics of building our first SQL trace template using nothing but pure T-SQL....

In this section we will continue to add texture to our background, work with blending modes and we will implement the gradient tool and blend it with the new texture we add...

In this chapter, we will study how to correlate the profiler trace with Windows Profiler Log Data. This is important when you suspect that SQL Server is either being held up by or is the cause of an I/O, memory or processor contention....