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失敗)...
Date: 07/23/2018
SQLNexus and RML Utilities (ReadTrace) - SQL Server效能分析工具
SQLNexus and RML Utilities (ReadTrace) - SQL Server效能分析工具 軟體下載與安裝方法 1.SQL Server Database Engine...
Date: 07/21/2018
What is ECMAScript ES (什麼是ECMAScript ES3,ES5)
What is ECMAScript ES (什麼是ECMAScript ES3,ES5) 1995年 Netscape...
Date: 07/12/2018
Use the Maintenance Plan Wizard (使用維護計畫精靈)
Use the Maintenance Plan Wizard (使用維護計畫精靈) 1.使用SSMS連線到SQL Server，在SQL Server...
Date: 07/08/2018
Frequently Asked Questions for PSSDiag Collection (PSSDiag收集常見問題)
Frequently Asked Questions for PSSDiag Collection (PSSDiag收集常見問題) Q1.如果你的SQL Server是在Windows...
Date: 07/07/2018
Windows Server Performance Tuning Guidelines
Windows Server Performance Tuning Guidelines OS Documents Windows 2016 Performance Tuning Guidelines...
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...
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...
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...
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...
Date: 04/24/2018
Cluster service verification failed
Cluster service verification failed 如果在Windows 2012 R2 failover cluster上安裝SQL Server 2008 R2...
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...
Date: 03/13/2018
複寫疑難排解 Replication Troubleshooting
複寫疑難排解 Replication Troubleshooting 從TLog讀取 sp_replcounters (Transact-SQL) Returns replication...
Date: 01/17/2018
複寫監控 Monitor Replication
複寫監控 Monitor Replication Measure Latency and Validate Connections for Transactional Replication...
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...
Date: 01/16/2018
Filter content in ERRORLOG log file過濾log檔案的內容
Filter content in ERRORLOG log file 過濾log檔案的內容...
Date: 11/09/2017
Use Hyper-V differencing disks
Use Hyper-V differencing disks 使用Hyper-V差異虛擬磁碟 現在安裝個Windows Server虛擬機器(VM)通常要10到20GB的磁碟空間，若再安裝SQL...
Date: 06/11/2017
Install Windows Server 2016
Install Windows Server 2016 安裝Windows 2016 1.如果是在Hyper-V的VM安裝windows 2016則會先出現這個畫面...
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...
Date: 06/04/2017
Virtual Machine software and image file
Virtual Machine host software 虛擬機器軟體與虛擬機器映像檔 1.Microsoft 微軟虛擬化軟體 Windows Virtualization Software...
Date: 06/04/2017
SQL Server Tools default Location
SQL Server Tools default Location SQL Server工具預設位置 Tools SQL Server versions Location sqlcmd.exe,...
Date: 06/02/2017
SQL Server Managment Studio default locations
SQL Server Managment Studio default locations SQL Server Managment Studio 執行檔預設路徑與位置 SQL Server 2014...
Date: 05/28/2017
重設遺失的sa密碼 How to reset forgotten sa password
How to reset forgotten sa password 如何重設sa密碼 或 忘記sa密碼的情況下加入一個SQL管理員帳戶 如果忘記sa密碼，有2個方法解決 方法一 不需要重啟SQL...
Date: 05/27/2017
SQL Server Management Studio Keyboard Shortcuts
SQL Server Management Studio Keyboard Shortcuts 常用快速鍵 SQL Server Management Studio Keyboard...
Date: 11/11/2016
SQL Server Physical Joins
SQL Server Physical Join (Nested Loops joins, Merge joins, Hash joins) Advanced Query Tuning...
Date: 11/06/2016
Log Shipping Monitoring and Troubleshooting
Log Shipping Monitoring and Troubleshooting 交易紀錄傳送監控與疑難排解 1.Log Shipping status View the Log...
Date: 10/15/2016
SQL Server Learning Resource
SQL Server 學習資源 中英文官方線上課程 Microsoft Virtual Academy Database Development Course...
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...
Date: 10/05/2016
Database Corruption Challenge - Steve Stedman
2016年9月13日 PASS Database Corruption Challenge - Steve Stedman Presented by Steve Stedman...
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...
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...
Date: 09/20/2016
Distributed query vs OPENQUERY
Distributed query (Four-part name) and OPENQUERY OpenQuery Distributed Query 速度 一般來說 OPENQUERY較快一點...
Date: 09/19/2016
SQL Server Performance study resources
SQL Server Performance study resources SQL Server效能-學習資源 查詢處理架構: Query Processing Architecture...
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®...
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...
Date: 09/05/2016
SQL Server Rowset Trace
Rowset trace(Rowset Provider) Server-Side Trace with file provider(File Provider) 如果是Server-Side...
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...
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...
Date: 08/30/2016
VBScript Common Constants
VBScript Common Constants 1.FileSystemObject 'For FileSystemObject Const ForWriting = 2 Const...
Date: 08/30/2016
Microsoft VBScript
Microsoft VBScript resource VBScript相關資源 Quick Start: VBScript Operators...
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...
Date: 08/28/2016
Oracle Client for SQL Server
Oracle Client for SQL Server Oracle Client Support Windows version Document / Download Oracle 12c...
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...
Date: 07/24/2014
AlwaysOn Availability Groups learning resources
Overview of AlwaysOn Availability Groups (SQL Server)...
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...
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,...
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...
Date: 09/08/2013
Service Accounts and Database Mirroring
Service Accounts (Configure Database Mirroring Security...
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...
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...
Date: 09/01/2013