Eu, Nogueira

 

O Microsoft SQL Server 2008® é hoje um dos melhores gerenciadores de banco de dados do mercado. Esta versão conta ainda com uma ferramenta para BI muito interessante e inovadora.

Segundo a Microsoft:

“O SQL Server 2008 é a base para a criação de soluções rápidas, inteligentes e eficientes. Ele funciona com seus sistemas de TI existentes e com dados Oracle, DB2, SAP e NetWeaver, reduz o tempo gasto na administração com um gerenciamento baseado em diretivas, diminui custos por meio da consolidação e virtualização de servidores e fornece os mais altos níveis de segurança, confiabilidade e escalabilidade. Além disso, o autoatendimento para criação e gerenciamento de relatórios e a facilidade de uso com aplicativos familiares, como o Microsoft Office e o Microsoft SharePoint, permitem que as pessoas dediquem mais tempo ao trabalho e percam menos tempo com treinamentos e solicitações de suporte técnico.”

Maiores detalhes você pode encontrar no documento Visão geral do SQL Server 2008, ou no documento Doze maneiras de reduzir custos com o SQL Server 2008, ou ainda em Impacto Econômico Total da Atualização do SQL Server 2008.

Sobre o Business Intelligence pode-se obter informações no documento Business Intelligence- prosperando na incerteza.

INSTALANDO E CONFIGURANDO O MS SQL SERVER 2008

Existem várias opções na instalação do SQL Server 2008. São elas:

  

  

  

Bom, agora iniciando a instalação, primeiro o programa de instalação identifica se existe algum problema que possa atrapalhar o funcionamento do SQL Server:

Depois disso entramos com a chave da licença, e aceitamos os termos de uso:

    

Depois você informa o que exatamente deseja instalar, configura a instância usada e o espaço em disco:

   

Configura a detalhes das contas do Servidor, tais como o SQL Server Agent e o Database Engine:

   

Informa a senha para funcionamento do Serviço e Usuário:

   

Bem, no meu caso aqui eu estarei usando o SharePoint, então escolhi esta opção abaixo:

Define algumas opções de envio de relatórios de problemas:

E agora pode ser que ocorra este problema abaixo:

    

Significa que a versão do seu Visual Studio 2008 está antiga.

Para resolver este problema, basta atualizar a versão do seu Visual Studio 2008:

    

O arquivo baixado é apenas um disparador do download completo:

  

 

Bem, daí por diante, basta ter muita – muita – paciência…

   

Bom, terminado o download do SP1 do Visual Studio 2008, vamos instalá-lo então:

Contagem regressiva:

   

Iniciado automaticamente!

 

 

Bem, esse processo também demora um pouco …

(1 dia e meio depois …)

Ok, ok, ok. Finalizado. Abaixo a tela de About do Visual Studio 2008. Repare no SP1:

 

Agora mais algumas checagens … (repare que agora o Visual Studio 2008 não causa problemas):

   

Lista do que vai ser instalado:

   

E a tão esperada instalação do MS SQL Server 2008 é iniciada.:

   

   

   

   

   

Bem, este processo também é um pouco demorado. Vamos aguardar…

Enquanto eu esperava descobri os arquivos temporários que a instalação manipula. Interessante:

   

Bem, vamos continuar aguardando …

Certo. Acabou. Depois de quase 2 horas, acabou.

   

Abaixo as informações Suplementares da tela:

The following notes apply to this release of SQL Server only.

Microsoft Update
For information about how to use Microsoft Update to identify updates for SQL Server 2008, see the Microsoft Update Web site <http://go.microsoft.com/fwlink/?LinkId=108409> at http://go.microsoft.com/fwlink/?LinkId=108409.

Reporting Services
The Reporting Services installation options that you specified in Setup determine whether additional configuration is required before you can access the report server. If you installed the default configuration, the report server can be used immediately. If you installed the program files only, you must run the Reporting Services Configuration tool to deploy the report server.
To install the Reporting Services Add-in for SharePoint Technologies, start the rsSharePoint.msi in the Setup folder on the SQL Server 2008 installation media after SQL Server Setup is complete.

Documentation and Samples
To install the .NET Framework SDK, see “Installing the .NET Framework SDK” in SQL Server 2008 Books Online <http://go.microsoft.com/fwlink/?LinkId=114089> at http://go.microsoft.com/fwlink/?LinkId=114089.

By default, sample databases and sample code are not installed as part of SQL Server Setup. To install sample databases and sample code for non-Express editions of SQL Server 2008, see the CodePlex Web site <http://go.microsoft.com/fwlink/?LinkId=87843> at http://go.microsoft.com/fwlink/?LinkId=87843. To read about support for SQL Server sample databases and sample code for SQL Server Express, see Databases and Samples Overview <http://go.microsoft.com/fwlink/?LinkId=110391> on the CodePlex Web site at http://go.microsoft.com/fwlink/?LinkId=110391.

For more information about late-breaking changes in this release of SQL Server, see the latest readme file <http://go.microsoft.com/fwlink/?LinkId=100093> at http://go.microsoft.com/fwlink/?LinkId=100093.

For information about SQL Server 2008 Surface Area Configuration, see the following SQL Server 2008 documentation topics:

In SQL Server 2008 Books Online: “Understanding Surface Area Configuration.”

In SQL Server 2008 Setup Help: “Minimize SQL Server 2008 Surface Area.”

    In SQL Server 2008 Books Online on MSDN: Understanding Surface Area Configuration <http://go.microsoft.com/fwlink/?LinkId=106282>     at http://go.microsoft.com/fwlink/?LinkId=106282.

E também a relação dos Updates aplicados no Visual Studio 2008:

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB944899)   KB944899
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/944899.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB945282)   KB945282
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/945282.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB946040)   KB946040
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/946040.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB946308)   KB946308
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/946308.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB946344)   KB946344
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/946344.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB946581)   KB946581
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/946581.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB946673)   KB946673
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/946673.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB947171)   KB947171
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/947171.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB947173)   KB947173
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/947173.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB947180)   KB947180
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/947180.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB947540)   KB947540
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/947540.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB947789)   KB947789
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/947789.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB948127)   KB948127
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/948127.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB953256)   KB953256
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/953256.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB971091)   KB971091
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/971091.

Hotfix for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB973674)   KB973674
This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/973674.

Microsoft Visual Studio Team System 2008 Team Suite – ENU Service Pack 1 (KB945140)   KB945140
This service pack is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this service pack will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/945140.

Microsoft Visual Studio Team System 2008 Team Suite – ENU Service Pack 1 (KB947888)   KB947888
This service pack is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this service pack will be uninstalled

automatically.
For more information, visit http://support.microsoft.com/kb/947888.

Update for Microsoft Visual Studio Team System 2008 Team Suite – ENU (KB972221)   KB972221
This update is for Microsoft Visual Studio Team System 2008 Team Suite – ENU.
If you later install a more recent service pack, this update will be uninstalled

automatically.

Vamos agora desligar e ligar o PC (coisas de Windows…).

Pois bem, SQL Server 2008 instalado e totalmente integrado ao Visual Studio 2008:

   

   

Agora vamos comprovar o tal “poder” desta versão! Até mais!