Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  Database
Tagged Content List

  • Wiki Page: Exchange Server 2010 New Mailbox Database (tr-TR)

    Merhaba arkadaşlar bir önceki makalemde sizlere Exchange Server 2010 Move Database konu başlığını işlemiştik bu makalemde ise sizlere Exchange Server 2010 New Mailbox Database yani yeni mailbox nasıl oluşturulur. Bu konu üzerine değineceğiz. Peki neden yeni database oluşturma ihtiyacı duyarız...
    on18 Sep 2013

  • Wiki Page: Rebuild and Re-index Database Gradually

    I had a problem in our live environment - the database was fragmented - badly. A solution had to be written to defragment the database, whilst providing the least downtime - and the script below was born. I create a function that will defrag the top X (in this case 20) indexes and created a SQL...
    on17 Sep 2013

  • Wiki Page: How to Move the SCVMM 2008 R2 Database to Another Server

    Note: This article is based on VMM 2008 and might not apply to VMM 2012 (R2) You might find yourself in the position of needing to move the SCVMM database from one server to another for various reasons. For instance, this situation can occur when moving from local to remote SQL or from a stand...
    on13 Sep 2013

  • Wiki Page: Aspects of Backup for BizTalk Databases

    Table of Contents Introduction Why and how to make Log Shipping Backups How to add/remove custom databases to the backup Clean up backup artifacts See Also Introduction When it comes to making backups of BizTalk, there is only one way that is supported by Microsoft; you need to make Log Shipping...
    on10 Sep 2013

  • Wiki Page: Thinking in Sets

    Thinking in Sets is a great book by Joe Celko . This book tells us about concepts, how we need to think when we are working with databases. Columns are not fields, rows are not records and tables are not files, hence SQL is declarative, not procedural. There is no sequential access or ordering...
    on4 Sep 2013

  • Wiki Page: Structured Query Language

    By a “set” we mean any collection M into a whole of definite, distinct objects m (which are called the “elements” of M) of our perception or of our thought. —G eorge C antor , in “G eorg C antor ” by J oseph W. D auben (P rinceton U niversity P ress , 1990) Standard SQL is based...
    on4 Sep 2013

  • Wiki Page: BizTalk Administrator's Checklist Compiled by Microsoft BizTalk Support

    Table of Contents Introduction Daily Action Items Weekly Action Items Other Action Items Additional Online Resources See Also Introduction This checklist can be used as a guide to maintain a healthy BizTalk environment. It includes proactive tasks that should be done on a weekly basis and also...
    on23 Aug 2013

  • Wiki Page: BizTalk Server 2010: Database BizTalkDTADb

    Table of Contents Tables Tables to be aware of SQL Queries Find Orphaned messages in the tracking database Query Transactions Query Instances Query transaction by host name Get message count for all applications from In Out Events References See Also This article will contain information about the...
    on23 Aug 2013

  • Wiki Page: Exam 98-364 - Database Fundamentals

    Table of Contents Overview Skills Measured Community Related Forum Posts Other Languages Português Overview Language(s): English Audience(s): Academic Technology: Microsoft SQL Server 2008 Type: Proctored Exam Audience Profile Candidates...
    on7 Aug 2013

  • Wiki Page: Windows Azure SQL Database Connection Management

    IMPORTANT The information in this article is not up-to-date, and the article will be retired soon. For latest information about throttling, worker thread governance, and resource limits in Windows Azure SQL Database, see the Resource Management in Windows Azure SQL Database topic on MSDN...
    on30 Jul 2013

  • Wiki Page: Basics of SQL Server Pages

    This article will be helpful to the SQL beginners like me, who may be confused with SQL pages, how SQL Server page is storing the data and how pages are aligned in Master data file. I am writing my view here and if I am wrong in this concept, kindly please correct me. Page split happens only conceptually...
    on26 Jul 2013

  • Wiki Page: Come progettare, creare e mantenere un database di SQL Server (it-IT)

    Si rivolge a : sviluppatori di applicazioni che non hanno familiarità con la progettazione, l'implementazione o la manutenzione di database, che hanno bisogno di creare un database per usarlo con le loro applicazioni . I link seguenti sono link esterni e forniscono informazioni e guide per capire...
    on9 Jul 2013

  • Wiki Page: How to Design, Create, and Maintain a SQL Server Database

    Intended audience : Application developers who are not familiar with designing, implementing or maintaining databases, yet need to create a database for use with their applications . The links below are external links and provide information and guidance on understanding how to design, create and...
    on9 Jul 2013

  • Wiki Page: SQL Server データベースをデザイン、作成、維持するには (ja-JP)

    このトピックは how to ( 方法 ) です。 可能な限り明瞭で簡潔な状態を維持してください。基礎的なメカニズムや関連技術に深く言及したり、推測に基づいた議論をすることも避けてください。 対象者 : データベースのデザインや実装、維持について慣れておらず、アプリケーションで利用するデータベースを作成する必要があるアプリケーション開発者 以下のリンクは 外部へのリンク であり、SQL Server データベースのデザインや作成、維持する方法を理解するための情報とガイドを提供します。同様に、データベースデザインする際に起こりがちなミスの回避についての情報も提供します...
    on9 Jul 2013

  • Wiki Page: SQL Server 2012 Failover Cluster Kurulumu ve Yapılandırması (tr-TR)

    Merhabalar, Bu makalemde sizlere işletmelerimiz için yüksek değer ve önem taşıyan Database Sunucularımızın Failover Cluster ile yüksek erişilebilirlik sağlanılmasını anlatacağım. Tabi bu işlemleri Microsoft’ un en son İşletim sistemi Server 2012 ve SQL Server 2012 üzerinde gerçekleştireceğiz…...
    on7 Jul 2013

  • Wiki Page: PowerPivot: Import Data from a SQL Server Database (Video)

    This video is third in a series about using PowerPivot to import data into an Excel workbook. In this video, Michele shows you how to import data from a SQL Server relational database. Tutorial video by Michele Hart , Microsoft SQL Server Technical Writer. View all the PowerPivot videos...
    on11 Jun 2013

  • Wiki Page: Exchange Server 2010 Move Database (tr-TR)

    Merhaba bir exchange makalesi ile tekrar karşınızdayım. Bu makalemde sizlere Move database yani mailbox ların tutulduğu database leri nasıl başka bir partition üzerine taşıyabileceğimizden bahsedeceğim. Exchange server ilk kurulduğunda mailbox databaseleri default olarak C:/ dizini içerisinde gelir...
    on21 May 2013

  • Wiki Page: Exchange Server 2010 User Move Mailbox Database (tr-TR)

    Merhaba arkadaşlar bir önce ki makalemde sizlere Exchange Server 2010 New Mailbox Database yani yeni mailbox database oluşturmaktan bahsetmiştim. Peki niçin yeni mailbox database oluşturmamız gerekiyor. Düşünün ki çalıştığımız kurumda yöneticilerimiz ve önemli pozisyonda olan kişiler var. Bu kişilere...
    on16 May 2013

  • Wiki Page: AD FS 2.0: Migrate Your AD FS Configuration Database to SQL Server

    The AD FS configuration database stores all the configuration data that represents a single instance of AD FS 2.0 (also known as the Federation Service). You can store this configuration data in either a Microsoft SQL Server® database or using the Windows Internal Database. The Windows Internal Database...
    on15 May 2013

  • Wiki Page: Getting Started with Windows Azure SQL Database Development

    Microsoft Windows Azure offers several choices for data storage. These include Windows Azure Storage and Windows Azure SQL Database . You may choose to use one or both in your particular project. Windows Azure Storage currently contains three types of storage structures: tables, queues or blobs ...
    on9 May 2013

  • Wiki Page: Best Practices for Running SQL Server in Windows Azure Virtual Machine (Retired)

    This wiki has been retired. For the latest information on running SQL Server on Windows Azure Virtual machine, see this link: http://msdn.microsoft.com/en-us/library/windowsazure/jj823132.aspx We'll use this wiki to communicate best practices you should consider when provisioning and deploying...
    on29 Apr 2013

  • Wiki Page: Connect to Windows Azure SQL Database from Ruby Applications

    Click here to change the language ( ja-JP ). This article discusses the methods of connecting to Windows Azure SQL Database from the Ruby language. While this article discusses several gems that can be used to connect to SQL Database, it is by no means a comprehensive listing of all gems that provide...
    on12 Mar 2013

  • Wiki Page: Implementation of Translate() Function in MS SQL Server

    Translate Function: In Oracle/PLSQL, the translate function replaces a sequence of characters in a string with another set of characters. However, it replaces a single character at a time. For example, it will replace the 1st character in the string_to_replace with the 1st character in the replacement_string...
    on23 Feb 2013

  • Wiki Page: Pushing the Performance Monitor Data into a Database

    Pushing the Performance counters of the Database As we know that the Monitoring the Performance counters is an important task of SQL DBA, and even these performance counters are an integral part of the troubleshooting of the performance issues. And there is interesting way to push the performance...
    on22 Feb 2013

  • Wiki Page: จะใช้เซลล์ใดเป็นเซลล์แรก (First Cell for Excel Data) (th-TH)

    แทนที่จะใช้เซลล์ A1 เป็นเซลล์แรก ขอแนะนำให้เว้น Row 1 และ Column A ให้ว่างไว้ โดยให้ใช้เซลล์ B2 เป็นเซลล์แรก ลองดูภาพตารางต่อไปนี้ ตามภาพตารางด้านขวา ประโยชน์ของการใช้เซลล์ B2 เป็นเซลล์แรก จะช่วยทำให้เห็นได้ชัดเจนว่าขอบด้านบนและขอบด้านซ้ายของตารางถูกตีเส้นกรอบไว้แล้ว และยังดูไม่อึดอัด สามารถปรับความส...
    on19 Feb 2013
Page 1 of 2 (49 items) 12
Can't find it? Write it!

Post an Article