SQL Tact

What's New in SQL 2019? at BRSSUG

• by Will Assaf

• SQL Tact

Thanks to everyone who joined the BRSSUG for a night all about SQL Server 2019! We got off into tangents and use cases for Big Data Clusters, columnstore, graph...

2019-11-14

39 reads

Tips to build a your-departure-proof leadership team in your tech community

• by Will Assaf

• SQL Tact

This is a fairly poignant issue for many technical community leaders who feel alone in what can be a thankless job. Let's talk about some guidance and tips for...

2019-11-05

5 reads

The SQLSaturday pitch to host facilities

• by Will Assaf

• SQL Tact

Not being able to find a good, affordable venue to host a SQLSaturday is a show-stopping problem that is common to a lot of events, especially SQLSaturdays getting started...

2019-11-15 (first published: 2019-11-05)

174 reads

Why I Am Running for PASS Board of Directors

• by Will Assaf

• SQL Tact

I am on the 2019 slate of candidates to run for the PASS Board of Directors, and am looking forward to the process, the opportunity, and the outcome.Regardless of...

2019-11-01

2 reads

Availability Groups: What to do without MultiSubNetFailover = True

• by Will Assaf

• SQL Tact

I received an email from a client who is having issues with third-party applications connecting to their three-subnet SQL Server Availability Group. After an exchange with Microsoft Support, they...

2019-11-11 (first published: 2019-10-31)

476 reads

Idera GeekSync: SQL Security Principals and Permissions 101

• by Will Assaf

• SQL Tact

Thanks to Idera and all 239 of you who joined the Idera GeekSync webinar today for my topic on SQL Security Principals and Permissions 101.Fun fact: Principals and Principles have...

2019-10-23

23 reads

SSIS Scaleout: Cannot open certificate store on the machine

• by Will Assaf

• SQL Tact

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:...

2019-11-04 (first published: 2019-10-22)

218 reads

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

• by Will Assaf

• SQL Tact

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...

2019-10-11

19 reads

GroupBy: SQL Server Admin Best Practices with DMV's

• by Will Assaf

• SQL Tact

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,...

2019-10-10

42 reads

SQL Server Admin Best Practices with DMV's at GroupBy

• by Will Assaf

• SQL Tact

Excited to be presenting at virtual GroupBy Conference for the first time on Thursday, during the North America time slots. I just finished tuning up this old presentation that I've presented...

2019-10-08

27 reads