Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

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

  • Wiki Page: Unified Dimensional Model

    Table of Contents Definition Components Community Resources See Also Other Languages Brazilian Portuguese (pt-BR) German (de-DE) Definition The Unified Dimensional Model (UDM) is the model for data in a SQL Server Analysis Services (SSAS) database. The UDM is unified because it combines data...
    on30 Jul 2013

  • Wiki Page: How to Troubleshoot Connecting to the SQL Server Database Engine

    This is an exhaustive list of troubleshooting techniques to use when you cannot connect to the SQL Server Database Engine. These steps are not in the order of the most likely problems which you probably already tried. These steps are in order of the most basic problems to more complex problems. These...
    on15 Jul 2013

  • Wiki Page: Accessing SQL Server Databases from PHP

    The Microsoft Drivers for PHP for SQL Server are Microsoft-supported extensions of PHP 5 that provide data access to all editions of SQL Server, beginning with SQL Server 2005. The Microsoft Drivers for PHP for SQL Server include two PHP extensions for accessing data in SQL Server: a procedural interface...
    on9 Jul 2013

  • Wiki Page: Measure Group

    Overview Measures are the numeric values of the facts (transactions) that users analyze in an OLAP database. In SQL Server Analysis Services (SSAS) , measures that come from the same source table in the OLAP database's data source are grouped together in a container called a measure group...
    on22 Jun 2013

  • Wiki Page: Time Dimension

    Table of Contents Overview Population Script OLAP Development Overview Population Script OLAP Development
    on22 Jun 2013

  • Wiki Page: Perspective

    Overview In a SQL Server Analysis Services (SQL) database, a perspective is a limited view of a cube . Perspectives enhance a user's experience by limiting the cube's visible objects to those objects relevant to the user's work. For example, a business that sells products through brick...
    on22 Jun 2013

  • Wiki Page: Dimension

    Overview A dimension is a key component of a SQL Server Analysis Services (SSAS) database. In the Unified Dimensional Model that is the data model of an Analysis Services database, dimensions describe the data, and users browse, filter, and aggregate data by manipulating dimensions. Understanding...
    on11 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: SQL Server Analysis Services (SSAS) (pt-BR)

    Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/1175.sql-server-analysis-services-ssas.aspx Table of Contents Visão geral Análise serviços Wiki artigos 101 Modelagem Dimensional Segurança Desempenho Administração...
    on6 Jun 2013

  • Wiki Page: Reporting Services Samples on CodePlex (SQL Server Reporting Services SSRS)

    Table of Contents Troubleshooting AdventureWorks sample reports Embedded Reporting The CodePlex home page for all SQL Server Reporting Services (SSRS) samples is SQL Server Reporting Services Product Samples . All of the samples are in one download package. If you are interested only in the...
    on28 May 2013

  • Wiki Page: Cube

    Overview In a SQL Server Analysis Services (SSAS) database, a cube is the container for the objects and data that users query: dimensions , measure groups , KPIs , and perspectives . A cube is analogous to a schema in a relational database: it brings together the metadata, data, and code related...
    on25 May 2013

  • Wiki Page: SQL Server Express: Troubleshoot Installation

    This article contains information on common problems that occur during the installation of SQL Server Express, why they occur and how to resolve them. If you have encountered and resolved a problem that is not listed, or have information to contribute to the resolutions already listed, please edit...
    on14 May 2013

  • Wiki Page: Effective Database Engine Permissions

    This topic describes how to determine who has permissions to various objects in the SQL Server Database Engine. SQL Server implements two permission systems for the Database Engine. An older system of fixed roles has preconfigured permissions. Beginning with SQL Server 2005 a more flexible and precise...
    on9 May 2013

  • Wiki Page: Notas de Versão do Microsoft SQL Server 2008 SP2 (pt-BR)

    Clique aqui para alterar o idioma . Table of Contents Sumário 1.0 Novidades no Service Pack 2 2.0 Antes de instalar o Service Pack 2 2.3 Todos os recursos de uma instância do SQL Server devem ter a mesma versão antes de aplicar uma atualização cumulativa 3.0 Notas de Versão da Versão Original...
    on8 May 2013

  • Wiki Page: Grain (OLAP)

    Overview In SQL Server Analysis Services (SSAS) , the grain or granularity of a fact defines the level of detail recorded in the fact; it is determined by the dimension keys of the fact. If a fact references the key attribute of a dimension, then it records data at the most descriptive level of...
    on8 May 2013

  • Wiki Page: Snowflake Schema

    Overview In SQL Server Analysis Services (SSAS) , snowflake schema describes a popular data model for relational data warehouses. Similar to a star schema , a snowflake schema contains fact and dimension tables, with the fact table storing facts about business transactions and some columns...
    on2 May 2013

  • Wiki Page: Fact (OLAP)

    Overview In SQL Server Analysis Services (SSAS) data warehousing and OLAP/UDM solutions, a fact is a single record, usually representing a business transaction, at the lowest level of granularity recorded in the database. Facts are composed of dimension keys and measures ; the dimension keys reference...
    on1 May 2013

  • Wiki Page: How to Convert a SQL Server Text Column data to VarBinary/Image Column data and back.

    This article is just to show some code to help convert data between SQL server text column and varbinary/image column. This also can help you using the SQL Server READTEXT, WRITETEXT and UPDATETEXT statements. These kind of statements use pointer that are not trivial to SQL Server programmers. ...
    on19 Feb 2013

  • Wiki Page: KPI

    Overview In SQL Server Analysis Services (SSAS) , a key performance indicator (KPI) is a metric that a business uses to measure its success and progress. The metric is compared against a goal to determine its position relative to that goal and its velocity (trend). For example, a business might...
    on7 Feb 2013

  • Wiki Page: SQL Server Database Engine Configuration: Best Practices For Sharepoint 2010/2013 On SQL Server

    Overview The following is a collection of checks that can be run against an instance of SQL Server 2005/2008/2008R2/2012 that is currently or will be used as a dedicated instance for sharepoint databases. The checks come from standard best practices and also from the Sharepoint best practices...
    on1 Feb 2013

  • Wiki Page: SQL Server Books

    Introduction This article is designed to keep a track of all SQL Server related books on the marked. Feel free to update the list with the desired books and links to get them. SQL Server 2012 Introducing Microsoft SQL Server 2012 Microsoft SQL Server 2012 High-Performance T-SQL Using...
    on10 Dec 2012

  • Wiki Page: How to Encrypt Database Backup (id-ID)

    Hasil Backup suatu database dapat dengan mudah untuk bisa di restore di engine SQL Server lain manapun. Tentunya hal ini sangat berbahaya jika hasil backup yang kita hasilkan tercuri atau di copy oleh lawan bisnis kita. Namun sejak versi SQL Server 2008 telah tersedia sebuah fitur “Transparent...
    on6 Dec 2012

  • Wiki Page: SQL Server Database Engine Permission Posters

    Posters are available that list all the granular permissions of the SQL Server Database Engine and Windows Azure SQL Database. Select the pdf images below. You can display these on your computer, expanding or shrinking them to focus on specific areas. Use Control+F to search for a specific permission...
    on29 Nov 2012

  • Wiki Page: Sql server Installation and database Creation with visual studio setup

    Step 1: Create a Setup project right click and select Sql server 2008 as prerequisite. In VS2008 Sql Server 2005 available as prerequisite. Here are the steps to install sql server database with setup using custom action. Step 2: create a text file that contains a...
    on19 Oct 2012

  • Wiki Page: Database Engine Permission Basics

    In SQL Server 2008 R2, Database Engine permissions are managed at the server level through logins and fixed server roles, and at the database level through database users, fixed database roles, and user-defined database roles. Download the Permissions Poster PDF file . Table of Contents Logins...
    on25 Sep 2012
Page 2 of 5 (104 items) 12345
Can't find it? Write it!

Post an Article