Browse by Tags

Tagged Content List
  • Wiki Page: How to : Create User Defined Server Roles in SQL Server 2012 (id-ID)

    Salah satu fitur baru di SQL Server 2012 adalah adanya User Defined Server Roles. dengan adanya fitur ini kita bisa menambahkan Server Roles baru selain yang ada secara default di SQL Server seperti gambar yang ada dibawah ini Dengan adanya fitur ini seorang super admin dapat mendelegasikan tugasnya...
  • Wiki Page: SQL Server Database Engine Permission Posters

    Posters are available that list all the granular permissions of the SQL Server Database Engine and Windows Azure SQL Database. Select the pdf images below. You can display these on your computer, expanding or shrinking them to focus on specific areas. Use Control+F to search for a specific permission...
  • Wiki Page: Presentation Transcript: Introducing SQL Server StreamInsight 2012 Improvements (en-US)

    SQL11UPD04-TSCRIPT-07 This wiki is a transcript of a previously recorded video. Related content assets: Presentation: Introducing SQL Server StreamInsight 2012 Improvements ( SQL11UPD04-DECK-04 ) Video: Introducing SQL Server StreamInsight 2012 Improvements ( SQL11UPD04-REC-07 ) ...
  • Wiki Page: Tuning Spatial Point Data Queries in SQL Server 2012

    Tuning Spatial Point Data Queries in SQL Server 2012 Written by: Ed Katibah, Milan Stojic, Michael Rys, Nicholas Dritsas Technical reviewers: Chuck Heinzelman Introduction Spatial Point Data queries require particular tuning efforts to enhance performance and improve overall application...
  • Wiki Page: Nuevas Funciones Integradas(Built-in Functions) en SQL Server 2012

    SQL Server incorpora nuevas funciones integradas útiles para diferentes tipos de operaciones, que podrá ayudar en más de una oportunidad a los desarrolladores de Bases de Datos al momento de crear sus consultas sobre bases de datos. He aquí algunas de ellas: FUNCIÓN...
  • Wiki Page: SQL Server 2012 での空間ポイントデータクエリのチューニング (ja-JP)

    Table of Contents 紹介 主キーのクラスター化インデックス最適化 空間インデックスの基本 空間インデックスの最適化 geography データ型を使用する場合に、球体地球モデルを利用することの考慮 パフォーマンステスト 結論 他の言語 SQL Server 2012 での空間ポイントデータクエリのチューニング 執筆者: Ed Katibah, Milan Stojic, Michael Rys, Nicholas Dritsas テクニカルレビュアー: Chuck Heinzelman 紹介 空間ポイントデータクエリでは、パフォーマンスを向上し...
  • Wiki Page: Como especificar el fill factor en un índice

    La opción de fill factor permite el afinamiento del rendimiento y almacenamiento de los índices, cuando un índice es creado o reconstruido, el fill factor determina el porcentaje de espacio a nivel de la hoja de cada página que será llenada con datos; reservando...
  • Wiki Page: Solucionando Problemas: Instalação e Configuração do Master Data Services no SQL Server 2012 (pt-BR)

    Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/2390.troubleshoot-installation-and-configuration-issues-master-data-services-in-sql-server-2012.aspx Quando Master Data Services (MDS) do SQL Server 2012 é instalado e configurado...
  • Wiki Page: Изменения в SQL Server 2012, связанные с диспетчером памяти

    По материалам статьи Juergen Thomas: Memory Manager surface area changes in SQL Server 2012 в блоге SQLOS Team Автор: G Bowerman Перевод: Александр Гладченко Технический редактор: Ирина Наумова Множество изменений было внесено в компоненты диспетчера памяти SQLOS новой версии SQL Server 2012...
  • Wiki Page: Install SharePoint 2010 with MS SQL Server 2012 on Windows Server 2012

    When I start my journey of install Team Foundation Server 2012 (TFS) on Windows Server 2012 with MS SQL 2012 , I knew that we can't install SharePoint Foundation 2010 on Windows Server 2012 , this by design and sure the Team Foundation Server (TFS) standard configuration will not be able to do that...
  • Wiki Page: SQL Server 2012 リリース ノート (ja-JP)

    言語を変更するにはここをクリック 定期的にこのページを開いて、詳しく確認するようにしてください。行った変更は検討されたうえで、すぐに適用、調整、または元に戻されます。これは Wiki であるため、コミュニティ メンバーによって、これらのリリース ノートへの追加または改良が行われている場合があります。元のリリース ノートを読むには、 ここ をクリックしてください。 このリリース ノートでは、 SQL Server 2012 ( ダウンロードするにはここをクリック ) のインストールやトラブルシューティングを行う前に知っておく必要がある、既知の問題について説明しています。このリリース ノートは...
  • Wiki Page: How to Build SQL Server 2012 AlwaysOn Hyper-V Virtual Machines for Demos (EMU build)

    The set of VMs described in this article can be used to demonstrate the new high-availability features of SQL Server 2012, namely AlwaysOn Availability Groups and Failover Clustering. The purpose of the article is to document the requirments and high-level steps that are necessary in order to ...
  • Wiki Page: SQL Server 2012: SSMS Snippets

    Table of Contents Introdução Como visualizar os snippets Conclusão Introdução Os Snippets permitem que voce pegue aquela parte de codigo que frequentemente voce utiliza e deixa a mesma automatizada com apenas alguns cliques todo o script gigantesco aparece...
  • Wiki Page: Demo Transcript: Simplified Result Set Paging with SQL Server 2012 (en-US)

    SQL11UPD03-TSCRIPT-02 This wiki is a transcript of a previously recorded video. Related content assets: Demo: Simplified Result Set Paging with SQL Server 2012 ( SQL11UPD03-DEMO-01 ) Video: Simplified Result Set Paging with SQL Server 2012 ( SQL11UPD03-REC-02 ) Simplified...
  • Wiki Page: SQL Server 2012: sys.dm_db_database_page_allocations

    Table of Contents Introdução Conhecendo a nova DMF Listagem 01. Criação da base de dados e tabelas Listagem 02. Consultando a DMF Informações úteis que podemos retirar Listagem 02. Extraindo informações da DMF Listagem 03. Inserção...
  • Wiki Page: User-Defined Audit Event

    Table of Contents Introdução Criação da auditoria Criação da auditoria personalizada Executando a auditoria personalizada Caso prático para a auditoria personalizada Conclusão Introdução Atualmente possuimos no SQL Server...
  • Wiki Page: Presentation Transcript: Exploring SQL Server 2012 Analysis Services Tabular Modeling (en-UE)

    SQL11UPD06-TSCRIPT-03 This wiki is a transcript of a previously recorded video. Related content assets: Presentation: Exploring SQL Server 2012 Analysis Services Tabular Modeling ( SQL11UPD06-DECK-02 ) Video: Exploring SQL Server 2012 Analysis Services Tabular Modeling ( SQL11UPD06-REC...
  • Wiki Page: Guia de Sobrevivência: SQL Server 2012 (pt-BR)

    NOTA IMPORTANTE: Não será mais realizada atualização nesta página. Para conteúdo atualizado visite o Portal do TechNet Wiki em PT-BR em http://aka.ms/wiki-ptbr Este " Guia de Sobrevivência " tem como objetivo reunir todos os materiais relacionados...
  • Wiki Page: SQL Server - Creating Complex Test Databases

    The following entries comprise a series of blog posts highlighting some tips and tricks to create complex databases for testing purposes. Here is a snippet from the intro: "As a very brief intro, I have worked as a tester in SQL Server for the past 10+ years on many different features. Along...
  • Wiki Page: How to Build a Combined set of KIWI and EMU VMs (SQL Server 2012 demos)

    This article describes how to modify the KIWI VM build (for SQL Server 2012 demos) so that it uses a separate, central domain controller VM shared with other VMs. The only VM from the EMU set of VMs that is modified is EMU-DC (KIWI needs to be added to the domain). Let's call this modified version...
  • Wiki Page: SQL Server Analysis Services (SSAS)

    Table of Contents Overview Analysis Services Wiki Articles Dimensional Modeling 101 Security Performance Administration and Monitoring Tools Query and DDL Languages Data Mining See Also Other Languages Brazilian Portuguese (pt-BR) German (de-DE) Overview SQL Server Analysis Services (SSAS) is...
  • Wiki Page: Kibocsátási megjegyzések az SQL Server 2012 rendszerhez készült Microsoft PowerPivot beépülő modulhoz (hu-HU)

    Ezt a lapot körültekintően és alaposan figyelik. Az itt végrehajtott bármely módosítását kiértékelik, majd gyorsan elfogadják, finomítják vagy elutasítják. Ez egy wikilap, ezért a jelen...
  • Wiki Page: Using a Drop-and-Rebuild Approach with Columnstores for a Nightly Load Scenario

    If you have a nightly load scenario, which is the case for most data warehouses and data marts, then there is no need to worry about the restriction that you can't update a table that has a columnstore index on it. All you need to do is drop the columnstore index, do your updates, then rebuild the...
  • Wiki Page: PowerPivot Data Refresh Error: "Credentials were not found for the current user within the target application 'PowerPivotUnattended'. Please set the credentials for the current user."

    Applies to: PowerPivot data refresh on SharePoint, SQL Server 2008 R2 and SQL Server "Denali". There is a known error in PowerPivot data refresh that occurs when using the PowerPivot unattended data refresh account in a farm where the PowerPivot service application is running under an...
  • Wiki Page: SQL Server 2012 Books Online Localization

    We are pleased to announce the new localization release of “SQL Server 2012 Books Online”, which is now localized into (Turkish and Polish). Your valuable feedback was taken into consideration for localization quality improvement. Please look for the documentation at the following locations...
Page 8 of 11 (263 items) «678910»
Can't find it? Write it!