TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Microsoft Edge
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Skype for Business
See all products »
Resources
Channel 9 Video
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Windows Update
Trials
Windows Server 2016
System Center 2016
Windows 10 Enterprise
SQL Server 2016
See all trials »
Related Sites
Microsoft Download Center
Microsoft Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Expert-led, virtual classes
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
Microsoft Official Courses On-Demand
Certifications
Certification overview
Special offers
MCSE Cloud Platform and Infrastructure
MCSE: Mobility
MCSE: Data Management and Analytics
MCSE Productivity
Other resources
Microsoft Events
Exam Replay
Born To Learn blog
Find technical communities in your area
Azure training
Official Practice Tests
Support options
For business
For developers
For IT professionals
For technical support
Support offerings
More support
Microsoft Premier Online
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
Home
Library
Wiki
Learn
Gallery
Downloads
Support
Forums
Blogs
Resources For IT Professionals
United States (English)
Россия (Pусский)
中国(简体中文)
Brasil (Português)
Skip to locale bar
Get this Tag RSS feed
Translate this page
Powered by
Microsoft® Translator
Popular Tags
Active Directory
AD
AD DS
adfs
ASP.NET
azure
BizTalk
BizTalk Server
BizTalk Server 2010
C#
Candidate for deletion
certification
cloud
core docs
de-DE
EAA
Ed Price
Ed's Stub Pages
en-US
ESA
es-ES
Excel
Exchange
Exchange 2010
fa-IR
Fernando Lugao Veltem
FIM
FIM 2010
FIM Resources
FIM-HELP
forefront
forums
fr-FR
Gokan Ozcifci
has code
has comment
has comments
has image
has Images
has Other Languages
has See Also
Has Table
Has TOC
Horizon_Net
How To
Hyper-V
id-ID
IIS
Italian Wiki Articles
it-IT
ja-JP
Jordano Mazzoni
Link Collection
Luciano Lima
Luigi Bruno
Lync Server 2010
MIISILMFIM MACAULAY
Multi Language Wiki Articles
needs work
operations manager
Pirated Content
Portal
Português Brasil
PowerShell
pt-BR
security
SharePoint
SharePoint 2010
SharePoint 2013
SharePoint Pirate
Small Basic
solucionando problemas
SQL Server
SQL Server 2012
stub
System Center
System Center 2012
TechNet Guru
TechNet Wiki
TechNet Wiki Featured Article
tonyso
Translated into Japanese
troubleshooting
tr-TR
vídeo
Video
Virtualization
VMM
Wiki
Windows
Windows 7
Windows 8
Windows Azure
Windows Server
Windows Server 2003
Windows Server 2008
Windows Server 2008 R2
Windows Server 2012
yottun8
اکتیو دایرکتوری
Browse by Tags
>
TechNet Articles
>
All Tags
>
SQL Server 2005
Tagged Content List
Wiki Page:
Snowflake Schema
Payman Biukaghazadeh
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...
on
2 May 2013
Wiki Page:
Fact (OLAP)
Richard Mueller
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...
on
1 May 2013
Wiki Page:
KPI
Richard Mueller
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...
on
7 Feb 2013
Wiki Page:
SQL Server Database Engine Configuration: Best Practices For Sharepoint 2010/2013 On SQL Server
Sean Gallardy
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...
on
1 Feb 2013
Wiki Page:
SQL Server Books
Kumar Vivek
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...
on
10 Dec 2012
Wiki Page:
Migrating the AD RMS Database from Windows Internal Database (WYukon) to SQL Server 2005 SP2
Ed Price - MSFT
Table of Contents Overview Preparing for the migration Performing the migration Prepare the AD RMS server Migrate the databases to the destination SQL Server Configure the AD RMS server to use the new SQL Server Troubleshooting SQL Server connection errors Overview When an organization chooses...
on
3 Dec 2012
Wiki Page:
SQL Server Analysis Services (SSAS)
Richard Mueller
Table of Contents Overview Analysis Services Wiki Articles Dimensional Modeling 101 Security Performance Administration and Monitoring Tools Query and DDL Languages Data Mining See Also Other Languages Brazilian Portuguese (pt-BR) German (de-DE) Overview SQL Server Analysis Services (SSAS) is...
on
3 Aug 2012
Wiki Page:
Database Engine Security Checklist: Database Engine Security Configuration
Ed Price - MSFT
This checklist reviews key security configuration options for the SQL Server Database Engine. Use this checklist to periodically audit your Database Engine environment. These recommended settings should be adjusted based on your security and business needs. Table of Contents Physical Security Operating...
on
5 Jun 2012
Wiki Page:
Backup e Restore do Ambiente com SQL Server e TOTVS Microsiga (pt-br)
Thiago Cardoso Luiz
ARTIGO MIGRADO PARA O TECHNET WIKI BRASIL. Escopo: Atualização de um ambiente de teste para ficar identico ao ambiente de produção do ERP Microsiga Ambiente: Aplicação: TOTVS Microsiga 10. BD: SQL Server 2005 SO: Windows Server 2003 O procedimento...
on
4 Jun 2012
Wiki Page:
SQL Server: 內部錯誤。提供給讀取資料行值的緩衝區太小。(zh-TW)
Fernando Lugão Veltem
前陣子用了 SQL Server 2005 中極少人使用的 Query Notification 功能,且我下的 SQL 指令明明就很單純,只是做一個簡單的 SELECT 查詢卻會引來 SQL Server 的內部錯誤,自己奮戰了一個多月無解,最後還是靠微軟的技術支援中心幫我解了這個難題。 如果你安裝的是中文版的 SQL Server 2005 的話訊息的話,那麼訊息就一定會只有中文,我想全世界只有我這篇文章是中文且可參考的資料,查這些資料真是累死我了,早知道就早點打電話尋求支援。 同一種錯誤,我從各方取得各種不同的錯誤訊息如下: Event Log 得到的錯誤 : ...
on
13 May 2012
Wiki Page:
SQL Server Analysis Services (SSAS) (de-DE)
Horizon_Net
Table of Contents Überblick Analysis Services Wiki Artikel Multidimensionale Modellierung Performance Administration und Monitoring Tools Abfrage und DDL Sprachen Data Mining Siehe auch Andere Sprachen English Português Überblick SQL Server Analysis Services (SSAS) ist Microsoft's...
on
30 Mar 2012
Wiki Page:
Unified Dimensional Model (de-DE)
Horizon_Net
Table of Contents Definition Komponenten Quellen Siehe auch Andere Sprachen English Português Definition Das Unified Dimensional Model (UDM) ist ein Datenmodell in SQL Server Analysis Services (SSAS) Datenbanken. UDM vereint dabei Daten von verschiedenen relationalen Datenbanken in einen...
on
30 Mar 2012
Wiki Page:
Grupo de Medidas (pt-BR)
Horizon_Net
Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/measure-group.aspx Visão Geral As medidas são valores numéricos dos fatos (operações) que analisam os usuários em um banco de dados OLAP. No SQL Server...
on
30 Mar 2012
Wiki Page:
Measure Group (de-DE)
Horizon_Net
Überblick Measures sind numerische Werte aus Fakten (Transaktionen), die ein Nutzer in einer OLAP Datenbank analysieren kann. Im SQL Server Analysis Services (SSAS) werden Measures, die aus der selben Quelltabelle der OLAP Datenbank kommen, in sogenannten Measue Groups zusammengefasst. ...
on
30 Mar 2012
Wiki Page:
Snowflake Schema (pt-BR)
Fernando Lugão Veltem
Esse artigo foi originalmente escrito em : http://social.technet.microsoft.com/wiki/contents/articles/snowflake-schema.aspx Visão Geral No SQL Server Analysis Services (SSAS) , snowflake schema descreve um modelo de dados populares para data warehouses relacionais. Semelhante ao star...
on
30 Mar 2012
Wiki Page:
Exibição de Fonte de Dados (pt-BR)
Horizon_Net
Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/data-source-view.aspx Visão Geral No SQL Server Analysis Services (SSAS), o Data Souce View é um diagrama de um ou mais fontes de dados relacionais da fonte de dados da base de...
on
30 Mar 2012
Wiki Page:
Data Source View (de-DE)
Horizon_Net
Überblick In SQL Server Analysis Services (SSAS) ein Data Source View ist eine Sammlung von einer oder mehren relationalen Datenbanken für die SSAS Datenbank. Entwickler nutzen Komponenten vom Data Source View um SSAS Datenbank-Objekte (z.B. Dimensionen und Measure Groups) zu erstellen...
on
30 Mar 2012
Wiki Page:
Modelo Dimensional Unificado (pt-BR)
Horizon_Net
Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/unified-dimensional-model.aspx Definição O Modelo Dimensional Unificado é o modelo de dados em um banco de dados do SQL Server Analysis Services (SSAS). O Modelo Dimensional...
on
30 Mar 2012
Wiki Page:
Perspectiva (pt-BR)
Fernando Lugão Veltem
Esse artigo foi originalmente escrito em : http://social.technet.microsoft.com/wiki/contents/articles/perspective.aspx Visão Geral Em um banco de dados do SQL Server Analysis Services (SSAS) , uma perspectiva é uma visão limitada de um cubo . Perspectivas aprimoram a experiência...
on
29 Mar 2012
Wiki Page:
Star Schema (pt-BR)
Fernando Lugão Veltem
Esse artigo foi originalmente escrito em : No SQL Server Analysis Services (SSAS) , um star schema descreve um modelo de dados comum para data warehouses relacionais. Em uma star schema, existem dois tipos de tabelas: tabelas de fatos e tabelas de dimensão . Em geral, um data warehouse...
on
29 Mar 2012
Wiki Page:
KPI (pt-BR)
Fernando Lugão Veltem
Esse artigo foi originalmente escrito em : http://social.technet.microsoft.com/wiki/contents/articles/kpi.aspx Visão Geral No SQL Server Analysis Services (SSAS) , um key performance indicator (KPI) é uma métrica que uma empresa utiliza para medir o seu sucesso e progresso...
on
29 Mar 2012
Wiki Page:
Cubos (pt-BR)
Fernando Lugão Veltem
Esse artigo foi originalmente escrito em : http://social.technet.microsoft.com/wiki/contents/articles/cube.aspx Visão Geral Em um banco de dados do SQL Server Analysis Services (SSAS) , um cubo é um contêiner para objetos e dados para as querys dos usuários: dimensões...
on
28 Mar 2012
Wiki Page:
Grãos (OLAP) (pt-BR)
Fernando Lugão Veltem
Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/grain-olap.aspx Visão Geral No SQL Server Analysis Services (SSAS) , os grãos ou a granularidade de um fato define o nível de detalhamento gravado no fato; é determinada...
on
28 Mar 2012
Wiki Page:
Fato (OLAP) (pt-BR)
Fernando Lugão Veltem
Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/1236.fact-olap.aspx Visão Geral No SQL Server Analysis Services (SSAS) data warehouse e as soluções OLAP/UDM, um fato é um único registro, geralmente representar...
on
28 Mar 2012
Wiki Page:
Fonte de Dados do Analysis Services (pt-BR)
Fernando Lugão Veltem
Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/1243.analysis-services-data-source.aspx Visão Geral Em um banco de dados do SQL Server Analysis Services (SSQL) , uma fonte de dados é um banco de dados relacional que fornece dados...
on
28 Mar 2012
Page 2 of 3 (65 items)
1
2
3
Can't find it? Write it!
Post an Article