The Curious Engineer

All blogs / Databases

Brad Chen's SQL Server Blog

learn.microsoft.com/en-us/archive/blogs/bradchen

MS, SQL Server Support, Guidelines, Performance, Tips, Troubleshooting

DatabasesDevOps / SRE / infrastructureMicrosoft blogsMSDN archive

’15’20’25
Posts
87 from 15 Dec 2012 to 23 Jul 2018
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/bradchen/feed.xml

2018 15

  1. workaround for SQLNexus fail to import SQL 2016 trc file(SQLNexus ReadTrace匯入sql 2016 trc失敗)
  2. SQLNexus and RML Utilities (ReadTrace) - SQL Server效能分析工具
  3. What is ECMAScript ES (什麼是ECMAScript ES3,ES5)
  4. Use the Maintenance Plan Wizard (使用維護計畫精靈)
  5. Frequently Asked Questions for PSSDiag Collection (PSSDiag收集常見問題)
  6. Windows Server Performance Tuning Guidelines
  7. The distribution agent failed to create temporary files in xxx directory. System returned errorcode 5 散發代理程式建立暫存檔失敗
  8. Replication Log Reader Agent Error "The principal dbo does not exist" 複寫記錄讀取器代理程式出現主體dbo不存在
  9. Guideline for SQL Server configuration, installation and database creation
  10. SQL Server Reporting Services failed to start (Reporting Services啟動失敗)
  11. Cluster service verification failed
  12. Install SQL 2017 CU4 non-English locale without internet access(離線安裝SQL 2017 CU4)
  13. 複寫疑難排解 Replication Troubleshooting
  14. 複寫監控 Monitor Replication
  15. SQL Server 2008 R2 Management Studio – Darker Shades of Blue Theme

2017 8

  1. Filter content in ERRORLOG log file過濾log檔案的內容
  2. Use Hyper-V differencing disks
  3. Install Windows Server 2016
  4. Create a template VM and Create a new VM from template VM
  5. Virtual Machine software and image file
  6. SQL Server Tools default Location
  7. SQL Server Managment Studio default locations
  8. 重設遺失的sa密碼 How to reset forgotten sa password

2016 19

  1. SQL Server Management Studio Keyboard Shortcuts
  2. SQL Server Physical Joins
  3. Log Shipping Monitoring and Troubleshooting
  4. SQL Server Learning Resource
  5. File xxx.ps1 cannot be loaded because the execution of scripts is disabled on this system. Please see get-help about_signing
  6. Database Corruption Challenge - Steve Stedman
  7. add text to beginning or end of each line using SSMS
  8. DBA Fundamentals-SQL Server Performance Tuning
  9. Distributed query vs OPENQUERY
  10. SQL Server Performance study resources
  11. SQL Server 2008 R2 Performance Dashboard Reports
  12. 設定收集效能計數器記錄檔，建立SQL Server 效能基準線Configure Performance Log collection for SQL Server Performance Baseline
  13. SQL Server Rowset Trace
  14. Visual Studio(SSDT BIDS) for SQL Server
  15. Delete large amount of data from a table
  16. VBScript Common Constants
  17. Microsoft VBScript
  18. Using SQL Server in Windows 8 and later versions of Windows operating system
  19. Oracle Client for SQL Server

2014 4

  1. SQL Server and SQL Server Agent Service Account(Startup Account) and Permissions
  2. AlwaysOn Availability Groups learning resources
  3. How to create a failover cluster
  4. Query SQL Server backup history and restore history records

2013 26

  1. Setting Up SQL Server 2008 R2 Database Mirroring in a Workgroup
  2. Service Accounts and Database Mirroring
  3. Setting Up SQL Server 2008 R2 Database Mirroring with Certificate step by step in a Workgroup
  4. Setting Up SQL Server 2008 R2 Log Shipping step by step
  5. Setting Up SQL Server 2008 R2 Database Mirroring step by step
  6. Burn an ISO image to physical DVD media with Windows 2008 R2 build-in tool "isoburn.exe"
  7. Microsoft Office Access Performance Tuning Guide
  8. Recovering a SQL Server cluster group and resources
  9. 指定本地快照目錄來改善初始化時間 Apply snapshot from Alternate folder to improve performance when initialize a Subscription in Transactional Replication
  10. Windows 2012 Failover Cluster Management Console Error "A weak Event was created and it lives on the wrong object"
  11. Quick to build a testing web site to access SQL Server
  12. Install SharePoint 2010 and initial configuration(SharePoint Products Configuration Wizard)
  13. Install and Setup Reporting Service with SharePoint Integration
  14. Install SQL Server 2012 Failover Cluster with Command Line and Configuration File
  15. Install SQL Server 2012 with command line
  16. Setup SQL Server 2012 AlwaysOn Availability Groups using Certificate
  17. Setup SQL Server 2012 AlwaysOn Availability Groups using Join Only
  18. Setup SQL Server 2012 AlwaysOn Availability Groups using Skip initial data synchronization
  19. Quick Setup a SQL Server 2012 AlwaysOn Availability Groups
  20. Remove a crash SQL Cluster Node and add new SQL Cluster Node back to exist SQL Cluster
  21. Manage a SQL Server failover cluster from command line or powershell
  22. AD account permission required for SQL Server failover Cluster Installation
  23. SQL Server 2012 certifications
  24. Build a two-node SQL Server 2008 R2 Cluster with iSCSI
  25. Add a node to an existing two-node SQL Server 2008 R2 Cluster
  26. SQL Server 2012 Installing on Windows Server 2012, Error while enabling Windows feature : NetFx3, Error Code : –2146498298

2012 15

  1. How to Rename SQL Server Cluster Virtual Server Name(Network name)
  2. SQL Server 2012 Installation fail "Managed SQL Server Installer has stopped working"
  3. 不允許儲存變更saving changes is not permitted
  4. 使用一句SQL INSERT多筆Record(multiple values)
  5. SQL Server 2008 Installation on Vista Business Edition(在Vista安裝SQL Server 2008)
  6. SQL Server 2008 與SQL Server 2005 Sample Databases範例資料庫下載與安裝
  7. 立即中斷所有SQL Server連線
  8. SQLDiag工具程式Bug-Buffer overrun detected
  9. SQLDiag工具程式的使用
  10. SQL 2000 Determine primary key from system table 列出所有Primary Key
  11. Listing space used information in each database files
  12. SQL Server 2000 xp_cmdshell移除與回復
  13. 錯誤22002:RegCreateKeyEx()傳回錯誤5,存取被拒(Microsoft SQL-DMO ODBC SQL狀態: 42000)
  14. Good SQL Server Blogs
  15. My old blog