SQL 2008 5分鐘教學.

2010-02-11

10354
0
sql server

摘要:SQL 2008 5分鐘教學.

進到微軟的第一個課程介紹:

透明資料加密功能簡介建立Master 金鑰及憑證加密資料庫附加已加密資料庫	http://www.microsoft.com/sql/experience/html/ITPros.aspx?loc=zht&v=http%3a%2f%2fmschnlnine.vo.llnwd.net%2fd1%2fedge%2f7%2f3%2f8%2f1%2f1-SQLServer2008TransparentDataEncryption.wmv
Policy Based 管理功能簡介直接在 Management Studio 設定Policy *建立store Procedure 並且驗證Policy	http://www.microsoft.com/sql/experience/html/ITPros.aspx?loc=zht&v=http%3a%2f%2fmschnlnine.vo.llnwd.net%2fd1%2fedge%2f3%2f8%2f8%2f1%2fSQL+Server+2008+Policy+Based.wmv
Data Collection 管理功能簡介手動資料收集產生歷史記錄 *直接在Management Studio 開啟磁碟使用量報表,並且驗證磁碟使用情況.	http://www.microsoft.com/sql/experience/html/ITPros.aspx?loc=zht&v=http%3a%2f%2fmschnlnine.vo.llnwd.net%2fd1%2fedge%2f8%2f3%2f8%2f1%2f3-SQLServer2008DataCollection.wmv
Database Mirroring 管理功能簡介直接在Management Studio 設定資料庫鏡像 *在主體伺服器執行T-SQL產生Page Error,並且模擬使用者執行T-SQL 時由鏡像伺服器自動修復Page Error.	http://www.microsoft.com/sql/experience/html/ITPros.aspx?loc=zht&v=http%3a%2f%2fmschnlnine.vo.llnwd.net%2fd1%2fedge%2f9%2f3%2f8%2f1%2f4-SQLServer2008DatabaseMirroring.wmv
Resource Governor 管理功能簡介效能模擬,模擬兩個Application User 執行SQL Server 效能 *直接在Management Studio 設定限制第二個Application User CPU使用上限	http://www.microsoft.com/sql/experience/html/ITPros.aspx?loc=zht&v=http%3a%2f%2fmschnlnine.vo.llnwd.net%2fd1%2fedge%2f0%2f4%2f8%2f1%2f5-SQLServer2008ResourceGovernor.wmv
Reporting Services 設計功能簡介使用Visual Studio 2008 報表伺服器開發報表在Matix 表後建立第二個計算總計單位 Report Builder 2.0 介紹	http://www.microsoft.com/sql/experience/html/ITPros.aspx?loc=zht&v=http%3a%2f%2fmschnlnine.vo.llnwd.net%2fd1%2fedge%2f1%2f4%2f8%2f1%2f6-SQLServer2008ReportingServices.wmv
稽核資訊功能簡介在 Management Studio 建立稽核(Audit) 在 Management Studio 建立資料庫稽核(Audit) 驗證執行查詢表格稽核	http://www.microsoft.com/sql/experience/html/ITPros.aspx?loc=zht&v=http%3a%2f%2fmschnlnine.vo.llnwd.net%2fd1%2fedge%2f4%2f8%2f8%2f1%2fSQL+Server+2008+Audit.wmv
備份壓縮功能簡介在 Management Studio 建立一般資料庫備份在 Management Studio 使用備份壓縮建立資料庫備份驗證執行還原壓縮備份檔及備份情況比較	http://www.microsoft.com/sql/experience/html/ITPros.aspx?loc=zht&v=http%3a%2f%2fmschnlnine.vo.llnwd.net%2fd1%2fedge%2f5%2f8%2f8%2f1%2fSQL+Server+2008+Backup+Compression.wmv

請大家永躍參與Facebook MSBI 粉思團:http://www.facebook.com/#!/group.php?gid=303757165010

回首頁