Brad Chen's SQL Server Blog
MS, SQL Server Support, Guidelines, Performance, Tips, Troubleshooting
workaround for SQLNexus fail to import SQL 2016 trc file(SQLNexus ReadTrace匯入sql 2016 trc失敗)
workaround for SQLNexus fail to import SQL 2016 trc file(SQLNexus ReadTrace匯入sql 2016 trc失敗)...
Author: Brad Chen Date: 07/23/2018
SQLNexus and RML Utilities (ReadTrace) - SQL Server效能分析工具
SQLNexus and RML Utilities (ReadTrace) - SQL Server效能分析工具 軟體下載與安裝方法 1.SQL Server Database Engine...
Author: Brad Chen Date: 07/21/2018
What is ECMAScript ES (什麼是ECMAScript ES3,ES5)
What is ECMAScript ES (什麼是ECMAScript ES3,ES5) 1995年 Netscape...
Author: Brad Chen Date: 07/12/2018
Use the Maintenance Plan Wizard (使用維護計畫精靈)
Use the Maintenance Plan Wizard (使用維護計畫精靈) 1.使用SSMS連線到SQL Server,在SQL Server...
Author: Brad Chen Date: 07/08/2018
Frequently Asked Questions for PSSDiag Collection (PSSDiag收集常見問題)
Frequently Asked Questions for PSSDiag Collection (PSSDiag收集常見問題) Q1.如果你的SQL Server是在Windows...
Author: Brad Chen Date: 07/07/2018
Windows Server Performance Tuning Guidelines
Windows Server Performance Tuning Guidelines OS Documents Windows 2016 Performance Tuning Guidelines...
Author: Brad Chen Date: 05/20/2018
The distribution agent failed to create temporary files in xxx directory. System returned errorcode 5 散發代理程式建立暫存檔失敗
The distribution agent failed to create temporary files in ... directory. System returned errorcode...
Author: Brad Chen Date: 05/01/2018
Replication Log Reader Agent Error "The principal dbo does not exist" 複寫記錄讀取器代理程式出現主體dbo不存在
Replication Log Reader Agent Error "The principal dbo does not exist" 設定SQL Server...
Author: Brad Chen Date: 05/01/2018
Guideline for SQL Server configuration, installation and database creation
Guideline for SQL Server configuration, installation and database creation 1.考慮將Windows電源選項(Power...
Author: Brad Chen Date: 04/25/2018
SQL Server Reporting Services failed to start (Reporting Services啟動失敗)
SQL Server Reporting Services failed to start Reporting Services啟動失敗 Problem 問題: The SQL Server...
Author: Brad Chen Date: 04/24/2018
Cluster service verification failed
Cluster service verification failed 如果在Windows 2012 R2 failover cluster上安裝SQL Server 2008 R2...
Author: Brad Chen Date: 04/20/2018
Install SQL 2017 CU4 non-English locale without internet access(離線安裝SQL 2017 CU4)
Install SQL 2017 CU4 without internet access (離線安裝SQL 2017 CU4) 週日接到微軟一位Machine Learning專家James...
Author: Brad Chen Date: 03/13/2018
複寫疑難排解 Replication Troubleshooting
複寫疑難排解 Replication Troubleshooting 從TLog讀取 sp_replcounters (Transact-SQL) Returns replication...
Author: Brad Chen Date: 01/17/2018
複寫監控 Monitor Replication
複寫監控 Monitor Replication Measure Latency and Validate Connections for Transactional Replication...
Author: Brad Chen Date: 01/17/2018
SQL Server 2008 R2 Management Studio – Darker Shades of Blue Theme
SQL Server 2008 R2 Management Studio – Darker Shades of Blue Theme SSMS 2008 R2 套用Visual...
Author: Brad Chen Date: 01/16/2018
Filter content in ERRORLOG log file過濾log檔案的內容
Filter content in ERRORLOG log file 過濾log檔案的內容...
Author: Brad Chen Date: 11/09/2017
Use Hyper-V differencing disks
Use Hyper-V differencing disks 使用Hyper-V差異虛擬磁碟 現在安裝個Windows Server虛擬機器(VM)通常要10到20GB的磁碟空間,若再安裝SQL...
Author: Brad Chen Date: 06/11/2017
Install Windows Server 2016
Install Windows Server 2016 安裝Windows 2016 1.如果是在Hyper-V的VM安裝windows 2016則會先出現這個畫面...
Author: Brad Chen Date: 06/08/2017
Create a template VM and Create a new VM from template VM
Create a template VM and Create a new VM from template VM 建立範本虛擬機器,透過範本虛擬機器來建立新的虛擬機器 1.Create a...
Author: Brad Chen Date: 06/04/2017
Virtual Machine software and image file
Virtual Machine host software 虛擬機器軟體與虛擬機器映像檔 1.Microsoft 微軟虛擬化軟體 Windows Virtualization Software...
Author: Brad Chen Date: 06/04/2017
SQL Server Tools default Location
SQL Server Tools default Location SQL Server工具預設位置 Tools SQL Server versions Location sqlcmd.exe,...
Author: Brad Chen Date: 06/02/2017
SQL Server Managment Studio default locations
SQL Server Managment Studio default locations SQL Server Managment Studio 執行檔預設路徑與位置 SQL Server 2014...
Author: Brad Chen Date: 05/28/2017
重設遺失的sa密碼 How to reset forgotten sa password
How to reset forgotten sa password 如何重設sa密碼 或 忘記sa密碼的情況下加入一個SQL管理員帳戶 如果忘記sa密碼,有2個方法解決 方法一 不需要重啟SQL...
Author: Brad Chen Date: 05/27/2017
SQL Server Management Studio Keyboard Shortcuts
SQL Server Management Studio Keyboard Shortcuts 常用快速鍵 SQL Server Management Studio Keyboard...
Author: Brad Chen Date: 11/11/2016
SQL Server Physical Joins
SQL Server Physical Join (Nested Loops joins, Merge joins, Hash joins) Advanced Query Tuning...
Author: Brad Chen Date: 11/06/2016
Log Shipping Monitoring and Troubleshooting
Log Shipping Monitoring and Troubleshooting 交易紀錄傳送監控與疑難排解 1.Log Shipping status View the Log...
Author: Brad Chen Date: 10/15/2016
SQL Server Learning Resource
SQL Server 學習資源 中英文官方線上課程 Microsoft Virtual Academy Database Development Course...
Author: Brad Chen Date: 10/14/2016
File xxx.ps1 cannot be loaded because the execution of scripts is disabled on this system. Please see get-help about_signing
PS C:\Temp>.\myPS.ps1 C:\Temp\myPS.ps1 檔案無法載入,因為這個系統上已停用指令碼執行。如需詳細資訊,請參閱 "get-help...
Author: Brad Chen Date: 10/05/2016
Database Corruption Challenge - Steve Stedman
2016年9月13日 PASS Database Corruption Challenge - Steve Stedman Presented by Steve Stedman...
Author: Brad Chen Date: 09/28/2016
add text to beginning or end of each line using SSMS
1.Add text to the beginning of each line Ctrl+H type "^" in the "Find" type text you want to add in...
Author: Brad Chen Date: 09/21/2016
DBA Fundamentals-SQL Server Performance Tuning
2016/9/21 PASS online event DBA Fundamentals: SQL Server Performance Tuning Presented by Pinal Dave...
Author: Brad Chen Date: 09/20/2016
Distributed query vs OPENQUERY
Distributed query (Four-part name) and OPENQUERY OpenQuery Distributed Query 速度 一般來說 OPENQUERY較快一點...
Author: Brad Chen Date: 09/19/2016
SQL Server Performance study resources
SQL Server Performance study resources SQL Server效能-學習資源 查詢處理架構: Query Processing Architecture...
Author: Brad Chen Date: 09/07/2016
SQL Server 2008 R2 Performance Dashboard Reports
SQL Server 2008 R2 Performance Dashboard Reports SQL Server 2008 R2效能儀表板報表 Microsoft® SQL Server®...
Author: Brad Chen Date: 09/06/2016
設定收集效能計數器記錄檔,建立SQL Server 效能基準線Configure Performance Log collection for SQL Server Performance Baseline
Configure Performance Log collection for SQL Server Performance Baseline 設定收集效能計數器記錄檔,建立SQL Server...
Author: Brad Chen Date: 09/05/2016
SQL Server Rowset Trace
Rowset trace(Rowset Provider) Server-Side Trace with file provider(File Provider) 如果是Server-Side...
Author: Brad Chen Date: 09/03/2016
Visual Studio(SSDT BIDS) for SQL Server
Visual Studio(SSDT BIDS) for SQL Server SSDT: SQL Server Data Tool BIDS: Business Intelligence...
Author: Brad Chen Date: 09/01/2016
Delete large amount of data from a table
Delete large amount of data from a table 刪除大量資料作法 Method 1 若刪除完成之後留下的資料較多的話(例如要刪除1/3的資料),就用WHILE...
Author: Brad Chen Date: 08/30/2016
VBScript Common Constants
VBScript Common Constants 1.FileSystemObject 'For FileSystemObject Const ForWriting = 2 Const...
Author: Brad Chen Date: 08/30/2016
Microsoft VBScript
Microsoft VBScript resource VBScript相關資源 Quick Start: VBScript Operators...
Author: Brad Chen Date: 08/29/2016
Using SQL Server in Windows 8 and later versions of Windows operating system
Using SQL Server in Windows 8 and later versions of Windows operating system 在Windows...
Author: Brad Chen Date: 08/28/2016
Oracle Client for SQL Server
Oracle Client for SQL Server Oracle Client Support Windows version Document / Download Oracle 12c...
Author: Brad Chen Date: 05/25/2016
SQL Server and SQL Server Agent Service Account(Startup Account) and Permissions
SQL Server and SQL Server Agent service account(Startup Account) and Permissions SQL Server與SQL...
Author: Brad Chen Date: 07/24/2014
AlwaysOn Availability Groups learning resources
Overview of AlwaysOn Availability Groups (SQL Server)...
Author: Brad Chen Date: 06/18/2014
How to create a failover cluster
How to create a failover cluster 如何新增一個容錯移轉叢集 1.In the Failover Cluster Manager snap-in, confirm...
Author: Brad Chen Date: 06/18/2014
Query SQL Server backup history and restore history records
SQL Server備份還原紀錄 1.使用以下TSQL語法查詢備份檔紀錄 SELECT bs.backup_set_id, bs.database_name,...
Author: Brad Chen Date: 03/12/2014
Setting Up SQL Server 2008 R2 Database Mirroring in a Workgroup
1.Verify SQL Server service account and configure SQL Server Login for Database Mirroring (1)SQL...
Author: Brad Chen Date: 09/08/2013
Service Accounts and Database Mirroring
Service Accounts (Configure Database Mirroring Security...
Author: Brad Chen Date: 09/07/2013
Setting Up SQL Server 2008 R2 Database Mirroring with Certificate step by step in a Workgroup
Setting Up SQL Server 2008 R2 Database Mirroring with Certificate step by step in a Workgroup LAB VM...
Author: Brad Chen Date: 09/07/2013
Setting Up SQL Server 2008 R2 Log Shipping step by step
Setting Up SQL Server 2008 R2 Log Shipping step by step 1.Prerequisites (1)確認資料庫復原模式recovery...
Author: Brad Chen Date: 09/01/2013