Browse by Tags

Table of Contents Introduction Pre-requisites: Step 1 Step 2 Step 3 Step 4 Step 6 Exporting SQL Server data (list of tables, views) into Excel file Importing Excel file into SQL Server Summary See Also Introduction In this post, let us see a new approach to import excel into SQL Server...

Table of Contents Introduction Setting up the development environment Register Bot Application Update AppSeting.JSON File Run the bot application in local emulator Publish Bot Application into Azure App Service Visual Studio Azure Publish Wizard Log in and select Service Bot Deploy Confirmation Summary...

Table of Contents Introduction Data Profiling with different Microsoft tools/products 1) Azure Data Catalog 2) Azure Machine learning 3) Power BI 4) SSIS Data Profiling task and viewer 5) Using ability to execute external scripts Explanation on T-SQL script used in this post for data profiling Data Profiling...

The article below is using SharePoint Module for managing lists, items and files as an extension to SharePoint Management Shell. Install the module to proceed. Table of Contents Access Requests SPOMod Get Access Requests from Multiple Sites Export Access Requests to a report See Also Access...

Table of Contents Introduction Background Conclusion Introduction Here, in this post, we are going to a see how we can resolve the error 404 ResourceNotFound Error After Uploading to Azure CDN. It is obvious that we may feel very sad if we are unable to see the image you recently uploaded to Azure...

Daha önceki yazılarımda MERGE komutunun SQL Server ‘da kullanılma seçenekleri ve komut yapısını ele almıştım. Ayrıca MERGE komutu kullanılarak nasıl bir Type 1 Slowly Changing Dimension (SCD) oluşturulabileceğini örnekler üzerinde göstermiştim. Bunlar ile ilgili yazılarıma aşağıdaki linklerden erişebilir...

Microsoft SQL Server ‘da MERGE komutu ile neler yapılabildiğini serinin daha önceki yazılarında sizlerle paylaşmıştık. Aşağıda MERGE komutunun genel kullanımı, MERGE ile Slowly Changing Dimension (SCD) Type 1 , Type 2 ve Type 3 çözümlerinin nasıl yapılabileceğini aktardığım yazılarım mevcut. Yazının...

Microsoft SQL Server ‘da MERGE komutunun kullanımı ve Slowly Changing Dimension çözümlerinin MERGE komutu ile nasıl yapılabileceğini önceki makalelerimde yazmıştım. Özellikle Type 1 Slowly Changing Dimension (SCD) ve Type 2 Slowly Changing Dimension (SCD) yapılarını ayrı ayrı nasıl çözümleyebileceğimizi...

Table of Contents Introduction Getting Started Planning and Deployment Configure Security Operations / Features Integration Channel 9 Show Tools Partner Solutions Troubleshooting How-To Blogs Community Github Twitter See Also Introduction What is a survival guide? It is a page we created...

Silver Award Winner Table of Contents Minimum requirement for MSSQL installation: Fresh install 1. Login with superuser 2. Download Microsoft SQL Server Red Hat repository configuration file. 3. Copy file in /etc/yum.repos.d/firectory. 4. Install mssql using yum install. 5. Configuration and setting...

The virus Win32/VB.WF might arrive with a link to a *.scr file that looks like a PDF link. When users click it, it begins sending emails using the GAL or contacts. 1. The email subject line often contains “Here you have” or “Just for you” 2. The body of the message contains a specific URL...

Table of Contents Introduction List of modules See Also Other Languages Introduction This article includes a list of modules widely used by the Windows PowerShell community. Many of these projects are open source and located at CodePlex or Technet Script Center. For more information on modules...

Merhaba Windows Azure Mobile Web servisleri ilk yazımızda servisi oluşturma ile alakalı kısa bilgiler verdim. Bu yazım da ise oluşturmuş olduğumuz web servisi üzerindeki platformları ve bu platformlara ait kod dosyalarımızı inceleyeceğiz. Servis oluşturma ile ilgili Part 1 yazımıza aşağıdaki adresten...

Table of Contents Symptoms Cause Resolution See Also Symptoms During execution of the Windows Azure Active Directory Sync tool Configuration Wizard, a Configuration error screen is shown containing the following: Failed to get address for method: CreateIdentityHandle2 from library C:\Program...

Table of Contents Projects Experiments Web Services NoteBooks Datasets Trained Models Settings Reference In the previous article “ Starting with Azure Machine Learning ” we created a free Azure Machine Learning account. If you haven’t done that, please create your own free ML account so you can...

As we are heading towards the modern workplace model, we are thriving a lot on reducing the first level of tasks. One of the preferred feasible solution is to create a self-query knowledge base through which the end users can attempt to address their issues on their own before contacting the IT Team...

Table of Contents Introduction Procedure References Notes Introduction This posting consolidates notes and experience in restoring Workflow Manager 1.0 workflows from content database backups. It does not engage recovering workflow transactional history , but focuses strictly on recovering the...

Table of Contents Introduction Data Source Types and Categories DATA SOURCE CATEGORIES Application Systems Customer Relationship Management Systems (CRMs) Database Systems (RDBMS) Queue Systems & Protocols Legend Related Articles Introduction In this section, we'll explain what types of...

SCCM 2007 has a feature of Network Access Protection. In a non-complex environment, SCCM can be integrated with NPS and DHCP to ensure 100% patch compliance in the network. NPS server is configured to select DHCP as its connection method DHCP server is configured for Network access protection class...

Table of Contents Giris Syntax Giris Merhaba, SPS Services kütüphanesi yazı serimize GetAttachmentCollection operasyon ile devam edeceğiz. Bu makalemize kadar görmüş olduğumuz SPS Kütüphaneleri ile ilgili yazılarımıza aşağıdaki linklerden erişebilirsiniz. SharePoint 2013 – Office 365 SPS...

Table of Contents Giris Syntax WebURL listName userAccount CAMLQuery Demo SEE ALSO Giris Merhaba, SPS Services serimize SPGetLastItemId ile devam ediyoruz. Bundan önceki yazılarımızda SharePoint 2013 – Office 365 SPS Services JQ Kütüphanesi Part – 1 (tr-TR) SharePoint 2013 – Office 365...

Table of Contents Aciklama – SPS Nedir? Duzenlemeye Giris Demo See also Aciklama – SPS Nedir? Merhaba, bu yazımızdan itibaren SharePoint – Office 365 üzerinde geliştirmelerimize sıkça kullanılan SPS JQuery kütüphanesini tanıtarak ve bu kütüphane üzerinden geliştirme yaparak devam edeceğiz. ...

SharePoint – Office 365 üzerinde SPS kütüphanesi işlemlerine devam ediyoruz. Serimizin bu ikinci yazısında SPS ile mevcut site adresini döndürmeye değineceğiz. Yazımızın birinci bölümünde SPS kütüphanesinin sisteme kurulması ve temini ile ilgili temel bilgiler vermiştik. Eğer bu bilgiler hafızanızdan...

Table of Contents Introduction What are the new features? Create New Project Wizard Experience. New TimeLine Options. Multiple TimeLine. Set Date Range Project ellipsis Resource Engagements. Project client compatibility Hardware and software requirements. One installation Base installation languages...

Table of Contents Introduction Data Gathering Fidler Flow: Client Hello Conclusion Learn more Errors References Introduction We quite often make changes on the Azure side of things to ensure the level of security is where it needs to be. There’s however scenarios where customers may not have an...