Browse by Tags

Tagged Content List
  • Wiki Page: Getting Started with Windows Azure SQL Database

    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...
  • 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: Troubleshooting FIM 2010 R2 Service Installation Failure and Roll-Back

    ##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...
  • 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: Troubleshooting FIM: The SQL Server Service Broker must be enabled on the Forefront Identity Manager Service database

    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...
  • Wiki Page: BizTalk: SQL Send Port: How to Pass Unbounded Nodes to the SQL Stored Procedure

    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...
  • Wiki Page: Troubleshooting FIM: Synchronization Service setup is having trouble contacting SQL server

    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...
  • Wiki Page: Windows Azure SQL Database Billing Numbers Directly From Transact-SQL

    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...
  • Wiki Page: General Replication Topics

    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...
  • Wiki Page: Workarounds for Predicates that Don't Get Pushed Down to Columnstore Scan (Including OR)

    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...
  • Wiki Page: ConfigMgr (SCCM) – Very Handy Report for Software Update (Patching) Client Health

    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...
  • Wiki Page: Force Use or Non-Use of a Columnstore Index

    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...
  • Wiki Page: How to Convert a SQL Server Text Column data to VarBinary/Image Column data and back.

    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. ...
  • Wiki Page: SQL Server Books

    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...
  • Wiki Page: Permutations of a table column in SQL

    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...
  • Wiki Page: Space Allocation: ‘Extents’ in SQL Server

    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...
  • Wiki Page: Cómo diseñar, crear y mantener una base de datos de servidor de SQL (es-ES)

    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...
  • Wiki Page: Understanding Processor (% Processor Time) and Process (%Processor Time)

    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...
  • Wiki Page: ConfigMgr (SCCM) – SQL Server Reporting Service (SSRS) – Error Timeout Expired

    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...
  • Wiki Page: Use PowerPivot to Access Hive on Windows Azure (video)

    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...
  • Wiki Page: MBAM Setup Fails with SQL Error: Error obtaining a certificate protected by the master key

    <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...
  • Wiki Page: Service Manager (SCSM) 2012 : "The SQL Server is not running version SQL 2008 or SQL 2008 R2"

    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.
  • Wiki Page: How to Solve SQL MA Schema Update Error: "Attribute '<deleted attribute>' could not be located in the schema"

    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>'...
  • Wiki Page: Dynamic archiving of Tables and Data: MS SQL

    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...
  • Wiki Page: RD Connection Broker HA – SQL Permissions

    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...
Page 2 of 3 (59 items) 123
Can't find it? Write it!