Resources For IT Professionals
Get this Tag RSS feed
Tag Cloud
Wiki  > All Tags > SQL Server
Tagged Content List

  • Wiki Page: SQL Server 2016: Querying (Part 2/2)

    Table of Contents Introduction Objectives Before You Begin Video Query Lesson 11. Get Product Name and Product ID for Orders Data Lesson 12. Use Join to get the inventory and the related orders. Lesson 13. Use Join to get data from order details and Order Summary Introduction This is part 2 on...
    on16 Jan 2019

  • Wiki Page: Power BI: DAX: Text Functions

    Data Analysis Expressions (DAX) includes a set of text functions that is based on the library of string functions in Excel, but it has been modified to work with tables and columns. Read more about the following text functions: Table of Contents BLANK CONCATENATE EXACT FIND FIXED FORMAT Predefined...
    on8 Jan 2019

  • Wiki Page: SQL Server: Generate database User Script with access rights

    From time to time, you might get the requirment of DB restore from PROD TO UAT or DEV environemnt. All server having different domain & different user ids in databse. Here is a script to generate a database User Script with access rights in one go. SET NOCOUNT ON GO CREATE...
    on8 Jan 2019

  • Wiki Page: SQL Server In-Memory OLTP: Understanding and Dealing with Range Indexes on Memory-Optimized Tables

    Table of Contents Introduction The internal structure of range indexes How delta pages are linked to leaf pages Overhead due to delta pages Header and data of range indexes Header Data Impact of data modification on memory-optimized indexes Insert Test: Update Test: Conclusion See Also Introduction...
    on4 Jan 2019

  • Wiki Page: SCCM için SQL Server Kurulumu Nasıl Yapılır (Part 3) (TR-TR)

    Önkoşulları yükledikten sonra bir sonraki adımımız SQL Server’ın kurulumu olacaktır. Kullanıcıların birçoğu, SQL sunucusunun nereye yükleneceği konusunda pek bilgi sahibi değillerdir. Bu sebeple kurulum yapacak kişiler SQL Server’ı, SCCM ‘nin kurulu olduğu sunucuya mı? yoksa farklı bir sunucuya mı...
    on4 Jan 2019

  • Wiki Page: SQL Server Integration Services Portal

    This article lists known TechNet Wiki articles about SQL Server Integration Services (SSIS). Table of Contents See Also Additional Resources Presentation Transcript: Introducing SQL Server 2012 Integration Services Improvements What's New in SSIS 2008 and 2008 R2 SSIS Expression...
    on28 Dec 2018

  • Wiki Page: SQL Server User Groups

    This page contains resources for and a listing of offline Microsoft user groups focused on SQL Server Table of Contents SQL Server User Group Listing SQL Server Resources on the TechNet Wiki Contribute to the TechNet Wiki Getting Help and Engaging the TechNet Wiki Community See Also Others Languages...
    on28 Dec 2018

  • Wiki Page: Microsoft BizTalk: Health Check by SQL Query

    Issue: How to check Microsoft BizTalk suspended messages by SQL Query. Reason: By some reason developer or any other managerial person have not access to login to BizTalk server. Solution: A SQL query to get suspended messages (Resumable, non-Resumable) with other helpful details...
    on24 Dec 2018

  • Wiki Page: SQL Server 2014 Troubleshooting: Unable to install on Windows 7 machine and 2008 R2 Server

    Error: Error 1935.An error occurred during the installation of assembly 'policy.8.0.Microsoft.VC80.MFC,type="win32-policy",version="8.0.50727.42",publicKeyToken="1fc8b3b9a1e18e3b",processorArchitecture="x86"'. Please refer to Help and Support for...
    on23 Dec 2018

  • Wiki Page: BizTalk: Considerations for Database Backup

    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 When things go wrong Other languages See Also Introduction When it comes to making backups of BizTalk, there is only one way that is supported by...
    on23 Dec 2018

  • Wiki Page: FIM/ILM: How to move the backend SQL Server Synchronization Service Database

    Table of Contents Applies To Overview Goal Steps to move the backend database SEE ALSO Applies To Microsoft Identity Integration Server 2003 Microsoft Identity Integration Feature Pack Microsoft Identity Lifecycle Manager 2007 Feature Pack 1 Microsoft Forefront Identity Manager 2010...
    on23 Dec 2018

  • Wiki Page: T-SQL: How to Find Rows with Bad Characters

    One of the commonly asked questions in Transact SQL Forum on MSDN is how to filter rows containing bad characters. Also, often times these bad characters are not known, say, in one of the recent posts the question was to filter all the rows where characters were greater than ASCII 127. The first...
    on7 Dec 2018

  • Wiki Page: SQL Server, Restore the (sa) password

    First or all we must stop the SQL Server service. Start the SQL Server service in ( Single-User Admin Mode ) mode, to do it, launch the command line as an administrator, then type this command ( SQLServr.exe -m ou SQLServr-f ) : SQLServr.exe -m : Single User Admin Mode. SQLServr.exe -f : Minimal...
    on6 Dec 2018
Page 21 of 123 (3,075 items) «1920212223»