Ken Wilson

DBA for @IntlPaperCo, and @AlabamaFTBL fan #rolltide!

[Ken Wilson @_KenWilson]

Blogged for the first time in a very long time. https://t.co/JUkjumzNgF

[Ken Wilson @_KenWilson]

Has anyone seen an issue with FILESTREAM access level runtime value reverting back to 0 after a reboot? This seems to be happening randomly in both 2014 and 2016. #sqlhelp

[Ken Wilson @_KenWilson]

@SQLHA @jdanton @sqlkfarlee Right now, no performance issues. I had seen our secondary replica get pretty far behind when transactional loads were high and index maintenance was occurring but stayed within acceptable limits. Just started looking at it and noticed the lack of compression. #sqlhelp

[Ken Wilson @_KenWilson]

I have a Availability Group with 2016 FCI and and a 2016 async secondary replica. According to Microsoft docs the log stream compressed by default for async replicas but I’m not seeing any compression. Trace 1462 is not on. Thoughts? #sqlhelp

[Ken Wilson @_KenWilson]

@SQLHA @jdanton We’re running EE on all replicas #sqlhelp

[Ken Wilson @_KenWilson]

@jdanton @SQLHA We are on build 13.0.5888 on all replicas. #sqlhelp

[Ken Wilson @_KenWilson]

@PASSDataSummit will there be recordings of all live sessions for each day?

[Ken Wilson @_KenWilson]

Has anyone experienced an issue with a linked server only allowing 99 rows to return when using Oracle 19c client? If more than 99 rows are returned we get “unexpected catastrophic failure” message and a stack dump. The dump shows a memory access violation. #sqlhelp

[Ken Wilson @_KenWilson]

@retracement LOL…ah man, you’re right!

[Ken Wilson @_KenWilson]

If TDE certs still work and can be used to restore the database if expired, why rotate them to keep them up-to-date? #sqlhelp

[Ken Wilson @_KenWilson]

@retracement Agreed. I will try not to call out my audit team for having missed this. It took a freaking out jr to call attention to it. #sqlhelp

[Ken Wilson @_KenWilson]

@MikeHardin63 @Poljarg @lilymanx @BOSSportsFan98 @repmorgan @andrewbostom We could probably go back and forth for a while but I will end with I would be cautious again to assume that all teachers new and existing can service their debt on their salary. Have a great night!

[Ken Wilson @_KenWilson]

@MikeHardin63 @Poljarg @lilymanx @BOSSportsFan98 @repmorgan @andrewbostom It’s not. I think you think I want student loan debt forgiveness to be a thing and I don’t. My only issues with the original tweet was with the insinuation that choosing debt for education is a bad decision. Your loan your responsibility, period.

[Ken Wilson @_KenWilson]

@MikeHardin63 @Poljarg @lilymanx @BOSSportsFan98 @repmorgan @andrewbostom Nevertheless there may be many extenuating circumstances as to why someone falls behind on student loan debt. The only person that can determine if the decision was good or bad is the one who made it. Doesn’t change the fact that this is bad legislation.

[Ken Wilson @_KenWilson]

@Poljarg @MikeHardin63 @lilymanx @BOSSportsFan98 @repmorgan @andrewbostom I can agree with that. I personally think that an art history degree is a waste of money especially if you incur debt to get it but I also don’t have the first clue what they extend to do with it so who am I to judge. I imagine the curators at the Louvre would think it isn’t.

[Ken Wilson @_KenWilson]

@Poljarg @MikeHardin63 @lilymanx @BOSSportsFan98 @repmorgan @andrewbostom Those that are paying realize that this legislation will be bad as it will greatly increase what we are already paying to pay for the ones that aren’t whether we are giving the opportunity to deny the forgiveness or not. 2/2

[Ken Wilson @_KenWilson]

Transaction log is 1.75 TB in simple recovery and you want me to add another log file? Hahahaha No!

[Ken Wilson @_KenWilson]

I have some SQL Server 2014 Express instances running on Windows 10 machines. Has anyone seen the 1909 upgrade cause the sa password to be cleared or reset? Just curious if it’s happened to anyone else. #slqhelp