TechNet Wiki

Tagged Content List

Wiki Page: BizTalk Server: Administrator Queries and Scripts (nb-NO)

RajeeshMenoth

Table of Contents SQL Skript PowerShell Skript Andre script Denne siden er dedikert til å samle informasjon for alle ressurser knyttet til skripting for BizTalk administratorer . Den bør inneholde opplysninger med en referanse til den nøyaktige plasseringen der du kan finne og...

on10 Jun 2017
Wiki Page: Invoke a SQL Stored Procedure on the BizTalk WCF Send Port without Needing an Orchestration

Ken Cenerelli

Table of Contents Introduction Steps Create database table and stored procedure Create BizTalk Application See Also Introduction There was a scenario in BizTalk where we needed to insert data into a database by executing an existing stored procedure that accepts XML as input parameter. The...

on9 Jun 2017
Wiki Page: Working with Transparent Data Encryption in SQL Server

Richard Mueller

Table of Contents Introduction Encryption Internals Create Master Key Create the Certificate Create Encryption Key Set Transparent Data Encryption Summary Introduction Transparent Data Encryption(TDE) is an encryption mechanism of encrypting the data at rest. The data is encrypted before writing...

on2 Jun 2017
Wiki Page: How to show measure values as either ‘0’ or ‘NULL’ in Cube?

Anil Maharjan

Table of Contents INTRODUCTION: OVERVIEW: IN BRIEF: SUMMARY: REFERENCES: INTRODUCTION: This article will allow you to know more about showing measure values as either 0 or NULL in SSAS OLAP Cubes. This will help you to understand what the conditions you need to consider while displaying...

on30 May 2017
Wiki Page: Introduction To SQL Database Query Editor In Azure Portal

Richard Mueller

Table of Contents Prerequisites How to start Query Editor Query Editor capabilities Connect to your database Write T-SQL Scripts Execute T-SQL Scripts Manage query results Summary Prerequisites Azure account. Recently, Microsoft has announced the availability of an in-browser query...

on22 May 2017
Wiki Page: Azure - Install Azure AD Connect with SQL Express

chilberto

To successfully synchronize your on-premise Active Directory with Windows Azure Active Directory you can use either DirSync or Azure AD Connect. For reference you can read more here: https://azure.microsoft.com/en-us/documentation/articles/active-directory-aadconnect/ Step 1: Download Azure...

on9 May 2017
Wiki Page: Sql Job : Traffic Light Status - depending on last 3 execution results

Richard Mueller

Recently came across interesting requirement from business. Sql jobs keeps loading/refreshing data for projects. If you are not showing last data refresh time in report then end users will not be having idea about data updates. They will start panicking saying reports not showing correct data and you...

on6 May 2017
Wiki Page: Azure SQL Database: Firewall security

Peter Geelen

Table of Contents Configure Server-Level Firewall Settings: Using the Management Portal Using Master or User Database: Configure Database-Level Firewall Settings: Microsoft Azure SQL Database provides a relational database service for Azure and other Internet-based applications. To help protect...

on4 May 2017
Wiki Page: Loading multiple files into tables with TSQL

Burak Uğur

With the help of this code we can load multiple files into SQL Server table without using SSIS. I tested this code by creating two excel files i.e. ProductCategory.xlsx & ProductCategory1.xlsx at path D:\Project\Files\ and loaded into the table dbo.ProductCategory. IF OBJECT_ID('tempdb...

on4 May 2017
Wiki Page: Wait Type RESOURCE_SEMAPHORE_QUERY_COMPILE - que se refere a um wait de compilação

Edward van Biljon

Após uma boa sequência de artigos falando sobre o AlwaysOn hoje decidi falar um pouco sobre um outro assunto que me deparei a alguns dias em um dos clientes que trabalho neste artigo quero falar sobre o wait type RESOURCE_SEMAPHORE_QUERY_COMPILE que se refere a um wait de compilação. Para acessar...

on24 Apr 2017
Wiki Page: SSRS Troubleshooting: How to handle image/pjpeg MIME Type in image control which is not supported

Peter Geelen

Solution: Go to the image control and find Properties. Find the property "Use this MIME type" Write an expression to change the MIME type to a MIME type that is supported by SSRS ex: IIf(First(Fields!MIME_TYPE.Value, "DataSetImage") = "image/pjpeg", "image...

on23 Apr 2017
Wiki Page: SSAS: How to find a Calculated Measure and Calculated Dimension within a particular cube.

Carsten Siemens

Table of Contents INTRODUCTION: OVERVIEW: IN BRIEF: DMV: SUMMARY: REFERENCES: INTRODUCTION: This article will allow you to know how to find Calculated Measure and Calculated Dimension within a particular cube in SSAS. OVERVIEW: To list the calculated measures within a particular cube...

on9 Apr 2017
Wiki Page: SQL Server Troubleshooting: It is not possible to enumerate the physical disk drives in the cluster resource group. The cluster group could not be found

Richard Mueller

Table of Contents Environmental Details: Solution: Article Reference: When trying to Enumerate cluster Disk in SQL resource Group using SQL CAP for configuring DFSR "Replication Group for data collection in DSFR cluster", we may receive the error message "It is not possible to enumerate...

on8 Apr 2017

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

Wiki Page: BizTalk Server: Administrator Queries and Scripts (nb-NO)

Wiki Page: Invoke a SQL Stored Procedure on the BizTalk WCF Send Port without Needing an Orchestration

Wiki Page: Working with Transparent Data Encryption in SQL Server

Wiki Page: How to show measure values as either ‘0’ or ‘NULL’ in Cube?

Wiki Page: Introduction To SQL Database Query Editor In Azure Portal

Wiki Page: Azure - Install Azure AD Connect with SQL Express

Wiki Page: Sql Job : Traffic Light Status - depending on last 3 execution results

Wiki Page: Azure SQL Database: Firewall security

Wiki Page: Loading multiple files into tables with TSQL

Wiki Page: Wait Type RESOURCE_SEMAPHORE_QUERY_COMPILE - que se refere a um wait de compilação

Wiki Page: SSRS Troubleshooting: How to handle image/pjpeg MIME Type in image control which is not supported

Wiki Page: SSAS: How to find a Calculated Measure and Calculated Dimension within a particular cube.

Wiki Page: SQL Server Troubleshooting: It is not possible to enumerate the physical disk drives in the cluster resource group. The cluster group could not be found