Browse by Tags

Tagged Content List
  • Wiki Page: Demo Transcript: Configuring SQL Server 2012 AlwaysOn Availability Groups (Part 1)

    SQL11UPD01-TSCRIPT-02 This wiki is a transcript of a previously recorded video. Related content assets: Demo: Configuring SQL Server 2012 AlwaysOn Availability Groups ( SQL11UPD01-DEMO-01 ) Video: Configuring SQL Server 2012 AlwaysOn Availability Groups (Part 1) ( SQL11UPD01-REC-02 ) ...
  • Wiki Page: SQL Server 2012 Upgrade and Application Compatibility

    Table of Contents Introduction Identify Upgrade Targets Identify and Fix Upgrade Blockers Perform Initial Health Check Run Upgrade Advisor Perform AppCompat Testing Choose an Upgrade Strategy In-Place Upgrade Side-By-Side Upgrade Upgrade By Migration Perform Your Upgrade Other Languages Brazilian Portuguese...
  • Wiki Page: Demo Transcript: SQL Server 2012 Distributed Replay

    SQL11UPD02-TSCRIPT-10 This wiki is a transcript of a previously recorded video. Related content assets: Demo: SQL Server 2012 Distributed Replay ( SQL11UPD02-DEMO-05 ) Video: SQL Server 2012 Distributed Replay ( SQL11UPD02-REC-10 ) SQL Server 2012 Distributed Replay Hey folks...
  • Wiki Page: Demo Transcript: Configuring SQL Server 2012 AlwaysOn Availability Groups (Part 2)

    SQL11UPD01-TSCRIPT-09 This wiki is a transcript of a previously recorded video. Related content assets: Demo: Configuring SQL Server 2012 AlwaysOn Availability Groups ( SQL11UPD01-DEMO-01 ) Video: Configuring SQL Server 2012 AlwaysOn Availability Groups (Part 1) ( SQL11UPD01-REC-02 ) ...
  • Wiki Page: SQL Server 2012 Developer Training Kit Content

    Important: Submit your ideas and feedback at http://bit.ly/sql2012kitfeedback ! The SQL Server 2012 Developer Training Kit is a collection of content that can be used to familiarize a developer or IT professional with key improvements in SQL Server 2012. Download and install the SQL Server 2012...
  • Wiki Page: Potential Side-Effects of Improved Spatial Precision in SQL Server 2012 and the SQL Azure September (Q2) 2011 Service Release

    SQL Server Technical Note Writer: Ed Katibah (Microsoft) Technical Reviewers: Michael Kallay (Microsoft), Milan Stojic (Microsoft) and Michael Rys (Microsoft) Published: November 2011 Applies to: SQL Server Code-Named “Denali”, SQL Server 2012, SQL Azure Introduction In...
  • Wiki Page: Filtering, Highlighting, and Slicers in Project Crescent

    The content in this topic was for Project Crescent, the code name in Microsoft SQL Server Code-Named “Denali”, Community Technology Preview 3 (CTP 3). Power View is the new name for Project Crescent in Microsoft SQL Server 2012 Release Candidate 0 (RC0). Important: Most Power View documentation...
  • Wiki Page: Presentation Transcript: Exploring SQL Server 2012 Power View

    SQL11UPD06-TSCRIPT-07 This wiki is a transcript of a previously recorded video. Related content assets: Presentation: Exploring SQL Server 2012 Power View ( SQL11UPD06-DECK-04 ) Video: Exploring SQL Server 2012 Power View ( SQL11UPD06-REC-07 ) Exploring SQL Server 2012 Power...
  • Wiki Page: Microsoft SQL Server 2012 Release Notes Language Options

    Select a language for Microsoft SQL Server 20012 Release Notes: English Chinese - Simplified (zh-CN) Chinese - Traditional (zh-TW) French (fr-FR) German (de-DE) Italian (it-IT) Japanese (ja-JP) Korean (ko-KR) Portuguese (pt-BR) Russian (ru-RU) Spanish (es-ES)
  • Wiki Page: Microsoft PowerPivot for SQL Server 2012 Release Notes

    Click here to change the language. The Microsoft PowerPivot for SQL Server 2012 Release Notes have moved to MSDN . © 2012 Microsoft Corporation. All rights reserved.
  • Wiki Page: Notas de la versión de Microsoft PowerPivot para SQL Server 2012 (es-ES)

    Esta página se supervisa muy estrechamente. Los cambios que realice se evaluarán y se aceptarán, refinarán o revertirán rápidamente. Dado que se trata de un sitio wiki, las adiciones o mejoras de estas notas de la versión podrían haber sido efectuadas...
  • Wiki Page: SQL Server and Updates Builds Numbers

    Table of Contents SQL Server Release Dates SQL Server 2000 SQL Server 2000 Service Pack 1 SQL Server 2005 SQL Server 2005 Service Pack 1 SQL Server 2005 Service Pack 2 SQL Server 2005 Service Pack 3 SQL Server 2005 Service Pack 4 SQL Server 2008 SQL Server 2008 Service Pack 1 SQL Server 2008 Service...
  • Wiki Page: How to Configure Windows Failover Cluster in Windows Azure for AlwaysOn Availability Groups

    At the moment, you can run AlwaysOn Availability Groups without availability group listeners in Windows Azure VMs. This is because Windows Azure networking does not support assigning multiple IP addresses to the same VM or allow the IP addresses to fail over from one VM to another, which is required...
  • Wiki Page: Microsoft Product Roadmap for Year 2012

    Microsoft Product Roadmap for Year 2012 looks awesome. Every year Microsoft comes out with new releases of its existing products. Many a times it also releases new products in the market. IT Professionals, Microsoft Partners and Customers wait eagerly for every new release of the software’s they...
  • Wiki Page: Many-to-Many Mapping in Master Data Services

    In SQL Server 2012 RC0, Master Data Services (MDS) introduced functionality to help you navigate between related entities. Many-to-many relationships are described briefly at the end of this post. ( http://social.technet.microsoft.com/wiki/contents/articles/mapping-multiple-systems-with-master-data...
  • Wiki Page: Upgrade Assistant Tool for SQL Server 2012

    Download Upgrade Assistant for SQL Server The UAFS code is available for download here: http://www.scalabilityexperts.com/tools/downloads.html 1.0 Introduction to the Upgrade Assistant for SQL Server With every new release of SQL Server, Microsoft invests a lot of time and effort...
  • Wiki Page: Configure SQL Server 2012 on a Server Core Installation

    Contents Configure and Manage Server Core on Windows Server . PAGEREF _Toc318463622 \h 1 08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300310038003400360033003600320032000000 Install SQL Server Updates . PAGEREF _Toc318463623 \h 2 08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300310038003400360033003600320033000000...
  • Wiki Page: How to Restore a Database Backup Using .bak file in MS SQL Server 2012

    .bak files are database backups we can restore the Database backup using SQL Server Management Studio. A. Open SQL Server Management Studio in Object Explorer Right Click on ‘Databases’ Node and select ‘Restore Database’ B. ’Restore Database’ Dialog will be displayed on the General page...
  • Wiki Page: SQL Server Database Engine Configuration: Best Practices For Sharepoint 2010/2013 On SQL Server

    Overview The following is a collection of checks that can be run against an instance of SQL Server 2005/2008/2008R2/2012 that is currently or will be used as a dedicated instance for sharepoint databases. The checks come from standard best practices and also from the Sharepoint best practices...
  • Wiki Page: End of Month Function (id-ID)

    Gak sengaja lagi buka-buka BOLnya SQL Server 2012 kemudian menemukan sebuah function baru dalam pengelolaan tanggal yaitu function End of Month atau ditulis dengan EOMonth() Biasanya kalo kita mau mencari tanggal berapa sebuah bulan berakhir, kita dapat menggunakan cara berikut : DECLARE...
  • Wiki Page: TSQL Script to delete DQS projects leftover from SSIS DQS Cleansing component

    When you use an SSIS package to run Data Quality Services Cleansing activities via the DQS Cleansing Component, each run produces a Data Quality Project. The resulting Data Quality project is useful for auditing the cleansed data produced from the SSIS package, and also to export the data if a copy...
  • Wiki Page: Installing Microsoft SQL Server 2012 Change Data Capture for Oracle by Attunity

    New in SQL Server 2012 is a Change Data Capture for Oracle by Attunity which allows you to continually copy data from Oracle to SQL Server. << Back to Microsoft SQL Server 2012 Change Data Capture for Oracle by Attunity Topics This feature is helpful in two common business scenarios...
  • Wiki Page: SQL Server Books

    Introduction This article is designed to keep a track of all SQL Server related books on the marked. Feel free to update the list with the desired books and links to get them. SQL Server 2012 Introducing Microsoft SQL Server 2012 Microsoft SQL Server 2012 High-Performance T-SQL Using...
  • Wiki Page: PAGING windows in T-SQL (id-ID)

    di SQL Server 2012 ada metode baru untuk mendapatkan beberapa baris data melalui klausa Select sehingga didapatkan jumlah baris data sesuai yang diinginkan sesuai dengan nilai row offset dan row value yang sudah ditentukan sehingga jumlah record yang di presentasikan di client dapat diatur dengan mekanisme...
  • Wiki Page: SQL Server 2012 New Feature – Contained database (id-ID)

    Seperti yang kita ketahui bahwa database SQL Server tidak se-Portable yang kita bayangkan. Ini adalah kesulitan yang dialami para DBA jika berkeinginan memindahkan sebuah database dari sebuah server ke server lain. Memang seperti kita ketahui juga bahwa ada fasiltas detach and attach database, atau...
Page 7 of 11 (263 items) «56789»
Can't find it? Write it!