Browse by Tags

Tagged Content List
  • Wiki Page: Dimensão (pt-BR)

    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) é...
  • Wiki Page: Analysis Services Data Source

    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...
  • Wiki Page: Password Audit for SQL Server Logins | Find Blank or Common Passwords for SQL Logins

    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...
  • Wiki Page: SQL Server’da Bir Kaydın Fiziksel Konumunu Bulma (tr-TR)

    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...
  • Wiki Page: Notas de versão do Microsoft SQL Server 2005 SP4 (pt-BR)

    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...
  • Wiki Page: Dedicated Administrator Connection (DAC) (tr-TR)

    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...
  • Wiki Page: Encrypt Stored Procedures Without Third Party Tools

    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...
  • Wiki Page: 善用 SQL Server Management Studio 選項設定DB作業環境 (zh-TW)

    我們每天與 SQL Server 資料庫為伍,絕對不能跟 Management Studio 不熟,就像我們一般日常做程式開發時一樣,開發工具的「選項」設定多少都會調整一下方便我們工作。但是工作環境切換到 Management Studio 之後我卻發現許多人不知道要善用 Management Studio 的 [選項] 設定,今天我就來分享一些我常用的 [選項] 設定值 (非預設值)。 [環境] / [鍵盤] → 將常用的 DB 管理作業(預儲程序)設定成快速鍵 如下圖所示,我之前有寫過一支 在 SQL Server 2005 中取得所有欄位定義的方法(含備註欄位...
  • Wiki Page: 如何變更 SQL Server 預設的資料檔路徑與備份檔路徑 (zh-TW)

    當你安裝好 SQL Server 2005/2008 之後,通常相關檔案的預設安裝路徑都會在 C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL 目錄下,而該目錄下有兩個很重要的目錄,分別是 DATA (資料檔儲存目錄) 與 Backup (備份檔儲存目錄),如果你希望將這些重要檔案儲存在其他磁碟機時,直接透過 SQL Server Management Studio (SSMS) 就可以修改 DATA (資料檔儲存目錄) 的預設路徑,不過卻無法透過 SSMS 修改預設備份檔的路徑。 我個人的開發環境 C 磁碟機已經只剩下 1GB 了,所以每次在開資料庫的時候...
  • Wiki Page: How to Move the Site Database in System Center Configuration Manager 2007

    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...
  • Wiki Page: Database Engine Security Checklist: Limit Access to Data

    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...
  • Wiki Page: Database Engine Security Checklist: Enhance the Security of Database Engine Connections

    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 ....
  • Wiki Page: Database Engine Security Checklist: Encrypt Sensitive Data

    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...
  • Wiki Page: 如何比對兩個表格中的資料是否相等 (zh-TW)

    微軟在SQL Server 2005 有出一個 tablediff 公用程式 ,可以用來比較兩份資料表的資料是否一致,如果不一致的時候會幫你產生更新的 SQL 檔,幫你再目的地的表格執行INSERT,UPDATE或DELETE以進行同步動作,因為這是一支DOS介面的程式,您可以在命令提示字元之下,或是在批次檔中寫好相關的指令、參數,然後每天定時執行即可。 這工具有個缺點,就是在進行比對的過程中預設來說不會對 text、ntext、image、varchar(max)、nvarchar(max) 和 varbinary(max) 進行比對與更新,這點還蠻討厭的,因為應該有蠻多表格中可能包含這些欄位的...
  • Wiki Page: Como Criar o CUBO OLAP do Project Server 2007 – SQL Server 2000, SQL Server 2005 e SQL Server 2008 (pt-BR)

    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...
Page 3 of 3 (65 items) 123
Can't find it? Write it!