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
>
SQL
Tagged Content List
Wiki Page:
SharePoint 2010: Configure SQL Management Studio Express to Talk to Default Sharepoint Instance
Richard Mueller
Download Download and install Microsoft SQL Server Management Studio Express Download and install Microsoft SQL Server 2005 Express Edition Toolkit Configure Configure the built-in SQL instance for remote management by SQL Server Management Studio Express Open the "SQL server...
on
18 Sep 2013
Wiki Page:
MBAM Hardware and Recovery DB requires TDE on c
Richard Mueller
Customers have been experiencing some pain with installing the Hardware and Recovery DB. The Transparent Data Encryption feature of SQL Server 2008 must be enabled for the Hardware and Recovery DB to install successfully. The documentation to date is missing this requirement. While we're fixing...
on
17 Sep 2013
Wiki Page:
Using Bulk Insert to import inconsistent data format (using pure T-SQL)
pituach
Table of Contents Introduction The problem Our Case Study The solution: STEP 1: Identify the import's file format Finding the problematic columns and the consistent columns format STEP 2: insert the data into temporary table Step 3: parsing the data into the final table Summary Comments Resources...
on
15 Sep 2013
Wiki Page:
Enabling the Failover Clustering Feature on Windows Server 2008 R2 Server Core
Yagmoth555
One of the biggest challenges when using Windows Server Core apart from the obvious ones introduced by the reduced graphical interface is to overcome those challenges displayed by its nuances. Tasks that you can perform easily from the command line on a Non-Core edition of Windows might not be possible...
on
15 Sep 2013
Wiki Page:
Shrink SQL Database During Restore
Naomi N
Table of Contents Case Study: First option: using compressed folder & symbolic link Step 1: Create a compressed folder Step 2: Backup your database Step 3: Create symbolic link to the compressed folder Step 4: Restore your database using the symbolic link. Step 5: Shrink the Database Step 6: Detach...
on
15 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:
SQL (structure query language)
Maheshkumar S Tiwari
SQL was developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early 1970s. This version, initially called SEQUEL ( S tructured E nglish Que ry L anguage), was designed to manipulate and retrieve data stored in IBM's original quasi-relational database management system, System...
on
5 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:
SSRS Report
Maheshkumar S Tiwari
Table of Contents Overview Power View Other Reporting Options See Also Overview SQL Server Reporting Services provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend...
on
3 Sep 2013
Wiki Page:
Recommendations for Installing, Sizing, Deploying, and Maintaining a BizTalk Server Solution
Maheshkumar S Tiwari
Table of Contents Introduction Who Should Read This Guide Document Structure Initial Planning / determining which edition of BizTalk Server is appropriate for meeting your goals Determine the business goals of the BizTalk Server solution Create an architecture diagram Create a summary hardware diagram...
on
23 Aug 2013
Wiki Page:
BizTalk Server 2010: SQL Agent Jobs
Maheshkumar S Tiwari
Table of Contents BizTalk Server SQL Agent Jobs Backup BizTalk Server References CleanupBTFExpiredEntriesJob_BizTalkMgmtDb MessageBox_DeadProcesses_Cleanup_BizTalkMsgBoxDb MessageBox_Message_Cleanup_BizTalkMsgBoxDb MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb MessageBox_Parts_Cleanup_BizTalkMsgBoxDb...
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:
Understanding Claim Rule Language in AD FS 2.0 & Higher
Joji Oshima
Table of Contents Introduction Understanding Claim Sets General Syntax of the Claim Rule Language Condition Statements Issuance Statements Multiple Conditions Combining Values Aggregate Functions Using Regular Expressions Querying Attribute Stores SQL Attribute Stores LDAP Attribute Stores Links to Additional...
on
21 Aug 2013
Wiki Page:
Change Data Capture Known has CDC
Manjunath C Bhat
Change Data Capture popularly known as CDC is a new feature in SQL Server 2008 that records insert, update and delete activity in SQL Server tables. A good example of how this feature can be used is in performing periodic updates to a data warehouse. CDC records (or captures) DML activity on designated...
on
21 Aug 2013
Wiki Page:
How to Manually Delete Old/Empty WSUS computer Group from Database
Ahmed Nabil Mahmoud [MVP]
Recently i was trying to delete/Remove one of the old computer groups under WSUS Console - Computers - All Computers. This Group was an old group with no members/Clients or any pending approvals any more. I tried removing it from the GUI by Right licking the object and Delete but the server hanged...
on
16 Aug 2013
Wiki Page:
BizTalk Server: Administrator Queries and Scripts
Steef-Jan Wiggers
Table of Contents Introduction SQL Scripts PowerShell Scripts Other scripts Other languages See Also Introduction This site is dedicated to gather information for all the resources related to scripting for BizTalk administrators. It should include information with a reference to the exact location...
on
15 Aug 2013
Wiki Page:
BizTalk Databases: Survival Guide
Steef-Jan Wiggers
Table of Contents Introduction Resources General Upgrading Database Jobs Disaster Recovery Tracking High Availability Other languages See Also Introduction Microsoft BizTalk Server databases and the health of the databases are very important for a sustainable BizTalk Server messaging environment...
on
10 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:
Inside Windows Azure SQL Database
Steef-Jan Wiggers
With Windows Azure SQL Database, you can create SQL Server databases in the cloud. Using SQL Database, you can provision and deploy your relational databases and your database solutions to the cloud, without the startup cost, administrative overhead, and physical resource management required by on-premises...
on
7 Aug 2013
Wiki Page:
Installing and Configuring RD Connection Broker High Availability in Windows Server 2012
Gokan Ozcifci
This is a landing page for articles on all aspects of deploying High Availability for the RD Connection Broker in Windows Server 2012, including but not limited to: Deploying RD Connection Broker High Availability in Windows Server 2012 RD Connection Broker HA and the RDP properties on the client...
on
30 Jul 2013
Wiki Page:
როგორ გამოვიყენო ASP.NET - ი SQL Server - თან (ka-GE)
Ed Price - MSFT
მიზნობრივი აუდიტორია : ვებ პროგრამისტები, რომელთაც ჯერ არ იციან, თუ როგორ იმუშაონ SQL Server - თან და აქვთ სურვილი იმისა, რომ შეისწავლონ, თუ როგორ დაუკავშირონ თავიანთი ASP.NET აპლიკაცია SQL Server - ის მონაცემთა ბაზებს . ქვემოთ მოყვანილია გარე ბმულები , რომლებიც შეიძლება გამოყენებულ იქნას სახელმძღვანელოდ...
on
9 Jul 2013
Wiki Page:
შესავალი SQL Server პროგრამირებაში (ka-GE)
Ed Price - MSFT
Table of Contents SQL Server Express SQL Server SQL Server Editions and Features ინსტალაცია SQL Server 2008 SQL Server 2008 R2 Web Platform Installer მონაცემთა ბაზების ადრმინისტრირება SQL პროგრამირება სხვა ენებზე მიზნობრივი აუდიტორია : პროგრამისტები, რომლებიც ჯერ კარგად არ იცნობენ რელაციურ მონაცემთა...
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:
Einführung in die Entwicklung mit SQL Server (de-DE)
Tomoaki Yoshizawa
Table of Contents SQL Server Express SQL Server SQL Server Editions and Features Installation Web Platform Installer Datenbank-Administration SQL Entwicklung Siehe Auch Andere Sprachen Italian (it-IT) English (en-US) Japanese (ja-JP) Portuguese (pt-BR) Spanish (es_ES) Georgian (ka-GE) Zielgruppe...
on
28 Jun 2013
Page 1 of 3 (59 items)
1
2
3
Can't find it? Write it!
Post an Article