<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
  <Body>
    <ReportItems>
      <Textbox Name="Textbox1">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>Azure SQL DB</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>=IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "White", "Silver")</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox1</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>=IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "ReportLibrary", Nothing)</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>3.01445in</Top>
        <Left>0.71333in</Left>
        <Height>0.46666in</Height>
        <Width>8.45833in</Width>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>=IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "DimGray", "DarkGray")</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox2">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>=IIF(Sum(Fields!compatibility_level.Value, "CompatLevel") &gt; 80,"SQL Server 2012 or newer", "DB Compat. Level is too Low")</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>=IIF(First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt;  5 AND First(Fields!ProductMajorVersion.Value, "Version") &gt;=11 AND First(Fields!compatibility_level.Value, "CompatLevel") &gt; 80, "White", "Silver")</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox1</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>=IIF(First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt;  5 AND First(Fields!ProductMajorVersion.Value, "Version") &gt;=11 AND First(Fields!compatibility_level.Value, "CompatLevel") &gt; 80, "MainReport", Nothing)</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>3.61775in</Top>
        <Left>0.71333in</Left>
        <Height>0.46666in</Height>
        <Width>8.45833in</Width>
        <ZIndex>1</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>=IIF(First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt;  5 AND First(Fields!ProductMajorVersion.Value, "Version") &gt;=11 AND First(Fields!compatibility_level.Value, "CompatLevel") &gt; 80, "DimGray", "DarkGray")</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox3">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>=IIF(Sum(Fields!compatibility_level.Value, "CompatLevel") &gt; 80,"SQL Server 2008 r2 or Older", "DB Compat. Level is too Low")</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>=IIF(First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt;  5 AND First(Fields!ProductMajorVersion.Value, "Version") &lt; 11 AND First(Fields!compatibility_level.Value, "CompatLevel") &gt; 80, "White", "Silver")</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox1</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>=IIF(First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt;  5 AND First(Fields!ProductMajorVersion.Value, "Version") &lt; 11 AND First(Fields!compatibility_level.Value, "CompatLevel") &gt; 80, "MainReport2008", Nothing)</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>4.22106in</Top>
        <Left>0.71333in</Left>
        <Height>0.46666in</Height>
        <Width>8.45833in</Width>
        <ZIndex>2</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>=IIF(First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt;  5 AND First(Fields!ProductMajorVersion.Value, "Version") &lt; 11 AND First(Fields!compatibility_level.Value, "CompatLevel") &gt; 80, "DimGray", "DarkGray")</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox4">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>="SQL Server Assessment and MonitoringTool on " &amp; First(Fields!ServerName.Value, "ServerName")</Value>
                <Style>
                  <FontSize>28pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox4</rd:DefaultName>
        <Top>0.21333in</Top>
        <Left>0.205in</Left>
        <Height>1.55001in</Height>
        <Width>9.39167in</Width>
        <ZIndex>3</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox5">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>Disclaimer</Value>
                <Style>
                  <FontSize>14pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>Please use caution when running in a production environment.  Do proper testing and evaluation before doing so.</Value>
                <Style>
                  <FontSize>14pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox4</rd:DefaultName>
        <Top>2.17083in</Top>
        <Left>0.205in</Left>
        <Height>0.77417in</Height>
        <Width>9.39167in</Width>
        <ZIndex>4</ZIndex>
        <Style>
          <Border>
            <Color>Gray</Color>
            <Style>None</Style>
          </Border>
          <VerticalAlign>Top</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox6">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>  These reports are intended to simply give data professionals an easy way to get information about the databases and server</Value>
                <Style>
                  <FontSize>14pt</FontSize>
                  <Color>White</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox4</rd:DefaultName>
        <Top>7.80499in</Top>
        <Left>0.71333in</Left>
        <Height>0.99917in</Height>
        <Width>8.45833in</Width>
        <ZIndex>5</ZIndex>
        <Style>
          <Border>
            <Color>Gray</Color>
            <Style>None</Style>
          </Border>
          <VerticalAlign>Top</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Line Name="Line1">
        <Top>1.99027in</Top>
        <Left>0.205in</Left>
        <Height>0in</Height>
        <Width>9.39167in</Width>
        <ZIndex>6</ZIndex>
        <Style>
          <Border>
            <Color>Gray</Color>
            <Style>Solid</Style>
          </Border>
        </Style>
      </Line>
      <Textbox Name="Textbox7">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>=IIF(Sum(Fields!compatibility_level.Value, "CompatLevel") &gt; 80, "Go To the Report Library", "DB Compat. Level is too low")</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>=IIF(Sum(Fields!compatibility_level.Value, "CompatLevel") &gt; 80, "White", "LightGray")</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox7</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>=IIF(Sum(Fields!compatibility_level.Value, "CompatLevel") &gt; 80, "ReportLibrary", Nothing)</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>5.0288in</Top>
        <Left>0.71333in</Left>
        <Height>0.55833in</Height>
        <Width>8.45833in</Width>
        <ZIndex>7</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>=IIF(Sum(Fields!compatibility_level.Value, "CompatLevel") &gt; 80, "DimGray", "DarkGray")</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Line Name="Line2">
        <Top>7.60888in</Top>
        <Left>1.23833in</Left>
        <Height>0in</Height>
        <Width>7.29167in</Width>
        <ZIndex>8</ZIndex>
        <Style>
          <Border>
            <Color>Gray</Color>
            <Style>Solid</Style>
          </Border>
        </Style>
      </Line>
      <Line Name="Line3">
        <Top>4.86666in</Top>
        <Left>1.86333in</Left>
        <Height>0in</Height>
        <Width>6.66667in</Width>
        <ZIndex>9</ZIndex>
        <Style>
          <Border>
            <Color>Teal</Color>
            <Style>Solid</Style>
            <Width>0.25pt</Width>
          </Border>
        </Style>
      </Line>
      <Textbox Name="Textbox8">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>Deploy All or Part of the Monitor Solution and Reports</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>=IIF(Sum(Fields!compatibility_level.Value, "CompatLevel") &gt; 80, "White", "LightGray")</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox7</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>MonitorAreYouSure</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>5.89878in</Top>
        <Left>0.71333in</Left>
        <Height>0.69166in</Height>
        <Width>8.45833in</Width>
        <ZIndex>10</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>=IIF(Sum(Fields!compatibility_level.Value, "CompatLevel") &gt; 80, "DimGray", "DarkGray")</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>6pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Textbox Name="Textbox9">
        <CanGrow>true</CanGrow>
        <KeepTogether>true</KeepTogether>
        <Paragraphs>
          <Paragraph>
            <TextRuns>
              <TextRun>
                <Value>Help for the Monitoring Solution, Read before deploying</Value>
                <Style>
                  <FontSize>22pt</FontSize>
                  <Color>=IIF(Sum(Fields!compatibility_level.Value, "CompatLevel") &gt; 80, "White", "LightGray")</Color>
                </Style>
              </TextRun>
            </TextRuns>
            <Style>
              <TextAlign>Center</TextAlign>
            </Style>
          </Paragraph>
        </Paragraphs>
        <rd:DefaultName>Textbox7</rd:DefaultName>
        <ActionInfo>
          <Actions>
            <Action>
              <Drillthrough>
                <ReportName>MonitorHelp</ReportName>
              </Drillthrough>
            </Action>
          </Actions>
        </ActionInfo>
        <Top>6.72708in</Top>
        <Left>0.71333in</Left>
        <Height>0.76666in</Height>
        <Width>8.45833in</Width>
        <ZIndex>11</ZIndex>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
          <BackgroundColor>=IIF(Sum(Fields!compatibility_level.Value, "CompatLevel") &gt; 80, "DimGray", "DarkGray")</BackgroundColor>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>4pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
      </Textbox>
      <Line Name="Line4">
        <Top>5.7643in</Top>
        <Left>1.86333in</Left>
        <Height>0in</Height>
        <Width>6.66667in</Width>
        <ZIndex>12</ZIndex>
        <Style>
          <Border>
            <Color>Teal</Color>
            <Style>Solid</Style>
            <Width>0.25pt</Width>
          </Border>
        </Style>
      </Line>
    </ReportItems>
    <Height>10.62027in</Height>
    <Style>
      <BackgroundColor>DarkBlue</BackgroundColor>
    </Style>
  </Body>
  <Width>9.81667in</Width>
  <Page>
    <LeftMargin>1in</LeftMargin>
    <RightMargin>1in</RightMargin>
    <TopMargin>1in</TopMargin>
    <BottomMargin>1in</BottomMargin>
    <Style />
  </Page>
  <AutoRefresh>0</AutoRefresh>
  <DataSources>
    <DataSource Name="Local">
      <ConnectionProperties>
        <DataProvider>SQL</DataProvider>
        <ConnectString>Data Source=LocalHost;Initial Catalog=master</ConnectString>
        <IntegratedSecurity>true</IntegratedSecurity>
      </ConnectionProperties>
      <rd:SecurityType>Integrated</rd:SecurityType>
      <rd:DataSourceID>26d8b005-009f-4bad-9256-57bf3db8f8cd</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="ServerProperty">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>SELECT ServerProperty('EngineEdition') AS 'EngineEdition'</CommandText>
      </Query>
      <Fields>
        <Field Name="EngineEdition">
          <DataField>EngineEdition</DataField>
          <rd:TypeName>System.Object</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="Version">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>SELECT  SERVERPROPERTY('ProductMajorversion') AS 'ProductMajorVersion'</CommandText>
      </Query>
      <Fields>
        <Field Name="ProductMajorVersion">
          <DataField>ProductMajorVersion</DataField>
          <rd:TypeName>System.Object</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="CompatLevel">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>SELECT compatibility_level  
FROM sys.databases WHERE name = DB_Name()  </CommandText>
      </Query>
      <Fields>
        <Field Name="compatibility_level">
          <DataField>compatibility_level</DataField>
          <rd:TypeName>System.Byte</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="ServerName">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>SELECT @@ServerName AS 'ServerName'</CommandText>
      </Query>
      <Fields>
        <Field Name="ServerName">
          <DataField>ServerName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
  <rd:ReportID>5ac63fc1-a913-4be3-aa85-d16d71056b35</rd:ReportID>
</Report>