Skip to content

Blog

Little SQL Server Tricks: Increase the Font Size in the Result Grid of SSMS

The SQL Server Management Studio (SSMS) has a simple way to increase the font size of your query. (You can select a value between 20% and 400% in the bottom of that window). But when you try to increase the font size in the result grid, you find nothing. We always have to guess what it says when we share our screens in a Teams meeting. Luckily, someone in my team found the way to fix that problem.

Lightweight Web Development on Your Local Machine

In the good old days doing web development was a lot simpler. We just open a HTML file from the local filesystem in our browser and the referenced CSS and JavaScript files where loaded as well. We could focus on getting our web site right without the need for a local server or any other infrastructure.

NDC Oslo 2020 - the Online Edition

We all wanted to be in Norway for NDC Oslo 2020, but Covid-19 made that impossible. As with most other conferences in 2020, there was no way to make this an in-person event. The NDC crew and Dylan Beattie did their best to create the typical NDC feeling at an online-only conference. I was surprised how well it worked and how few problems occurred for an event with around 1000 attendees.

Locate an Element Using a CSS Selector in Google Chrome

When you work with Pa11y you may get errors as I described in an earlier blog post:

1
2
3
4
Error: This element has insufficient contrast at this conformance level. Expected a contrast ratio of at least 4.5:1, but text in this element has a contrast ratio of 3.13:1. Recommendation:  change background to #0a8927.
   ├── WCAG2AA.Principle1.Guideline1_4.1_4_3.G18.Fail
   ├── html > body > div > div:nth-child(4) > div:nth-child(1) > div > div:nth-child(2) > a
   └── <a href="https://www.goodreads.com/user/show/26287713-johnny-graber" class="btn btn-success">More on Goodreads</a>

Improve the Accessibility of Your Web Application

Last month I attended the NDC Oslo 2020 online workshop Front End Web Fundamentals hosted by Amy Kapernick (@amys_kapers). In my first post on this workshop I wrote about the tools we used and resources that can help you to create better web applications.

Today I focus on accessibility. I am not an accessibility expert, yet the most errors you make are easy to find and do not need much time to fix. It will not replace an accessibility expert when you are required by law to follow certain levels, but it will make their work a lot simpler if the most common mistakes are already fixed.

The main reason to I wrote this post is to remember the different steps I had to take. Your challenges may be different, but if you follow the same structure, you should be able to tackle them as well.

Little SQL Server Tricks: Add New Columns With Default Value and Foreign Key

So far, I used separate statements to add a new column to a table, set a default value and add a foreign key relation to another table. However, we can do these 3 steps in one single command:

1
2
3
4
5
ALTER TABLE [Table Name] ADD
    [New Column Name] [Column Type] 
    CONSTRAINT [Constraint Name Default Value] DEFAULT ([Default Value]) NOT NULL,
    CONSTRAINT [Constraint Name Foreign Key] FOREIGN KEY ([New Column Name]) 
    REFERENCES [Other Table] ([Foreign Id])