Modernize on SQL Server 2019 Q & A [PASS DBA Fundamentals VG Webinar]

%3CLINGO-SUB%20id%3D%22lingo-sub-725317%22%20slang%3D%22en-US%22%3EModernize%20on%20SQL%20Server%202019%20Q%20%26amp%3B%20A%20%5BPASS%20DBA%20Fundamentals%20VG%20Webinar%5D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-725317%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Folks!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you%20so%20much%20to%20those%20of%20you%20who%20attended%20yesterday's%20webinar%20Modernize%20on%20SQL%20Server%202019!%20We%20did%20not%20have%20time%20for%20Q%26amp%3BA%2C%20so%20I've%20collected%20the%20questions%20and%20answers%20here.%20Feel%20free%20to%20comment%20with%20any%20additional%20questions%20you%20may%20have%20and%20I'll%20be%20happy%20to%20answer%20them.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3EWhat%20is%20the%20link%20to%20your%20site%3F%3C%2FSTRONG%3E%3CBR%20%2F%3EMost%20everything%20we%20present%20can%20be%20found%20at%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Ftigertoolbox%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Ftigertoolbox%3C%2FA%3E%20You%20can%20find%20all%20our%20presentations%20and%20demos%20under%20the%20%22Sessions%22%20folder%2C%20as%20well%20as%20other%20useful%20tools%20and%20scripts.%20You%20can%20also%20find%20our%20blog%20at%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fsqlserverteam%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Fsqlserverteam%3C%2FA%3E%2C%20or%20by%20clicking%20on%20%22Blogs%22%20here%20on%20the%20TechCommunity%20site.%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%3CSTRONG%3EIs%20there%20a%20timeline%20for%20the%20Common%20Criteria%20%5Bsecurity%20settings%5D%20to%20be%20released%20to%203rd%20parties%20so%20that%20they%20can%20independently%20certify%20SQL2019%20from%20a%20security%20standpoint%3F%26nbsp%3B%20We%20are%20still%20awaiting%20the%20release%20of%20these%20for%20SQL2017....after%20years%20of%20availability.%3C%2FSTRONG%3E%3CBR%20%2F%3E%3C%2FFONT%3EThere%20isn't%20a%20specific%20timeline%20for%20this%2C%20but%20it%20will%20be%20completed%20as%20soon%20as%20possible.%20SQL%202017%20certification%20was%20delayed%20due%20to%20defects%20that%20needed%20to%20be%20corrected%20as%20well%20as%20some%20documentation%20issues.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3ECurrently%20the%20Microsoft%20provided%20SQL%20maintenance%20plans%20do%20not%20have%20settings%20for%20online%2C%20pause-able%20index%20maintenance.%20With%20the%20new%20capabilities%20being%20advertised%2C%20will%20these%20make%20it%20into%20maintenance%20plans%3F%3C%2FSTRONG%3E%3CBR%20%2F%3ENo%20plans%20for%20this.%20We%20generally%20recommend%20using%20some%20sort%20of%20smart%20script%20such%20as%20Adaptive%20Index%20Defrag%20(%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Faid%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Faid%3C%2FA%3E)%2C%20for%20maintenance%20rather%20than%20a%20standard%20maintenance%20plan.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EFor%20Azure%20SQL%20as%20a%20service%20can%20the%20database%20compatibility%20be%20set%20to%20150%20to%20get%20some%20of%20the%202019%20features%3F%3C%2FSTRONG%3E%3CBR%20%2F%3EYes%2C%20you%20can%20choose%20compatibility%20150%20now!%20It%20is%20not%20yet%20the%20default%2C%20but%20it%20is%20an%20option.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Microsoft

Hi Folks!

 

Thank you so much to those of you who attended yesterday's webinar Modernize on SQL Server 2019! We did not have time for Q&A, so I've collected the questions and answers here. Feel free to comment with any additional questions you may have and I'll be happy to answer them.

 

  • What is the link to your site?
    Most everything we present can be found at https://aka.ms/tigertoolbox You can find all our presentations and demos under the "Sessions" folder, as well as other useful tools and scripts. You can also find our blog at https://aka.ms/sqlserverteam, or by clicking on "Blogs" here on the TechCommunity site.
  • Is there a timeline for the Common Criteria [security settings] to be released to 3rd parties so that they can independently certify SQL2019 from a security standpoint?  We are still awaiting the release of these for SQL2017....after years of availability.
    There isn't a specific timeline for this, but it will be completed as soon as possible. SQL 2017 certification was delayed due to defects that needed to be corrected as well as some documentation issues.
  • Currently the Microsoft provided SQL maintenance plans do not have settings for online, pause-able index maintenance. With the new capabilities being advertised, will these make it into maintenance plans?
    No plans for this. We generally recommend using some sort of smart script such as Adaptive Index Defrag (https://aka.ms/aid), for maintenance rather than a standard maintenance plan.
  • For Azure SQL as a service can the database compatibility be set to 150 to get some of the 2019 features?
    Yes, you can choose compatibility 150 now! It is not yet the default, but it is an option.