Monday, October 21, 2019

SSIS Scaleout: Cannot open certificate store on the machine

When attempting to connect a worker node to the current Master node of a SQL Server Integration Services (SSIS) Scaleout, for on-prem SQL Servers, if you receive the error:

Validation Error(s):
Cannot open certificate store on the machine

First off, launch SSMS on the SQL Server instance you intend to be the master. The steps to troubleshoot start with the two steps here:
https://docs.microsoft.com/en-us/sql/integration-services/scale-out/troubleshooting-scale-out#cannot-open-certificate-store

"1. Run Scale Out Manager as administrator. If you open Scale Out Manager with SSMS, you have to run SSMS as administrator.
2. Start the Remote Registry service on the computer if it is not running."
3. Finally, if you are trying to add a named instance, there is one more gotcha. The Scaleout Worker is the server name not the SQL Instance name. Do not provide the full named instance name, for example, "SQLSERVER-1\INSTANCENAME", only provide the server name, in this case, "SQLSERVER-1".





Thursday, October 10, 2019

"Think Like a Certification Exam" at the PASS Marathon!

Thanks to the 56 of you who joined and actively answered my nerdy sample cert exam questions in the #PASSMarathon webinar "Think Like a Certification Exam" today. Ya'll had way too much fun answering those things, it was a fun and fulfilling experience to share with the community!
I had a lot of fun presenting both GroupBy and PASS Marathon webinars today, it is certainly a different experience to interact with your audience via the chat box but we made it work and had a lot of fun! Thanks to all of you who participated!

GroupBy: SQL Server Admin Best Practices with DMV's

Thanks for the 40+ of you online for GroupBy 2019 North America, excited to have presented my DMV session for the audience.

Big shoutout to Bob Pusateri's fantastic preceding presentation, which I hadn't seen before, on Locks, Blocks, and Snapshots, that was masterful explanation of the concepts. Thanks also Jeremy Alexander for being GroupBy's v-jay/video moderator/streaming host for entertaining!

Slidedeck: https://github.com/williamadba/Public-Presentations/blob/master/GroupBy%20Conference%202019/DBA%20Best%20Practices%20with%20DMVs.pptx

Toolbox: https://github.com/sparkhoundsql/sql-server-toolbox