Useful tips for everyday
When to use aggregate function in select statement? Because an aggregate function operates on a set of values, it is often used with the GROUP…
How do I reset my SharePoint homepage? In SharePoint designer, I was able to revert to the original homepage by doing the following: Navigate to…
How does session ticket resumption work in TLS? Session ticket resumption is designed to address this issue. The idea is simple: outsource session storage to…
How do I remove grub and keep windows? To remove it: Hit Windows + X and select Disk Management . Find the Ubuntu partition. It…
Why is a bool 1 byte? Because a byte is the smallest addressible unit in the language. You can use bit fields to get integers…
Can static libraries have dependencies? If a static library’s code contains references to some shared library items, these references will become dependencies in the resulting…
How to explore the relationship between continuous and categorical variables? One useful way to explore the relationship between a continuous and a categorical variable is…
How do you replace special characters in SQL query? DECLARE @s varchar(20) = ‘&®™+•·()’; SELECT. REPLACE(@s, CHAR(38), SPACE(0)), — & REPLACE(@s, CHAR(174), SPACE(0)), — ®…
How do I highlight a row in Excel with the same value? On Excel’s Home tab choose Conditional Formatting, Highlight Cells Rules, and then Duplicate…
How do you bond multiple Internet connections? If you have two or more wireless networks broadcasting from separate modems, you can connect them to your…