4K resolution, AKA Ultra HD, refers to a horizontal screen display resolution in the order of approximately 3,840 pixels. On two-dimensional display devices such as computer monitors, it represents display resolution of 3840×2160 pixels which is four times as many pixels as regular Full High Definition (1920×1080). What this means for users is the more pixels per inch (PPI) the higher resolution on the monitor. In other words, you can be closer to the monitor and still enjoy a crisp, clear picture.
Basic concepts and terms
Just like hardware displays and form factors are an evolving technology, scaling in Windows has been evolving over the last several years with great improvements in the latest Windows 10. From a developer’s perspective, this represents a big challenge. But from a user’s perspective scaling only matters because Windows and your apps will run on a lot of diverse monitors. Diverse in many ways like size, resolution, density, viewing distance, etc.
Physical pixels are the dots making up the screen: the smallest parts of the screen that can be lit up.
- Physical pixels (red squares below) are smaller on denser screens
- Physical resolutions (light grey text below) are larger on denser screens and on larger screens
Effective pixels are abstract units of the display; each one represents a block of physical pixels.
- Effective pixels (red squares below) are the same size on all screens
- Effective resolutions (light grey text below) are larger on larger screens, not on denser screens
In terms of resolution, we could be looking at a phone with low resolution and up to a 4K or even a 5K monitor that people are starting to switch over, so there we have a 6:1 ratio in size and capable of growing in the future. There’s is an insane diversity, if you’re thinking from a developer perspective, and there’s no way in a world you can target each of these different elements and the entire range of each one. Therefore, Microsoft provides DPI scaling AKA density/display scaling and it abstracts much of this complexity.
The scale factor is the ratio between the size of an effective and a physical pixel; it is the ratio by which operating system scales the UI so that effective pixels are the same size on all displays.
- It also equals the ratio between the physical resolution and the effective resolution
- The scale factor is in an approximation to the “ideal” scale factor; to keep things simple scale values are rounded up or down to a small number of Windows supported values
From the user’s point of view, we get reliably-sized visuals and the content looks reasonably the same on all different devices right out the box without the need for any user interaction. This applies to a majority of Microsoft products just by sticking to the default (Recommended) settings.
Even though SQL Server Management Studio (SSMS) is Microsoft’s product, it still doesn’t support the 4K resolution and high DPI. However, there’s beta support for 2016 and 17 versions to fix the application elements such as the taskbar, icons, toolbars, text, and dialog boxes that appear to be fuzzy. By default, this beta support is disabled but you could check out an article on how to enable High-DPI in SSMS and learn more about tips, tricks, and known issues.
To see how we’ve implemented 4K/High resolution in our products, see this article: 4K resolution and high-DPI scaling support in ApexSQL tools/add-ins.
- CREATE VIEW SQL: Working with indexed views in SQL Server - March 24, 2020
- CREATE VIEW SQL: Inserting data through views in SQL Server - March 16, 2020
- CREATE VIEW SQL: Modifying views in SQL Server - March 5, 2020