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)
293 reads
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
4 reads
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
31 reads
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
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
87 reads
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
35 reads
Join me for my new webinar "Think Like a Certification Exam" at #PASSmarathon taking place on October 10!One of my favorite non-technical presentations to give explains how and why...
2019-10-01
66 reads
It was awesome to see a great crowd at the triumphant return of Houston Tech Fest 2019. This year's event was hosted at the beautiful Microsoft Office in Houston....
2019-09-14
8 reads
Great attendance and great meeting last night for the September '19 BRSSUG meeting, great to see lots of new faces at the meeting following our successful SQLSaturday event in...
2019-09-12
23 reads
Some 2019 tips for other SQLSat organizers from my last year as lead organizer of SQLSatBR. I hope as a fellow organizer, you can pull some ideas and inspiration...
2019-09-06 (first published: 2019-08-21)
344 reads
By Steve Jones
It’s the eve of the Fourth of July, when the Declaration of Independence is...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
By John
No, not that kind of volume! Over the past couple of blog posts, I...
To shorten a long story, my organisation has decided to have a vendor...
Hi everyone, W are just doing a migration from sql 2012 enterprise to sql...
Or should I explicitly specify 'CREATE UNIQUE CLUSTERED COLUMNSTORE INDEX....' ? If I don't...
Ask SSC