[Video] Creepy Office Hours in Vancouver

While in a hotel room in Vancouver for PGconf.dev, I strapped on my Apple Vision Pro headset to take your top-voted questions from https://pollgab.com/room/brento. Somehow, the latest Vision OS update gave me a 1980s 3rd Bass haircut.

Here’s what we covered:

• 00:00 Start
• 01:03 MyTeaGotCold: Have you ever seen SSISDB migrated on to a new server without difficulty? I’ve never seen it go smoothly.
• 01:52 ThatSteveCena: https://www.sqlskills.com/blogs/jonat… Is the juice worth the squeeze to try individually tuning your index fill factors, or are there better means of performance gains?
• 02:40 Joseph: Getting a corrupt database message when running maintainance but the DB ID does not exist “DESCRIPTION: Corruption in database ID -4294967288, object ID 60 possibly due to schema or catalog inconsistency. Run DBCC CHECKCATALOG.” Have run DBCC Checks on all user and sys dbs.
• 04:05 TractorDBA: My friend’s security dept. decided that using the fallback cert is no longer good enough for internal network encryption. Security is not your thing, but is there a good resource who explains the ins and outs of certificate mgmt. for a large enterprise of SQL Servers?
• 04:50 SQL_Stormlight: GrumpyOldMan had a similar issue. SQL is recommending an index but it already exists and is being used. In my case, there are only two columns. I’ve tried swapping the column order and even tried different ASC/DESC yet SQL still wants this. Maybe it’s a bug or a bad rec?
• 05:45 aPartyPerson: My friend wonders if a View (with no WHERE and can’t be indexed due to bad life choices) used in a query could be replaced with a SP, and perform better. SELECT * FROM myV v WHERE v.typ = 1 SELECT * FROM OPENQUERY([LOCALSERVER], ‘SET FMTONLY OFF EXEC EXEC mySP @typ = 1’);
• 06:36 KyleDevDBA: Is dynamic SQL an acceptable way to add conditional joins/filters onto a query?
• 07:05 Ozan: Hi Brent, since MaxDOP can be set on DB level, is there still any reason why not to mix SharePoint with Non-SharePoint-DBs on the same SQL instance? Thanks
• 08:26 SQL_theocean: Was wondering which permission is required apart from db_owner in case the user wants to make his own database online after they make them offline in SQL server 2022.
• 09:36 MadridMoneky: We have AlwaysOn Availability Groups spanned across two data centers (~100 SQL Servers), one Data Center is migrating, unavailable for two weeks. How do we Manage the AGs? Do we have remove the DBs from the AG and reseed thousands of DBs when secondary is back online?
• 10:32 Richard at Analytic: Visual Studio Code vs Visual Studio. It appears that Microsoft is favoring Visual Studio Code over Visual Studio whenever there is no GUI or only an HTML UI associated with the project. What is your opinion on this?