Brad Chen's SQL Server Blog
MS, SQL Server Support, Guidelines, Performance, Tips, Troubleshooting
Setting Up SQL Server 2008 R2 Database Mirroring step by step
Setting Up SQL Server 2008 R2 Database Mirroring step by step 1.Prepare a Mirror Database for...
Author: Brad Chen Date: 08/31/2013
Burn an ISO image to physical DVD media with Windows 2008 R2 build-in tool "isoburn.exe"
1.You must have the Desktop Experience pack installed 必須安裝桌面體驗 2.Windows Server 2008 R2 machines...
Author: Brad Chen Date: 07/10/2013
Microsoft Office Access Performance Tuning Guide
1.依據KB209126的建議來最佳化查詢效能。Information about query performance in an Access...
Author: Brad Chen Date: 07/06/2013
Recovering a SQL Server cluster group and resources
如何將誤刪的SQL Server Cluster Group加回 1.Create a new SQL Server resource group in Failover Cluster...
Author: Brad Chen Date: 06/20/2013
指定本地快照目錄來改善初始化時間 Apply snapshot from Alternate folder to improve performance when initialize a Subscription in Transactional Replication
Apply snapshot from Alternate folder to improve performance when initialize a Subscription in...
Author: Brad Chen Date: 06/09/2013
Windows 2012 Failover Cluster Management Console Error "A weak Event was created and it lives on the wrong object"
最近因為客戶的需求在Windows Server 2012上安裝一組SQL Server 2012 Failover Cluster，遇到以下問題，以下是解決方法: [Symptoms] When...
Author: Brad Chen Date: 06/05/2013
Quick to build a testing web site to access SQL Server
Classic ASPHow to access SQL Server in Active Server...
Author: Brad Chen Date: 05/05/2013
Install SharePoint 2010 and initial configuration(SharePoint Products Configuration Wizard)
1.啟動安裝程式，點選[安裝軟體先決條件](Install prerequisites)。 2.這些必要元件與軟體必須透過網際網路下載(download from...
Author: Brad Chen Date: 05/04/2013
Install and Setup Reporting Service with SharePoint Integration
1.環境 Server 1: Lab09MOSS (1)Windows 2008 R2 (2)Sharepoint Server 2010 (3)SQL 2008 R2 Reporting...
Author: Brad Chen Date: 05/03/2013
Install SQL Server 2012 Failover Cluster with Command Line and Configuration File
Install SQL Server 2012 Failover Cluster with Command Line and Configuration File 1.安裝設定好Windows...
Author: Brad Chen Date: 04/19/2013
Install SQL Server 2012 with command line
Install SQL Server 2012 with command line 1.安裝SQL Server之前，必須先安裝.Net Framework 3.5.1。 可以透過Server...
Author: Brad Chen Date: 04/19/2013
Setup SQL Server 2012 AlwaysOn Availability Groups using Certificate
Setup SQL 2012 AlwaysOn Availability Groups using Certificate 1.如果SQL Server的啟動帳戶使用本機帳戶或虛擬帳戶Virtual...
Author: Brad Chen Date: 01/30/2013
Setup SQL Server 2012 AlwaysOn Availability Groups using Join Only
Setup SQL 2012 AlwaysOn Availability Groups using Join Only 1.事先將主要Instance上的MyDB資料庫做備份(a Full...
Author: Brad Chen Date: 01/29/2013
Setup SQL Server 2012 AlwaysOn Availability Groups using Skip initial data synchronization
Setup SQL 2012 AlwaysOn Availability Groups using Skip initial data synchronization...
Author: Brad Chen Date: 01/28/2013
Quick Setup a SQL Server 2012 AlwaysOn Availability Groups
Quick Setup a SQL 2012 AlwaysOn Availability Groups 以下範例所有Instance的SQL Server啟動帳戶都同一個網域帳戶(domain...
Author: Brad Chen Date: 01/28/2013
Remove a crash SQL Cluster Node and add new SQL Cluster Node back to exist SQL Cluster
如何移除一個硬體損毀的節點，並且重新加入原來的叢集 To recover from a failover cluster hardware failure 1.After Node 1 fails,...
Author: Brad Chen Date: 01/27/2013
Manage a SQL Server failover cluster from command line or powershell
Manage a SQL Server failover cluster from command line or powershell 使用Command line或PowerShell管理SQL...
Author: Brad Chen Date: 01/24/2013
AD account permission required for SQL Server failover Cluster Installation
如果沒有Domain管理員的權限要安裝SQL Server Cluster需要在Active Directory額外設定一些電腦帳戶與權限，當參考以下這篇MSDN文件時常常會被一些名詞混淆。...
Author: Brad Chen Date: 01/20/2013
SQL Server 2012 certifications
Microsoft SQL Server certifications https://www.microsoft.com/learning/en/us/sql-certification.aspx...
Author: Brad Chen Date: 01/16/2013
Build a two-node SQL Server 2008 R2 Cluster with iSCSI
Build a two-node SQL Server 2008 R2 Cluster with iSCSI Lab VMs: 1.iSCSITarget (Windows Storage...
Author: Brad Chen Date: 01/12/2013
Add a node to an existing two-node SQL Server 2008 R2 Cluster
Add a node to an existing two-node SQL Server 2008 R2 Cluster 如何新增一個節點到已經存在的SQL Server 2008 R2...
Author: Brad Chen Date: 01/12/2013
SQL Server 2012 Installing on Windows Server 2012, Error while enabling Windows feature : NetFx3, Error Code : –2146498298
1.安裝過程發生Error while enabling Windows Feature NetFx3, Error Code : –2146498298 的警告。 Error while...
Author: Brad Chen Date: 01/07/2013
How to Rename SQL Server Cluster Virtual Server Name(Network name)
How to Rename SQL Server Cluster Virtual Server Name(Network name) Rename a SQL Server Failover...
Author: Brad Chen Date: 12/15/2012
SQL Server 2012 Installation fail "Managed SQL Server Installer has stopped working"
SQL Server 2012 Installation fail "Managed SQL Server Installer has stopped working" 在Windows...
Author: Brad Chen Date: 12/15/2012
不允許儲存變更saving changes is not permitted
不允許儲存變更saving changes is not permitted SQL Server...
Author: Brad Chen Date: 12/15/2012
使用一句SQL INSERT多筆Record(multiple values)
使用一句SQL INSERT多筆Record(multiple values) 此功能在MySQL在3.22.5之後就有的功能,SQL Server在這個SQL Server...
Author: Brad Chen Date: 12/15/2012
SQL Server 2008 Installation on Vista Business Edition(在Vista安裝SQL Server 2008)
SQL Server 2008 Installation on Vista Business Edition(在Vista安裝SQL Server 2008) SQL Server...
Author: Brad Chen Date: 12/15/2012
SQL Server 2008 與SQL Server 2005 Sample Databases範例資料庫下載與安裝
SQL Server 2008 與SQL Server 2005 Sample Databases範例資料庫下載與安裝 SQL Server 2008安裝光碟已不再含有範例資料庫Sample...
Author: Brad Chen Date: 12/15/2012
立即中斷所有SQL Server連線
立即中斷所有SQL Server連線 1.針對單一資料庫的連線範例:將Northwind資料庫設定為只能有一個連線,並中斷其他連線--中斷Northwind資料庫的所有連線USE...
Author: Brad Chen Date: 12/15/2012
SQLDiag工具程式Bug-Buffer overrun detected
SQLDiag工具程式Bug-Buffer overrun detected 當SQL Server...
Author: Brad Chen Date: 12/15/2012
SQLDiag工具程式的使用
SQLDiag工具程式的使用 前言:SQLDiag是SQL Server內建的診斷收集共用程式,[SQL Server 2005]預設位置:C:\Program Files\Microsoft SQL...
Author: Brad Chen Date: 12/15/2012
SQL 2000 Determine primary key from system table 列出所有Primary Key
SQL 2000 Determine primary key from system table 列出所有Primary Key SELECT object_name(a.[id]) as...
Author: Brad Chen Date: 12/15/2012
Listing space used information in each database files
Listing space used information in each database files -- SQL Server 2000請將...
Author: Brad Chen Date: 12/15/2012
SQL Server 2000 xp_cmdshell移除與回復
SQL Server 2000 xp_cmdshell移除與回復 1.xp_cmdshell是一個延伸預存程序,可以讓T-SQL執行shell command 2.SQL Server 2000...
Author: Brad Chen Date: 12/15/2012
錯誤22002:RegCreateKeyEx()傳回錯誤5,存取被拒(Microsoft SQL-DMO ODBC SQL狀態: 42000)
錯誤22002:RegCreateKeyEx()傳回錯誤5,存取被拒(Microsoft SQL-DMO ODBC SQL狀態: 42000) SQL Server 2000...
Author: Brad Chen Date: 12/15/2012
Good SQL Server Blogs
SQL Release Services Bloghttps://blogs.msdn.com/b/sqlreleaseservices/ CSS SQL Server...
Author: Brad Chen Date: 12/15/2012
My old blog
本人的工作是協助客戶解決SQL Server問題，此blog除了將自己所學的心得與經驗做下筆記之外，也希望能幫助到需要的朋友。...
Author: Brad Chen Date: 12/15/2012