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:
Getting Started with Windows Azure SQL Database
Carsten Siemens
Note SQL Azure Portal has been replaced by Windows Azure Platform Management Portal . A new version of this article, which introduces SQL Azure using the Windows Azure Management Portal is available, see Getting Started with SQL Azure using the Windows Azure Platform Management Portal...
on
28 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:
Troubleshooting FIM 2010 R2 Service Installation Failure and Roll-Back
Richard Mueller
##DRAFT IN PROGRESS### Table of Contents Case Reference Infrastructure Symptoms Error message Eventviewer FIM Service files & config files Firewall ports Background info Other tests Solution See also Case FIM 2010 R2 service installation fails when connecting to remote SQL 2008 R2 SP2...
on
13 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:
Troubleshooting FIM: The SQL Server Service Broker must be enabled on the Forefront Identity Manager Service database
Richard Mueller
Table of Contents Symptoms / Error Solution Killing active connections References: Symptoms / Error Microsoft.ResourceManagement.Service: System.InvalidOperationException: The SQL Server Service Broker must be enabled on the Forefront Identity Manager Service database. Refer to the documentation...
on
14 Apr 2013
Wiki Page:
BizTalk: SQL Send Port: How to Pass Unbounded Nodes to the SQL Stored Procedure
Richard Mueller
If we need to pass and process ONE row to the SQL store proc, it is pretty easy. Map the XML message (inside BizTalk) elements to the service SQL request schema elements. This schema is created by SQL Port wizard when we point it to the SQL store proc. More interesting problem is to pass several...
on
11 Apr 2013
Wiki Page:
Troubleshooting FIM: Synchronization Service setup is having trouble contacting SQL server
Peter Geelen - MSFT
Table of Contents Case description Error Message Troubleshooting Steps Verify SQL Connectivity Verify SQL security SQL Server configuration FIM Server side Configuration Setup SQL Client Background info Downloads See also Case description When you install the FIM Synchronization service (FIM R2...
on
28 Mar 2013
Wiki Page:
Windows Azure SQL Database Billing Numbers Directly From Transact-SQL
Richard Mueller
Windows Azure SQL Database exposes two Dynamic Managed Views called sys.database_usage and sys.bandwidth_usage that show you the activity for your account. These can queried to understand your account usage from a billing perspective. Table of Contents Disclaimer Database Usage Summary Disclaimer...
on
7 Mar 2013
Wiki Page:
General Replication Topics
Yagmoth555
This page was created to help to provide links to key ReplTalk http://blogs.msdn.com/b/repltalk/ MSDN blog postings by the Microsoft SQL Server Replication Support Team. General Replication Topics posted on ReplTalk: First Steps in Troubleshooting Replication Replication Metadata Collection...
on
24 Feb 2013
Wiki Page:
Workarounds for Predicates that Don't Get Pushed Down to Columnstore Scan (Including OR)
Yagmoth555
Sometimes predicates (filters) don't get pushed down to columnstore scans. Common reasons for this include use of predicates on string columns, and use of OR across different columns. A separate topic here discusses how to work around the inability to push down string filters. If you use OR...
on
23 Feb 2013
Wiki Page:
ConfigMgr (SCCM) – Very Handy Report for Software Update (Patching) Client Health
Yagmoth555
Thought of sharing one of the very HANDY report which we use for client health with respect to patching or software update. All the credit goes to my colleague Neetu. This report will provide you below details SQL Statement SELECT v_R_System.Name0, v_R_System.Active0, v_R_System...
on
22 Feb 2013
Wiki Page:
Force Use or Non-Use of a Columnstore Index
Yagmoth555
Sometimes, the query optimizer may make a mistake and choose to use a B-tree or heap instead of the columnstore, when in fact the query would have run faster with the columnstore. You can force the optimizer to use the columnstore with an index hint. Suppose there is a table Fact that has a columnstore...
on
19 Feb 2013
Wiki Page:
How to Convert a SQL Server Text Column data to VarBinary/Image Column data and back.
Yagmoth555
This article is just to show some code to help convert data between SQL server text column and varbinary/image column. This also can help you using the SQL Server READTEXT, WRITETEXT and UPDATETEXT statements. These kind of statements use pointer that are not trivial to SQL Server programmers. ...
on
19 Feb 2013
Wiki Page:
SQL Server Books
Kumar Vivek
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...
on
10 Dec 2012
Wiki Page:
Permutations of a table column in SQL
Pieter Geerkens
The permutation of a set comprise all the unique orderings of the elements of the set. Naive implementation of a permutation generator in SQL require performing a N-ary self-join of the set, where N is the number of elemnts in the set. This is inconvenient, as the code must be reworked whenever the...
on
3 Dec 2012
Wiki Page:
Space Allocation: ‘Extents’ in SQL Server
dplotnikov - mvp
A database needs space for storing Tables and Indexes and in the SQL server the space is managed in Units called ‘Extents’. Now what is an ‘Extent’? An Extent is a 64 Kb Contiguous Space or in better terms it is made up of Eight Logically Contiguous Pages. Types...
on
29 Aug 2012
Wiki Page:
Cómo diseñar, crear y mantener una base de datos de servidor de SQL (es-ES)
Monica Rivera
Destinatarios : Los desarrolladores de aplicaciones que no están familiarizados con el diseño, implementación o mantenimiento de bases de datos, y que se necesitan crear una base de datos para usar con sus aplicaciones . Los enlaces son enlaces externos y ofrecen información...
on
28 Aug 2012
Wiki Page:
Understanding Processor (% Processor Time) and Process (%Processor Time)
FZB
We come up so many times with the counters Processor (%Processor Time) and Process (%Processor Time) and when we see that there is high CPU in some server we want to analyze where this high CPU is coming from, which process is taking up our CPU. We may come up with a scenario where we observe a high...
on
13 Aug 2012
Wiki Page:
ConfigMgr (SCCM) – SQL Server Reporting Service (SSRS) – Error Timeout Expired
Anoop C Nair
Recently, I was working on SQL server Reporting Service issue and I thought of documenting it so that (may be ) it will helpful to someone !!! Latest Updated Link - http://anoopcnair.com/2011/07/20/configmgr-sccm-sql-server-reporting-service-timeout-expired/ See, the error message An error...
on
26 Jun 2012
Wiki Page:
Use PowerPivot to Access Hive on Windows Azure (video)
Ed Price - MSFT
This screencast shows you how to use Excel PowerPivot to access data from Hive on Windows Azure. It includes opening the ODBC Server port for a Hadoop cluster on Windows Azure, downloading and installing the Hive ODBC Driver, and creating an ODBC DSN pointing to a Hive data warehouse running on Windows...
on
13 Jun 2012
Wiki Page:
MBAM Setup Fails with SQL Error: Error obtaining a certificate protected by the master key
Fernando Lugão Veltem
<repost from Windows Server Core Team Blog here > Hello, my name is Manoj Sehgal. I am a Senior Support Escalation Engineer in the Windows group and today’s blog will cover “MBAM Setup fails with SQL TDE Error message” Microsoft BitLocker Administration and Monitoring...
on
11 Jun 2012
Wiki Page:
Service Manager (SCSM) 2012 : "The SQL Server is not running version SQL 2008 or SQL 2008 R2"
Ed Price - MSFT
Today when I started to install the SCSM Web portal I’ve got the following error: After some search on internet I found this good article which solved my issue. After running the command line on the Management Server… The problem has gone away.
on
5 Jun 2012
Wiki Page:
How to Solve SQL MA Schema Update Error: "Attribute '<deleted attribute>' could not be located in the schema"
Fernando Lugão Veltem
Table of Contents Symptom Error message Details: Detailed error message Solution Related articles Symptom When you delete a column from a SQL table or view, ILM throws an error when updating the schema of the SQL MA. Error message Error message: "Attribute '<deleted Attribute>'...
on
28 May 2012
Wiki Page:
Dynamic archiving of Tables and Data: MS SQL
Fernando Lugão Veltem
It is a common and business requirement to backup the data. The archiving is part of back ups and most of the applications and system will be following some procedure to archive the data. Since most of the application is having some kind of mechanism to archive data like SQL stored procedures, statements...
on
21 May 2012
Wiki Page:
RD Connection Broker HA – SQL Permissions
Freek Berson
In a previous Wiki article, we ran through the process of setting up HA for the RD Connection Broker in Windows Server 2012. http://social.technet.microsoft.com/wiki/contents/articles/10390.deploying-rd-connection-broker-high-availibilty-in-windows-server-2012.aspx In this wiki we'll dive...
on
14 May 2012
Page 2 of 3 (59 items)
1
2
3
Can't find it? Write it!
Post an Article