Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  SQL Server
Tagged Content List

  • Wiki Page: RIGHT, LEFT, SUBSTRING and CHARINDEX Functions

    Hello, In this article I'm going to attempt to explain the functionality and uses of the LEFT, RIGHT, SUBSTRING and CHARINDEX functions in SQL. Many times I have seen somebody asking how to format a string; and (although I think this should be done on the application layer) more often than...
    on18 Jun 2013

  • Wiki Page: SQL Server Samples Readme

    The SQL Server 2012 samples provide a variety of databases and files that you can use to learn about new and existing features. This article is the consolidated Readme for each sample in the SQL Server 2012 release. It provides prerequisite information, installation instructions, and links to the...
    on18 Jun 2013

  • Wiki Page: How SQL Server determines type of the constant

    There was an interesting question asked recently in Transact-SQL forum "Basic doubt in Round function"
    on16 Jun 2013

  • Wiki Page: Using Custom Code in SSRS Reports for Advanced String Operations

    Overview SQL Services Reporting Services is a very powerful tool and with each new release, it grows in functionality. However many users find that the expression builder functions do not quite do what they need. Fortunately, Microsoft has provided a powerful means of extending the capabilities...
    on16 Jun 2013

  • Wiki Page: Cómo usar ASP.NET con SQL Server (es-ES)

    Destinatarios : Los desarrolladores web que no están familiarizados con SQL Server, que aún desean aprender a utilizar una base de datos SQL Server con ASP. NET . Los siguientes enlaces son enlaces externos y proporcionan información y orientación sobre cómo crear aplicaciones dinámicas controladas...
    on14 Jun 2013

  • Wiki Page: Como Utilizar ASP.NET no SQL Server (pt-BR)

    Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/934.how-to-use-asp-net-with-sql-server-en-us.aspx Público-alvon : desenvolvedores da Web que não estão familiarizados com o SQL Server, mas queiram aprender a usar um banco de dados SQL Server...
    on14 Jun 2013

  • Wiki Page: How to: ASP.NET und SQL Server (de-DE)

    Zielgruppe : Web-Entwickler, die noch keine Erfahrung mit SQL Server haben, aber eine SQL Server Datenbank in ihrer ASP.NET Webseite nutzen wollen. Die Links in diesem Artikel sind externe Links und bieten Informationen und Anleitungen wie man dynamische, datengesteuert Applikationen mit SQL Server...
    on14 Jun 2013

  • Wiki Page: Come utilizzare ASP.NET con SQL Server (it-IT)

    Destinatari : sviluppatori Web developers che non hanno familiarità con SQL Server, ma vogliono imparare come utilizzare un database SQL Server con i loro siti web ASP.NET . I link riportati di seguito sono esterni a TechNet Wiki e forniscono informazioni e guide sulla creazione di pagine web dinamiche...
    on14 Jun 2013

  • Wiki Page: ASP.NET で SQL Server を利用するには (ja-JP)

    対象者 : SQL Server を利用することに馴染みがなく、SQL Server データベースを ASP.NET Web サイトに利用する方法を学習したい Web 開発者 ページ下の 外部リンク では、SQL Server と ASP.NET テクノロジーを利用するデータドリブンのアプリケーションについての情報やガイダンスを提供します。この情報では、既に ASP.NET についての知識があると仮定します。もし、ASP.NETについてまだ馴染みがなく、追加のプログラミングリソースや情報を探しているのであれば、 http://www.asp.net へ行くと良いでしょう。日本語であれば...
    on14 Jun 2013

  • Wiki Page: E-Book Gallery for Microsoft Technologies

    Download content for ASP.NET, Office, SQL Server, Windows Azure, SharePoint Server and other Microsoft technologies in e-book formats. Reference, guide, and step-by-step information are all available. All the e-books are free. New books will be posted as they become available. To view...
    on14 Jun 2013

  • Wiki Page: Compare Analysis Services and PowerPivot

    NOTE : This page was translated from this Spanish version by St. Joseph Lopez . This article is available in other languages: Spanish More and more customers are getting to know about PowerPivot and seek more guidance on when to use it with SQL Server...
    on13 Jun 2013

  • Wiki Page: PowerPivot: Data Analysis Expressions (DAX) Language

    Table of Contents Types of DAX Functions Overview of DAX Where to Use Formulas Creating Formulas by Using the Formula Bar Tips for Using AutoComplete Basic DAX Syntax Using Multiple Functions in a Formula DAX Data Types Formulas and the Relational Model Introduction to Context Updating the Results of...
    on13 Jun 2013

  • Wiki Page: Change TEMPDB to Temporary Drive on Azure SQL IaaS

    NOTE: This article has been retired . For the most-up-to-date information for SQL Server in Windows Azure VMs, see the documentation on MSDN. For the latest recommendations related to tempdb and performance of SQL Server in Windows Azure VMs, see white paper : Performance Guidance for SQL Server...
    on13 Jun 2013

  • Wiki Page: Versionsanmerkungen zu Microsoft SQL Server 2008 SP2 (de-DE)

    Klicken Sie hier, um die Sprache zu ändern . Table of Contents Inhalt 1.0 Neues in Service Pack 2 2.0 Vor der Installation von Service Pack 2 2.3 Alle Funktionen einer Instanz von SQL Server müssen sich auf der gleichen Versionsebene befinden, bevor ein kumulatives Update angewendet werden...
    on13 Jun 2013

  • Wiki Page: White Paper Gallery for SQL Server

    Download white papers for SQL Server in DOC, PDF, and other formats. All the content is free. This page aggregates Microsoft content from multiple sources – feel free to fill in the gaps and add links to other content. To view Microsoft e-book content that is available in EPUB and MOBI...
    on12 Jun 2013

  • Wiki Page: SQL Server 開発入門 (ja-JP)

    Table of Contents SQL Server Express SQL Server SQL Server のエディションと機能 インストール Web Platform Installer データベース管理 SQL 開発 関連項目 他の言語 対象者 : Relational Database Management Systems (RDBMS) になじみが無いが、ファイルシステムで提供される以上のものを必要とするアプリケーション開発者。 もしアプリケーションが直接ファイルを読み書きするよりもっと複雑なストレージソリューションを必要とするならば、いずれかのエディションの SQL...
    on12 Jun 2013

  • Wiki Page: PHP で SQL Server を利用するには (ja-JP)

    対象者 : SQL Server になじみが無く、PHP を利用する Web サイトで SQL Server を利用する方法を、これから学習したい Web 開発者 以下にあるリンクは外部へのリンクであり、Web サイト開発に PHP や SQL Server、IIS を利用する動的な Web ページを作成する上でのガイダンスと情報を提供します。この情報では、あなたが既に PHP での開発を知っているものとします。もしPHPになじみが無く、PHP の情報や追加プログラミングリソースを探しているのであれば、 http://www.php.net/ (英語) へ行ってみてください。 ...
    on12 Jun 2013

  • Wiki Page: Windows Azure SQL Database Firewall (en-US)

    To help protect your data, the Windows Azure SQL Database firewall prevents all access to your SQL Database server until you specify which computers have permission. The firewall grants access based on the originating IP address of each request. The SQL Database firewall can be managed via Windows...
    on11 Jun 2013

  • Wiki Page: PowerPivot: Import Data from a SQL Server Database (Video)

    This video is third in a series about using PowerPivot to import data into an Excel workbook. In this video, Michele shows you how to import data from a SQL Server relational database. Tutorial video by Michele Hart , Microsoft SQL Server Technical Writer. View all the PowerPivot videos...
    on11 Jun 2013

  • Wiki Page: SQL Server Result Set In An HTML Email

    The Problem Picture the situation: you have a collection of data that you've been working on to summarise. You've finally found a way of displaying the data in an effective format, but you've overlooked one essential task: how are you going to relay this information back to the audience...
    on11 Jun 2013

  • Wiki Page: SET ANSI_PADDING Setting and Its Importance

    Recently I got an interesting escalation to solve for the client. Our VFP based application was getting the following SQL Server error: "Violation of PRIMARY KEY constraint 'rep_crit_operator_report'. Cannot insert duplicate key in object 'dbo.rep_crit' The duplicate key value...
    on10 Jun 2013

  • Wiki Page: Exam 70-451 - PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

    Table of Contents Overview Audience Profile Credit Toward Certification Skills Being Measured Designing a Database Strategy (13 percent) Designing Database Tables (16 percent) Designing Programming Objects (17 percent) Designing a Transaction and Concurrency Strategy (14 percent) Designing an XML Strategy...
    on10 Jun 2013

  • Wiki Page: Exam 70-450 - PRO: Designing, Optimizing, and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

    Table of Contents Overview Skills Measured Preparation Materials Community Related Forum Posts Overview Language(s): English, French, German, Japanese, Spanish, Chinese (Simplified) Audience(s): IT Professionals Technology: Microsoft SQL Server 2008 ...
    on10 Jun 2013

  • Wiki Page: DAX Resource Center

    Table of Contents You can contribute! Introduction to DAX Microsoft DAX Documentation Most Valuable Resources Samples DAX formulas in measures DAX functions Credits Welcome to the DAX Resource Center Wiki - your one stop shop for all things DAX This Wiki includes articles, whitepapers, videos...
    on10 Jun 2013

  • Wiki Page: BizTalk Health Check

    Table of Contents Health checking Patching: Update COM+ and MSDTC. General Network DTCPing of all the servers Transfer 100MB data Pathping TCP/IP port Exhaustion DBNETLIB Exceptions TCP/IP Server general Time synchronization BIOS Version Update the Certificate RevocationListUpdates BizTalk in general...
    on10 Jun 2013
Page 1 of 28 (687 items) 12345»
Can't find it? Write it!

Post an Article