Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  SQL
Tagged Content List

  • 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...
    on18 Jun 2013

  • Wiki Page: Einführung in die Entwicklung mit SQL Server (de-DE)

    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) Zielgruppe : Anwendungsentwickler ohne Erfahrung...
    on13 Jun 2013

  • 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...
    on12 Jun 2013

  • Wiki Page: BizTalk Server 2010: SQL Agent Jobs

    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...
    on12 Jun 2013

  • Wiki Page: BizTalk Databases: Survival Guide

    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...
    on12 Jun 2013

  • Wiki Page: Aspects of Backup for Your BizTalk Databases

    Lately a number of useable articles have been written about making backups of BizTalk databases and other related databases. Here's an overview of these articles: For BizTalk Microsoft supports only Log Shipping backups. Why? Make Marked backups instead of regular Full Backups. This article...
    on10 Jun 2013

  • Wiki Page: BizTalk Server: Administrator Queries and Scripts

    Table of Contents SQL Scripts PowerShell Scripts Other scripts Other languages See Also 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 where you can find and...
    on9 Jun 2013

  • 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 were 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 in...
    on6 Jun 2013

  • 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...
    on28 May 2013

  • 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...
    on15 May 2013

  • 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...
    on13 May 2013

  • 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 ...
    on9 May 2013

  • 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...
    on9 May 2013

  • 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...
    on14 Apr 2013

  • 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...
    on11 Apr 2013

  • Wiki Page: Change Data Capture Known has CDC

    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...
    on10 Apr 2013

  • Wiki Page: Understanding Claim Rule Language in AD FS 2.0

    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...
    on4 Apr 2013

  • 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...
    on28 Mar 2013

  • 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...
    on7 Mar 2013

  • Wiki Page: Installing and Configuring RD Connection Broker High Availability in Windows Server 2012

    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...
    on6 Mar 2013

  • Wiki Page: Enabling the Failover Clustering Feature on Windows 2008R2 Server Core

    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...
    on1 Mar 2013

  • 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...
    on24 Feb 2013

  • 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...
    on23 Feb 2013

  • 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...
    on22 Feb 2013

  • 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...
    on19 Feb 2013
Page 1 of 3 (53 items) 123
Can't find it? Write it!

Post an Article