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

  • Wiki Page: SSRS 2008 R2 Atom Data Feeds for PowerPivot

    This article focuses on a new feature of SQL Server Reporting Services 2008 R2: enabling data feeds to be exported from a report and consumed in the new SQL 2008 R2 PowerPivot client. With the release of SSRS 2008 R2, we now have a new rendering extension to render Atom data feeds from SSRS reports...
    on17 Mar 2019

  • Wiki Page: Azure SQL Database: Handling Transactions

    Background This article includes some of the aspects of transaction handling in Windows Azure SQL Database. Some of the information in this article is superseded by the announcement of Elastic Database Transactions. In sum, transactions across Azure SQL Databases are supported using .NET 4.6.1...
    on10 Mar 2019

  • Wiki Page: SQL Server on Linux: Troubleshooting

    won Gold award in Jan 2019 Table of Contents 1. MSSQL is inactive dead state Solution: 2. sqlcmd: command not found Problem: After mssql installation we trying access suing sqlcmd we getting following error. Solution: 3. Unable status SQL services with normal user Problem : Authentication is...
    on8 Mar 2019

  • Wiki Page: Inserindo registros em tabelas no SQL Server

    Table of Contents Criando tabelas e fazendo seus relacionamentos Inserindo registros nas tabelas Criando tabelas e fazendo seus relacionamentos Neste artigo, vamos aprender como inserir registros em tabelas no SQL Server. Primeiramente, vamos criar as tabelas e fazer seus relacionamentos,...
    on7 Mar 2019

  • Wiki Page: PowerPivot for SharePoint Troubleshooting : Installation and Configuration

    This article consists of troubleshooting tips and techniques for working through installation and configuration problems for SQL Server 2008 R2 version of PowerPivot for SharePoint. Please update this page to include any new information or links that you think will be helpful to others. Click Sign...
    on7 Mar 2019

  • Wiki Page: PowerPivot Troubleshooting: Data Refresh

    Applies to: SQL Server 2014 | SQL Server 2012 | SQL Server 2008 R2 This article contains troubleshooting tips and techniques for working through data refresh issues with PowerPivot for SharePoint. Table of Contents Where to get information about data refresh failures What to check for first Data...
    on7 Mar 2019

  • Wiki Page: PowerPivot for SharePoint Architecture

    This article is a video tour of the architecture you'll work with when using PowerPivot for SharePoint. There are four videos in this series, and you can watch them all on this page. This series is presented by Lee Graber , Senior Software Developer, Microsoft SQL Server Analysis Services. The...
    on7 Mar 2019

  • Wiki Page: Power Pivot Glossary

    Microsoft SQL Server Power Pivot provides features that span many technology areas, from relational databases to analytics, to Web publishing. This article provides definitions for some Power Pivot terms and provides links to related content in the TechNet Library. Add words and tweak the definitions...
    on6 Mar 2019

  • Wiki Page: Edge Analytics: Introduction

    Table of Contents Edge analytics offers few key benefits: Reduces Latency and Improves Agility Decrease in Operation and Storage Costs Works in a Low Bandwidth Environment Cost Effective and Reliable Linear Scalability Lowers Inventory Edge analytics is the way data is collected and analyzed. It is...
    on5 Mar 2019

  • Wiki Page: SQL Server: Understanding, Implementing and Managing Policy-Based Management

    Table of Contents 1. Introduction 2. What is Policy-Based Management? 3. Why Policy-Based Management? 4. Components of Policy-Based Management 1. Facets 2. Conditions 3. Policies 4. Evaluation modes 5. Targets 6. Categories 5. Implementing Policy-Based Management 1. Creating a new policy 2. Evaluating...
    on4 Mar 2019

  • Wiki Page: VB.NET Fluent Builder Design Pattern

    Table of Contents Introduction Description Advantages of Builder Design Pattern Disadvantages of Builder Design Pattern Examples Simple fast food Email example Working with databases Reading Updating Misc/Reports Summary See also Source code Introduction The Builder design pattern is a creational...
    on2 Mar 2019

  • Wiki Page: SQL Server Troubleshooting: Logon failure - the user has not been granted the requested logon type at this computer

    Bronze award in Jan 2019 Table of Contents Explanation of the problem Event log Solution Explanation of the problem Mssql service is not starting, with the following error message : "The request failed or the service did not respond in a timely fashion. Consult the event log...
    on28 Feb 2019

  • Wiki Page: Populate Excel files from Data Source

    Table of Contents Scope Introduction Prerequisites Step 1: Create a new project, add references and settings Step 2: Create a parameter file functional to our means Step 3: Extract and write data on pre-existant Excel file Step 3.1: Connect to a database and fill DataTable Step 3.2: Create and reference...
    on27 Feb 2019
Page 18 of 123 (3,075 items) «1617181920»