TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Microsoft Edge
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Skype for Business
See all products »
Resources
Channel 9 Video
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Windows Update
Trials
Windows Server 2016
System Center 2016
Windows 10 Enterprise
SQL Server 2016
See all trials »
Related Sites
Microsoft Download Center
Microsoft Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Expert-led, virtual classes
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
Microsoft Official Courses On-Demand
Certifications
Certification overview
Special offers
MCSE Cloud Platform and Infrastructure
MCSE: Mobility
MCSE: Data Management and Analytics
MCSE Productivity
Other resources
Microsoft Events
Exam Replay
Born To Learn blog
Find technical communities in your area
Azure training
Official Practice Tests
Support options
For business
For developers
For IT professionals
For technical support
Support offerings
More support
Microsoft Premier Online
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
Home
Library
Wiki
Learn
Gallery
Downloads
Support
Forums
Blogs
Resources For IT Professionals
United States (English)
Россия (Pусский)
中国(简体中文)
Brasil (Português)
Skip to locale bar
Get this Tag RSS feed
Translate this page
Powered by
Microsoft® Translator
Popular Tags
Active Directory
AD
AD DS
adfs
ASP.NET
azure
BizTalk
BizTalk Server
BizTalk Server 2010
C#
Candidate for deletion
certification
cloud
core docs
de-DE
EAA
Ed Price
Ed's Stub Pages
en-US
ESA
es-ES
Excel
Exchange
Exchange 2010
fa-IR
Fernando Lugao Veltem
FIM
FIM 2010
FIM Resources
FIM-HELP
forefront
forums
fr-FR
Gokan Ozcifci
has code
has comment
has comments
has image
has Images
has Other Languages
has See Also
Has Table
Has TOC
Horizon_Net
How To
Hyper-V
id-ID
IIS
Italian Wiki Articles
it-IT
ja-JP
Jordano Mazzoni
Link Collection
Luciano Lima
Luigi Bruno
Lync Server 2010
MIISILMFIM MACAULAY
Multi Language Wiki Articles
needs work
operations manager
Pirated Content
Portal
Português Brasil
PowerShell
pt-BR
security
SharePoint
SharePoint 2010
SharePoint 2013
SharePoint Pirate
Small Basic
solucionando problemas
SQL Server
SQL Server 2012
stub
System Center
System Center 2012
TechNet Guru
TechNet Wiki
TechNet Wiki Featured Article
tonyso
Translated into Japanese
troubleshooting
tr-TR
vídeo
Video
Virtualization
VMM
Wiki
Windows
Windows 7
Windows 8
Windows Azure
Windows Server
Windows Server 2003
Windows Server 2008
Windows Server 2008 R2
Windows Server 2012
yottun8
اکتیو دایرکتوری
Browse by Tags
>
TechNet Articles
>
All Tags
>
Database
Tagged Content List
Wiki Page:
Exchange Server 2010 New Mailbox Database (tr-TR)
Richard Mueller
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...
on
18 Sep 2013
Wiki Page:
Rebuild and Re-index Database Gradually
Richard Mueller
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...
on
17 Sep 2013
Wiki Page:
How to Move the SCVMM 2008 R2 Database to Another Server
Danny van Dam
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...
on
13 Sep 2013
Wiki Page:
Aspects of Backup for BizTalk Databases
Maheshkumar S Tiwari
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...
on
10 Sep 2013
Wiki Page:
Thinking in Sets
Naomi N
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...
on
4 Sep 2013
Wiki Page:
Structured Query Language
Naomi N
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...
on
4 Sep 2013
Wiki Page:
BizTalk Administrator's Checklist Compiled by Microsoft BizTalk Support
Maheshkumar S Tiwari
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...
on
23 Aug 2013
Wiki Page:
BizTalk Server 2010: Database BizTalkDTADb
Maheshkumar S Tiwari
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...
on
23 Aug 2013
Wiki Page:
Exam 98-364 - Database Fundamentals
Ed Price - MSFT
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...
on
7 Aug 2013
Wiki Page:
Windows Azure SQL Database Connection Management
Kumar Vivek
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...
on
30 Jul 2013
Wiki Page:
Basics of SQL Server Pages
Naomi N
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...
on
26 Jul 2013
Wiki Page:
Come progettare, creare e mantenere un database di SQL Server (it-IT)
Ed Price - MSFT
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...
on
9 Jul 2013
Wiki Page:
How to Design, Create, and Maintain a SQL Server Database
Ed Price - MSFT
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...
on
9 Jul 2013
Wiki Page:
SQL Server データベースをデザイン、作成、維持するには (ja-JP)
Ed Price - MSFT
このトピックは how to ( 方法 ) です。 可能な限り明瞭で簡潔な状態を維持してください。基礎的なメカニズムや関連技術に深く言及したり、推測に基づいた議論をすることも避けてください。 対象者 : データベースのデザインや実装、維持について慣れておらず、アプリケーションで利用するデータベースを作成する必要があるアプリケーション開発者 以下のリンクは 外部へのリンク であり、SQL Server データベースのデザインや作成、維持する方法を理解するための情報とガイドを提供します。同様に、データベースデザインする際に起こりがちなミスの回避についての情報も提供します...
on
9 Jul 2013
Wiki Page:
SQL Server 2012 Failover Cluster Kurulumu ve Yapılandırması (tr-TR)
Naomi N
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…...
on
7 Jul 2013
Wiki Page:
PowerPivot: Import Data from a SQL Server Database (Video)
Richard Mueller
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...
on
11 Jun 2013
Wiki Page:
Exchange Server 2010 Move Database (tr-TR)
Mehmet PARLAKYİĞİT
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...
on
21 May 2013
Wiki Page:
Exchange Server 2010 User Move Mailbox Database (tr-TR)
Fernando Lugão Veltem
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...
on
16 May 2013
Wiki Page:
AD FS 2.0: Migrate Your AD FS Configuration Database to SQL Server
Jorge de Almeida Pinto [MVP-DS]
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...
on
15 May 2013
Wiki Page:
Getting Started with Windows Azure SQL Database Development
Richard Mueller
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 ...
on
9 May 2013
Wiki Page:
Best Practices for Running SQL Server in Windows Azure Virtual Machine (Retired)
Carsten Siemens
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...
on
29 Apr 2013
Wiki Page:
Connect to Windows Azure SQL Database from Ruby Applications
Larry Franks
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...
on
12 Mar 2013
Wiki Page:
Implementation of Translate() Function in MS SQL Server
Yagmoth555
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...
on
23 Feb 2013
Wiki Page:
Pushing the Performance Monitor Data into a Database
Richard Mueller
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...
on
22 Feb 2013
Wiki Page:
จะใช้เซลล์ใดเป็นเซลล์แรก (First Cell for Excel Data) (th-TH)
Yagmoth555
แทนที่จะใช้เซลล์ A1 เป็นเซลล์แรก ขอแนะนำให้เว้น Row 1 และ Column A ให้ว่างไว้ โดยให้ใช้เซลล์ B2 เป็นเซลล์แรก ลองดูภาพตารางต่อไปนี้ ตามภาพตารางด้านขวา ประโยชน์ของการใช้เซลล์ B2 เป็นเซลล์แรก จะช่วยทำให้เห็นได้ชัดเจนว่าขอบด้านบนและขอบด้านซ้ายของตารางถูกตีเส้นกรอบไว้แล้ว และยังดูไม่อึดอัด สามารถปรับความส...
on
19 Feb 2013
Page 1 of 2 (49 items)
1
2
Can't find it? Write it!
Post an Article