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

Next>