Just creating some new dbachecks containers with SQL2022 as well as SQL2019 from dbatools containers.
I'm too lazy to create new things so I copied it all with dbatools 😃
My favorite way for a quick tempdb check, is to use the Test-DbaTempDbConfig command in dbatools. Use the command below, replacing the name of the instance with the instance name you’re interested in.
Test-DbaTempDbConfig -SqlInstance sql2019 | format-table -Wrap
We were never able to dig in to this before because of the older version of SQL, but now on SQL2019 there are a bunch more tools available to track this stuff, it's interesting, but overwhelming to a non-DBA
#sqlhelp Looking for info on transactional replication DOWNSIDES, bad experiences, post-mortem write-ups. Bad stuff only, legitimate problems that made folks stop using it. I want to investigate before I propose it, expecting resistance/opposition. SQL2019 if that helps. Thanks.
#sqlhelp My IT Security team has flagged ALL SQL servers as having a "SQL 2012 Component". This appears to be due to SQL Native Client 11 being installed. They flagged since SQL2012 will be unsupported soon, even on fresh SQL2019. Thoughts on how to (of if we should) remediate?
On SQL2019 there is a folder "C:\Program Files\Microsoft SQL Server\150\DTS\Extensions\Common" with an old log4j library. Any idea where it belongs to? Which component is using this? Polybase? #sqlhelp#sqlfamily
Is SQL Server Reporting Services missing after you’ve installed #SQL2019? 🕵️ That’s because the 2019 edition has changed it up quite a bit. Read how to install #SSRS and the difference with previous versions in our blog now!
kohera.be/sql-server/sql-ser…
IT Pros, You ready for the final (Part 3) post in my Windows Server 2022 Series? I upgrade my Windows Admin Center to 2022, upgrade a WS2019 server running SQL2019 to 2022, and then upgrade SharePoint Server SE Preview to 2022! It all worked! :) #Petripetri.com/windows-server-202…