Niko neugebauer 16 12 2010 sqlport
Download
1 / 24

«SQL Server Denali CTP 1» - PowerPoint PPT Presentation


  • 83 Views
  • Uploaded on

Niko Neugebauer (16.12.2010) SQLPort. «SQL Server Denali CTP 1». MCITP Developer 2005 Líder e fundador da comunidade SQLPort Mentor Regional PASS para «Western Europe » Consultor da Novabase na CGD http :// www.sqlport.com # NikoNeugebauer. Niko Neugebauer.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' «SQL Server Denali CTP 1»' - joshua-savage


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Niko neugebauer 16 12 2010 sqlport

NikoNeugebauer

(16.12.2010)SQLPort

«SQL ServerDenaliCTP 1»


Sql server denali ctp1

  • MCITP Developer 2005

  • Líder e fundador da comunidade SQLPort

  • Mentor Regional PASS para «Western Europe»

  • Consultor da Novabase na CGD

  • http://www.sqlport.com

  • #NikoNeugebauer

Niko Neugebauer

«SQL Server Denali CTP1»


Sql server denali ctp11

  • História e Datas

  • Setup & Requirements

  • O queéqueestá noCTP 1 e o quenão

  • Novo T-SQL

  • DB Containment

  • Project «Juneau»

  • Projects «Crescent» + «Atlanta»

  • HADR / Always On

«SQL Server Denali CTP1»


Hist ria e datas

  • SQL Server codenames: Yukon, Katmai, Kilimanjaro, Denali

  • Release cada 24-36 meses

  • Denali – é a montanhamaisaltaem America do Norte

  • O Próximo PASS Summit estámarcadopara o Outubro de 2011

História e Datas


Ctp1 contem

  • Novidadesde T-SQL

  • Contained Databases

  • Server role

  • FullText (office docs search)

  • Spatial

  • SSIS, SSAS, SSRS ?

CTP1 contem:


N o est inclu do no ctp1

Não está incluído no CTP1:


Requirements

  • PowerShell 2.0 (nãoestáincluído no Setup)

  • .NET 4.0

  • No-Reboot Package

  • 32-bit still supported (por agora) – mas semAWE!

  • Retiradoapoio: Itanium, 80 compatibilidade

  • Windows Core

  • CPU 1.4 Ghz, Recomendado 2.0 Ghz

  • 512MB RAM, Recomendado 2GB

  • 2GB ComponentesBásicos, rapidamentechegaaos 4GB

Requirements


Setup

Setup


Whats new in t sql

  • Paginação

  • SuporteparaUCS-2

  • Error Handling

  • Geradores de sequências

  • Melhoramentosparao EXECUTE

  • Descoberta de Results Set Metadata (substituiSET FMTONLY)

Whats new in T-SQL ?


Suporte para ucs 2

  • Unicode Characters ocupam 16-bits cada (NCHAR/NVARCHAR)

  • O UCS-2 especificaçãoexige 4 bytes

  • Agora vaiter

  • Novos «Collations» queacabam com _CS

  • Estes novos «Collations» tratambemos characters

Suportepara UCS-2


Db containment

  • BD Isolados

  • Opção CONTAINMENT = PARTIAL, é a única opção suportada em Denali, o que significa um «containment» que não está a ser enforçado.

  • sp_configure- para permitir utilização de «containment», global para o servidor

  • sys.dm_db_uncontained_entities - mostra todos os potenciais problemas com «containment»

  • O trabalhoestámuito no início

DB Containment


Project juneau

  • The goal is to unite experience in Visual Studio and to provide single environment for everyone including BI.

  • High productivity environment for SQL Server, SQL Azure and BI

  • Connected and offline database Development

  • Edition-aware development environment

  • Integrated application/database development

  • Compile warnings and errors in the style of Visual Studio or Eclipse

  • Tooltips when meeting errors

  • Execute with Debugger

Project «Juneau»


Project juneau1

  • PowerBuffer:

    computes and generates the alter script

    -> new COMMIT button

    -> you will see a list with changes to be made, like created indexes or altered stored procedure or ...

    -> and then you have 3 options: generate script, commit and cancel

  • New Table Designer

    -> if you delete a column from the table -> will receive warnings about all the references that were affected

Project «Juneau»


Project juneau2

  • Database Team-Development:

  • Clone DB into filesystem

  • Depois faz-se disconnect -> mas temos o nosso projecto no Project Explorer

  • NEW FEATURE in DENALI: «LOCAL DB» -> locally activated instance of SQL Server. Is inside Visual Studio.

    Imagine: se nãotiverpermissõessufficientes, vaioffline.

    LOCAL DB éumafeaturedifferente de Containment DB

    LOCAL DB tem todas as Enterprise Features

    LOCAL DB étipo um Snapshot

    - Podemosdepoisfazer schema compare, data compare

    - Funcionalidade «CheckPoint» (é um snapshot)

    - Função«Generate Script Against CheckPoint»

    - Find References, REFACTOR

Project «Juneau»


Project juneau3

  • Debugging:

    • Fazendo Debug em C# ou VB# podemospôrum «breakpoint» no stored procedure e aíéquevaipararmemso.

    • Podeespecificarcondições de breakpoint, contadores de “hits”, filteres e acções. A ediçãonaaltura de execuçãotambémpossível.

    • Podefazerwatch aosexpressões de T-SQL e verQuick Info tooltips.

    • IntelliSense agora tem validação de Breakpoints.

  • Debug funciona com BDs desde SQL Server 2005 SP2.

Project «Juneau»


Project atlanta

  • Cloud Based SQL Server Monitoring

  • SQL Server 2008 / 2008 R2

  • Transfere “Diagnostics Data” para Cloud

  • Tem um certodemoro, entãonãoéReal-Time

  • Microsoft Engineer «Checklist in an hour»

Project «Atlanta»


Project crescent

  • Project “Crescent” expands on the Self-Service BI capabilities delivered with PowerPivot for Excel by enabling customers to visualize and interact with the modeled data in a fun and meaningful way using highly interactive visualizations, animations and smart querying and present and share insights with others in the organization through rich storyboard presentation capabilities.

  • The first public CTP for Project “Crescent” is currently planned for the first half of calendar year 2011.

Project «Crescent»


Hadr always on

HADR capabilities delivered with PowerPivot for Excel by enabling customers to visualize and interact with the modeled data in a fun and meaningful way using highly interactive visualizations, animations and smart querying and present and share insights with others in the organization through rich storyboard presentation capabilities.- High Availability / Disaster Recovery

  • O deploy de "HADR" involve configuração de uma ou mais «availabilitygroups».

  • Até 4 servidores no grupo (2 sync e 2 async)

  • Multiplas BD no grupo

  • Exige Windows Clustering (e exige Windows Server Enterprise Edition)

  • Backup funcionaemtodo o lado (mesmonas Replicas)

HADR / AlwaysOn


Hadr always on1

Always On capabilities delivered with PowerPivot for Excel by enabling customers to visualize and interact with the modeled data in a fun and meaningful way using highly interactive visualizations, animations and smart querying and present and share insights with others in the organization through rich storyboard presentation capabilities.(Muitomais de que um simples Mirroring):

  • Faster Failover

  • Multi-Database Failover

  • Multiple Secondaries

  • Active Secondaries

  • Fast Client Connection Redirection

  • Flexible Failover Policies

  • Windows Server Core

  • Multisite Clustering

  • Configura-se porinstânciaoupela BD

  • DMV’s vãoservirpara o controlo de todo o processo

HADR / Always On


Hadr always on2

Segundo a capabilities delivered with PowerPivot for Excel by enabling customers to visualize and interact with the modeled data in a fun and meaningful way using highly interactive visualizations, animations and smart querying and present and share insights with others in the organization through rich storyboard presentation capabilities.informação de «Books Online» a funcionalidade HADR/ON estámuitolimitada / nãofuncionalem CTP1:

  • Máximum 8 User Databases

  • Single AsynchronousSecondaryReplica

  • Pre-requisites e restrições:

  • Read/WriteDatabase

  • FullRecoveryMode

  • No Mirroring

  • Multi-UserDatabase

    Para mais informação:

    http://msdn.microsoft.com/en-us/library/ff878487(SQL.110).aspx

HADR / Always On


Ainda mais

  • Columnstore capabilities delivered with PowerPivot for Excel by enabling customers to visualize and interact with the modeled data in a fun and meaningful way using highly interactive visualizations, animations and smart querying and present and share insights with others in the organization through rich storyboard presentation capabilities.Indexes (read only de momento

  • FileTable(gestão de ficheirosatravés do SQL)

  • Extended Events recebe um pouco de GUI

  • Segurança: SHA2_256, SHA2_512

  • Snippets para SSMS e VS

  • Database level users semlogins

  • FullTextSearch: proximidade do termo – NEAR

  • FullTextSearch: Office 2007 properties

Ainda Mais:


Recursos

« capabilities delivered with PowerPivot for Excel by enabling customers to visualize and interact with the modeled data in a fun and meaningful way using highly interactive visualizations, animations and smart querying and present and share insights with others in the organization through rich storyboard presentation capabilities.Denali» release notes:

http://social.technet.microsoft.com/wiki/contents/articles/sql-server-code-named-quot-denali-quot-ctp1-release-notes.aspx

http://msdn.microsoft.com/en-us/library/ff878487(SQL.110).aspx

Aaron Betrand:

http://sqlblog.com/blogs/aaron_bertrand/

Recursos:


Perguntas sem respostas
Perguntas capabilities delivered with PowerPivot for Excel by enabling customers to visualize and interact with the modeled data in a fun and meaningful way using highly interactive visualizations, animations and smart querying and present and share insights with others in the organization through rich storyboard presentation capabilities.sem respostas


Obrigado. capabilities delivered with PowerPivot for Excel by enabling customers to visualize and interact with the modeled data in a fun and meaningful way using highly interactive visualizations, animations and smart querying and present and share insights with others in the organization through rich storyboard presentation capabilities.


ad