4K resolution and high DPI: What you need to know about it to ...

4K resolution, AKA Ultra HD, refers to a horizontal screen display resolution in the order of approximately 3,840 pixels. 4Kresolution,AKAUltraHD,referstoahorizontalscreendisplayresolutionintheorderofapproximately3,840pixels.Ontwo-dimensionaldisplaydevicessuchascomputermonitors,itrepresentsdisplayresolutionof3840×2160pixelswhichisfourtimesasmanypixelsasregularFullHighDefinition(1920×1080).Whatthismeansforusersisthemorepixelsperinch(PPI)thehigherresolutiononthemonitor.Inotherwords,youcanbeclosertothemonitorandstillenjoyacrisp,clearpicture. Comparisonofcommonmonitorresolutions Basicconceptsandterms Justlikehardwaredisplaysandformfactorsareanevolvingtechnology,scalinginWindowshasbeenevolvingoverthelastseveralyearswithgreatimprovementsinthelatestWindows10.Fromadeveloper’sperspective,thisrepresentsabigchallenge.Butfromauser’sperspectivescalingonlymattersbecauseWindowsandyourappswillrunonalotofdiversemonitors.Diverseinmanywayslikesize,resolution,density,viewingdistance,etc. Physicalpixels Physicalpixelsarethedotsmakingupthescreen:thesmallestpartsofthescreenthatcanbelitup. Physicalpixels(redsquaresbelow)aresmallerondenserscreens Physicalresolutions(lightgreytextbelow)arelargerondenserscreensandonlargerscreens EffectivePixels Effectivepixelsareabstractunitsofthedisplay;eachonerepresentsablockofphysicalpixels. Effectivepixels(redsquaresbelow)arethesamesizeonallscreens Effectiveresolutions(lightgreytextbelow)arelargeronlargerscreens,notondenserscreens Intermsofresolution,wecouldbelookingataphonewithlowresolutionanduptoa4Korevena5Kmonitorthatpeoplearestartingtoswitchover,sotherewehavea6:1ratioinsizeandcapableofgrowinginthefuture.There’sisaninsanediversity,ifyou’rethinkingfromadeveloperperspective,andthere’snowayinaworldyoucantargeteachofthesedifferentelementsandtheentirerangeofeachone.Therefore,MicrosoftprovidesDPIscalingAKAdensity/displayscalinganditabstractsmuchofthiscomplexity. Scalefactor Thescalefactoristheratiobetweenthesizeofaneffectiveandaphysicalpixel;itistheratiobywhichoperatingsystemscalestheUIsothateffectivepixelsarethesamesizeonalldisplays. Italsoequalstheratiobetweenthephysicalresolutionandtheeffectiveresolution Thescalefactorisinanapproximationtothe“ideal”scalefactor;tokeepthingssimplescalevaluesareroundedupordowntoasmallnumberofWindowssupportedvalues Scalefactorsfortheexamplesaboveareshownhere Fromtheuser’spointofview,wegetreliably-sizedvisualsandthecontentlooksreasonablythesameonalldifferentdevicesrightouttheboxwithouttheneedforanyuserinteraction.ThisappliestoamajorityofMicrosoftproductsjustbystickingtothedefault(Recommended)settings. Windows10displaysettingsona15.6-inch4Kdisplay EventhoughSQLServerManagementStudio(SSMS)isMicrosoft’sproduct,itstilldoesn’tsupportthe4KresolutionandhighDPI.However,there’sbetasupportfor2016and17versionstofixtheapplicationelementssuchasthetaskbar,icons,toolbars,text,anddialogboxesthatappeartobefuzzy.Bydefault,thisbetasupportisdisabledbutyoucouldcheckoutanarticleonhowtoenableHigh-DPIinSSMSandlearnmoreabouttips,tricks,andknownissues. SSMSon4Kresolutionwithinitialhigh-resolutionmonitorsupportdisabled/enabled Toseehowwe’veimplemented4K/Highresolutioninourproducts,seethisarticle:4Kresolutionandhigh-DPIscalingsupportinApexSQLtools/add-ins. AuthorRecentPostsBojanPetrovicBojanaka“Boksi”,anAPgraduateinITTechnologyfocusedonNetworksandelectronictechnologyfromtheCopenhagenSchoolofDesignandTechnology,isasoftwareanalystwithexperienceinqualityassurance,softwaresupport,productevangelism,anduserengagement.HehaswrittenextensivelyonboththeSQLShackandtheApexSQLSolutionCenter,ontopicsrangingfromclienttechnologieslike4Kresolutionandtheming,errorhandlingtoindexstrategies,andperformancemonitoring.BojanworksatApexSQLinNis,Serbiaasanintegralpartoftheteamfocusingondesigning,developing,andtestingthenextgenerationofdatabasetoolsincludingMySQLandSQLServer,andbothstand-alonetoolsandintegrationsintoVisualStudio,SSMS,andVSCode.SeemoreaboutBojanatLinkedInViewallpostsbyBojanPetrovicLatestpostsbyBojanPetrovic(seeall) VisualStudioCodeforMySQLandMariaDBdevelopment-August13,2020 SQLUPDATEsyntaxexplained-July10,2020 CREATEVIEWSQL:WorkingwithindexedviewsinSQLServer-March24,2020 Relatedposts: HowtoenableHigh-DPIinSSMS(SQLServerManagementStudio)–Tips,tricksandissues ConfiguringaSQLServerAlwaysOnHighAvailabilityGroup AgreattooltocreateSQLServerindexes DomainControllerandDomainClientNodesetupforAlwaysONHighAvailability DTA,agreattooltoautomateindexes 23,716Views Followus! Popular DifferentwaystoSQLdeleteduplicaterowsfromaSQLTable SQLConvertDatefunctionsandformats SQLPARTITIONBYClauseoverview HowtoUPDATEfromaSELECTstatementinSQLServer SQLWHILEloopwithsimpleexamples LearnSQL:Joinmultipletables SQLVariables:Basicsandusage SQLServertablehints–WITH(NOLOCK)bestpractices HowtobackupandrestoreMySQLdatabasesusingthemysqldumpcommand CASEstatementinSQL SQLmultiplejoinsforbeginnerswithexamples SQLServerfunctionsforconvertingaStringtoaDate WhatisthedifferencebetweenClusteredandNon-ClusteredIndexesinSQLServer? SQLNotEqualOperatorintroductionandexamples TheTableVariableinSQLServer DELETECASCADEandUPDATECASCADEinSQLServerforeignkey Multipleoptionstotransposingrowsintocolumns SQLServerTransactionLogBackup,TruncateandShrinkOperations HowtoimplementerrorhandlinginSQLServer INSERTINTOSELECTstatementoverviewandexamples Trending SQLServerTransactionLogBackup,TruncateandShrinkOperations SixdifferentmethodstocopytablesbetweendatabasesinSQLServer HowtoimplementerrorhandlinginSQLServer WorkingwiththeSQLServercommandline(sqlcmd) MethodstoavoidtheSQLdividebyzeroerror QueryoptimizationtechniquesinSQLServer:tipsandtricks HowtocreateandconfigurealinkedserverinSQLServerManagementStudio SQLreplace:HowtoreplaceASCIIspecialcharactersinSQLServer HowtoidentifyslowrunningqueriesinSQLServer SQLvarchardatatypedeepdive Howtoimplementarray-likefunctionalityinSQLServer AllaboutlockinginSQLServer SQLServerstoredproceduresforbeginners DatabasetablepartitioninginSQLServer HowtodroptemptablesinSQLServer HowtodeterminefreespaceandfilesizeforSQLServerdatabases UsingPowerShelltosplitastringintoanarray KILLSPIDcommandinSQLServer HowtoinstallSQLServerExpressedition SQLUnionoverview,usageandexamples Solutions ReadaSQLServertransactionlog SQLServerdatabaseauditingtechniques HowtorecoverSQLServerdatafromaccidentalUPDATEandDELETEoperations HowtoquicklysearchforSQLdatabasedataandobjects SynchronizeSQLServerdatabasesindifferentremotesources RecoverSQLdatafromadroppedtablewithoutbackups Howtorestorespecifictable(s)fromaSQLServerdatabasebackup RecoverdeletedSQLdatafromtransactionlogs HowtorecoverSQLServerdatafromaccidentalupdateswithoutbackups AutomaticallycompareandsynchronizeSQLServerdata OpenLDFfileandviewLDFfilecontent QuicklyconvertSQLcodetolanguage-specificclientcode HowtorecoverasingletablefromaSQLServerdatabasebackup RecoverdatalostduetoaTRUNCATEoperationwithoutbackups HowtorecoverSQLServerdatafromaccidentalDELETE,TRUNCATEandDROPoperations RevertingyourSQLServerdatabasebacktoaspecificpointintime HowtocreateSSISpackagedocumentation MigrateaSQLServerdatabasetoanewerversionofSQLServer HowtorestoreaSQLServerdatabasebackuptoanolderversionofSQLServer Categoriesandtips ►Auditingandcompliance(50) Auditing(40) Dataclassification(1) Datamasking(9) Azure(241) AzureDataStudio(39) Backupandrestore(107) ▼BusinessIntelligence(462) AnalysisServices(SSAS)(47) Biml(10) DataMining(14) DataQualityServices(4) DataTools(SSDT)(13) DataWarehouse(14) Excel(20) General(39) IntegrationServices(SSIS)(125) MasterDataServices(6) OLAPcube(15) PowerBI(84) ReportingServices(SSRS)(64) Datascience(21) ►Databasedesign(214) Clustering(16) CommonTableExpressions(CTE)(10) Concurrency(1) Constraints(8) Datatypes(11) FILESTREAM(20) Generaldatabasedesign(95) Partitioning(13) Relationshipsanddependencies(12) Temporaltables(12) Views(16) ►Databasedevelopment(392) Comparison(4) Continuousdelivery(CD)(5) Continuousintegration(CI)(11) Development(136) Functions(101) Hyper-V(1) Search(10) SourceControl(15) SQLunittesting(23) Storedprocedures(32) StringConcatenation(2) Synonyms(1) TeamExplorer(2) Testing(34) VisualStudio(14) DBAtools(35) DevOps(23) DevSecOps(2) Documentation(20) ETL(68) ►Features(212) Adaptivequeryprocessing(11) Bulkinsert(16) Databasemail(10) DBCC(7) ExperimentationAssistant(DEA)(3) HighAvailability(35) Querystore(10) Replication(40) Transactionlog(59) TransparentDataEncryption(TDE)(21) Importing,exporting(46) Installation,setupandconfiguration(112) Jobs(42) ►Languagesandcoding(666) Cursors(9) DDL(9) DML(5) JSON(17) PowerShell(77) Python(35) R(16) SQLcommands(192) SQLCMD(7) Stringfunctions(20) T-SQL(264) XML(15) Lists(12) Machinelearning(37) Maintenance(97) Migration(50) Miscellaneous(1) ►Performancetuning(824) Alerting(8) AlwaysOnAvailabilityGroups(81) BufferPoolExtension(BPE)(9) Columnstoreindex(9) Deadlocks(16) Executionplans(115) In-MemoryOLTP(22) Indexes(78) Latches(5) Locking(10) Monitoring(91) Performance(184) Performancecounters(28) PerformanceTesting(9) Queryanalysis(110) Reports(20) SSASmonitoring(3) SSISmonitoring(10) SSRSmonitoring(4) Waittypes(11) ►Professionaldevelopment(66) Professionaldevelopment(26) Projectmanagement(9) SQLinterviewquestions(31) Recovery(32) Security(83) Servermanagement(21) SQLAzure(254) SQLServerManagementStudio(SSMS)(87) SQLServeronLinux(11) ►SQLServerversions(169) SQLServer2012(6) SQLServer2016(63) SQLServer2017(49) SQLServer2019(50) SQLServer2022(1) ►Technologies(303) AWS(45) AWSRDS(55) AzureCosmosDB(22) Containers(11) Docker(8) Graphdatabase(13) Kerberos(2) Kubernetes(1) Linux(40) LocalDB(2) MySQL(49) Oracle(9) PolyBase(10) PostgreSQL(20) SharePoint(4) Ubuntu(12) Uncategorized(2) Utilities(21) Helpersandbestpractices BIperformancecounters SQLcodesmellsrules SQLServerwaittypes  ©2021QuestSoftwareInc.ALLRIGHTSRESERVED. | GDPR | TermsofUse | Privacy