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:
Dimensão (pt-BR)
Fernando Lugão Veltem
Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/dimension.aspx Visão Geral Uma dimensão é um componente-chave de um banco de dados do SQL Server Analysis Services (SSAS) . O Modelo Dimensional Unificado (pt-BR) é...
on
28 Mar 2012
Wiki Page:
Analysis Services Data Source
Fernando Lugão Veltem
Overview In a SQL Server Analysis Services (SSQL) database, a data source is a relational database that provides data for the Analysis Services database's dimensions and measure groups . The data source is an object in the Analysis Services database; the object specifies a provider and connection...
on
24 Mar 2012
Wiki Page:
Password Audit for SQL Server Logins | Find Blank or Common Passwords for SQL Logins
Sarabpreet Singh Anand
P assword audit is a must for all SQL Servers. Weak or Blank passwords are invitation to trouble and such type of passwords may result in security breach. Everybody knows the importance of Strong and Complex password but as they say it’s always easy to preach but difficult to practice, we tend...
on
5 Mar 2012
Wiki Page:
SQL Server’da Bir Kaydın Fiziksel Konumunu Bulma (tr-TR)
Patris_70
Bu makalemde undocumented komut ve fonksiyonlar yardımıyla SQL Server'da bir tablodaki bir kayıt satırının fiziksel konumunu nasıl bulunacağını ve fiziksel konumdan nasıl okunacağını aktaracağım. SQL Server veritabanı sisteminde her bir kayıt için kayıtın tutulduğu file_id...
on
25 Feb 2012
Wiki Page:
Notas de versão do Microsoft SQL Server 2005 SP4 (pt-BR)
Ed Price - MSFT
Clique aqui para alterar o idioma . Estas notas de lançamento são monitoradas de perto e cuidadosamente. Quaisquer alterações feitas serão avaliada e, em seguida, rapidamente aceita, refinada ou revertida. Por ser um wiki, adições ou refinamentos...
on
24 Jan 2012
Wiki Page:
Dedicated Administrator Connection (DAC) (tr-TR)
Ed Price - MSFT
Dedicated Administrator Connection (DAC) SQL Server 2005 ile birlikte gelen güzel, kullanışlı ve çoğu zaman hayat kurtarıcı bir özelliktir(Bir DBA için DAC, zorda kaldığında kullanabileceği bir arka kapıdır.). SQL Server veritabanı sisteminiz bir şekilde kaynak yetersizliğinden...
on
20 Dec 2011
Wiki Page:
Encrypt Stored Procedures Without Third Party Tools
Ed Price - MSFT
For the last couple of weeks, I was thinking about finding a solution to encrypt the stored procedures of my database in SQL Server 2005. The reason behind this goal is that normally our stored procedures contain complex business logic. This business logic is the intellectual property of the company...
on
13 Oct 2011
Wiki Page:
善用 SQL Server Management Studio 選項設定DB作業環境 (zh-TW)
Ed Price - MSFT
我們每天與 SQL Server 資料庫為伍,絕對不能跟 Management Studio 不熟,就像我們一般日常做程式開發時一樣,開發工具的「選項」設定多少都會調整一下方便我們工作。但是工作環境切換到 Management Studio 之後我卻發現許多人不知道要善用 Management Studio 的 [選項] 設定,今天我就來分享一些我常用的 [選項] 設定值 (非預設值)。 [環境] / [鍵盤] → 將常用的 DB 管理作業(預儲程序)設定成快速鍵 如下圖所示,我之前有寫過一支 在 SQL Server 2005 中取得所有欄位定義的方法(含備註欄位...
on
3 Oct 2011
Wiki Page:
如何變更 SQL Server 預設的資料檔路徑與備份檔路徑 (zh-TW)
Ed Price - MSFT
當你安裝好 SQL Server 2005/2008 之後,通常相關檔案的預設安裝路徑都會在 C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL 目錄下,而該目錄下有兩個很重要的目錄,分別是 DATA (資料檔儲存目錄) 與 Backup (備份檔儲存目錄),如果你希望將這些重要檔案儲存在其他磁碟機時,直接透過 SQL Server Management Studio (SSMS) 就可以修改 DATA (資料檔儲存目錄) 的預設路徑,不過卻無法透過 SSMS 修改預設備份檔的路徑。 我個人的開發環境 C 磁碟機已經只剩下 1GB 了,所以每次在開資料庫的時候...
on
3 Oct 2011
Wiki Page:
How to Move the Site Database in System Center Configuration Manager 2007
Ed Price - MSFT
INTRODUCTION This article describes how to move the Site Database in Microsoft System Center Configuration Manager 2007 from a computer that is running Microsoft SQL Server 2005 to another drive on the same computer, or to another computer that is running SQL Server 2005. MORE INFORMATION In...
on
1 Sep 2011
Wiki Page:
Database Engine Security Checklist: Limit Access to Data
Ed Price - MSFT
This checklist helps you review how you limit access to data in your organization. Use this checklist to periodically audit how users access information stored in the SQL Server Database Engine. Access to the Instance of SQL Server These items relate to the entire instance of the Database Engine...
on
23 Aug 2011
Wiki Page:
Database Engine Security Checklist: Enhance the Security of Database Engine Connections
Ed Price - MSFT
This checklist reviews key options to use when connecting to the SQL Server Database Engine. Use this checklist to review your environment to make sure that connections are made to the Database Engine as securely as necessary for your business needs. Database Engine Configuration ....
on
23 Aug 2011
Wiki Page:
Database Engine Security Checklist: Encrypt Sensitive Data
Ed Price - MSFT
This checklist helps you confirm that encryption is used appropriately in your environment. Use this checklist to periodically audit your use of encryption with the SQL Server Database Engine. Database Level ... Description Have you evaluated encrypting...
on
23 Aug 2011
Wiki Page:
如何比對兩個表格中的資料是否相等 (zh-TW)
Ed Price - MSFT
微軟在SQL Server 2005 有出一個 tablediff 公用程式 ,可以用來比較兩份資料表的資料是否一致,如果不一致的時候會幫你產生更新的 SQL 檔,幫你再目的地的表格執行INSERT,UPDATE或DELETE以進行同步動作,因為這是一支DOS介面的程式,您可以在命令提示字元之下,或是在批次檔中寫好相關的指令、參數,然後每天定時執行即可。 這工具有個缺點,就是在進行比對的過程中預設來說不會對 text、ntext、image、varchar(max)、nvarchar(max) 和 varbinary(max) 進行比對與更新,這點還蠻討厭的,因為應該有蠻多表格中可能包含這些欄位的...
on
6 Jul 2011
Wiki Page:
Como Criar o CUBO OLAP do Project Server 2007 – SQL Server 2000, SQL Server 2005 e SQL Server 2008 (pt-BR)
Luciano Lima [MVP]
Vendo nosso relatório de acessos e as origens dos mesmos, percebi que tem MUITA gente com problema para criar o cubo. Então vai aí os únicos 3 links que você vai precisar para criar o cubo no SQL Server, nas três versões, sem problemas: Como Criar o CUBO...
on
21 Mar 2011
Page 3 of 3 (65 items)
1
2
3
Can't find it? Write it!
Post an Article