Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

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

    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...
    on18 Sep 2013

  • Wiki Page: MBAM Hardware and Recovery DB requires TDE on c

    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...
    on17 Sep 2013

  • Wiki Page: Using Bulk Insert to import inconsistent data format (using pure T-SQL)

    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...
    on15 Sep 2013

  • Wiki Page: Enabling the Failover Clustering Feature on Windows Server 2008 R2 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...
    on15 Sep 2013

  • Wiki Page: Shrink SQL Database During Restore

    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...
    on15 Sep 2013

  • Wiki Page: Aspects of Backup for BizTalk Databases

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

  • Wiki Page: SQL (structure query language)

    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...
    on5 Sep 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 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...
    on4 Sep 2013

  • 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...
    on4 Sep 2013

  • Wiki Page: SSRS Report

    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...
    on3 Sep 2013

  • Wiki Page: Recommendations for Installing, Sizing, Deploying, and Maintaining a BizTalk Server Solution

    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...
    on23 Aug 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...
    on23 Aug 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...
    on23 Aug 2013

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

    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...
    on21 Aug 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...
    on21 Aug 2013

  • Wiki Page: How to Manually Delete Old/Empty WSUS computer Group from Database

    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...
    on16 Aug 2013

  • Wiki Page: BizTalk Server: Administrator Queries and Scripts

    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...
    on15 Aug 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...
    on10 Aug 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...
    on7 Aug 2013

  • Wiki Page: Inside Windows Azure SQL Database

    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...
    on7 Aug 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...
    on30 Jul 2013

  • Wiki Page: როგორ გამოვიყენო ASP.NET - ი SQL Server - თან (ka-GE)

    მიზნობრივი აუდიტორია : ვებ პროგრამისტები, რომელთაც ჯერ არ იციან, თუ როგორ იმუშაონ SQL Server - თან და აქვთ სურვილი იმისა, რომ შეისწავლონ, თუ როგორ დაუკავშირონ თავიანთი ASP.NET აპლიკაცია SQL Server - ის მონაცემთა ბაზებს . ქვემოთ მოყვანილია გარე ბმულები , რომლებიც შეიძლება გამოყენებულ იქნას სახელმძღვანელოდ...
    on9 Jul 2013

  • Wiki Page: შესავალი SQL Server პროგრამირებაში (ka-GE)

    Table of Contents SQL Server Express SQL Server SQL Server Editions and Features ინსტალაცია SQL Server 2008 SQL Server 2008 R2 Web Platform Installer მონაცემთა ბაზების ადრმინისტრირება SQL პროგრამირება სხვა ენებზე მიზნობრივი აუდიტორია : პროგრამისტები, რომლებიც ჯერ კარგად არ იცნობენ რელაციურ მონაცემთა...
    on9 Jul 2013

  • Wiki Page: SQL Server 2012 Failover Cluster Kurulumu ve Yapılandırması (tr-TR)

    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…...
    on7 Jul 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) Spanish (es_ES) Georgian (ka-GE) Zielgruppe...
    on28 Jun 2013
Page 1 of 3 (59 items) 123
Can't find it? Write it!

Post an Article