Browse by Tags

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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • Wiki Page: SQL Server データベースをデザイン、作成、維持するには (ja-JP)

    このトピックは how to ( 方法 ) です。 可能な限り明瞭で簡潔な状態を維持してください。基礎的なメカニズムや関連技術に深く言及したり、推測に基づいた議論をすることも避けてください。 対象者 : データベースのデザインや実装、維持について慣れておらず、アプリケーションで利用するデータベースを作成する必要があるアプリケーション開発者 以下のリンクは 外部へのリンク であり、SQL Server データベースのデザインや作成、維持する方法を理解するための情報とガイドを提供します。同様に、データベースデザインする際に起こりがちなミスの回避についての情報も提供します...
  • 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…...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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 ...
  • 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...
  • 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...
  • 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...
  • 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...
  • Wiki Page: จะใช้เซลล์ใดเป็นเซลล์แรก (First Cell for Excel Data) (th-TH)

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