Get beginning of the day datetime -aka today’s midnight – in T-SQL

By default I avoid putting any business logic into SQL. IMO it’s a good rule-of-thumb, but people often argue about it. I forget why it’s good rule, because I use it, but then every once for a while I need to put some little logic into SQL because it’s convenient, …

Group policy „Only allow local user profiles” – does not apply

My test environment has multiple virtual machines. Some of those machines are in a test sub-domain – it’s convenient to use my normal domain credentials to authenticate in test environment. I am also using roaming profile, and it’s inconvenient to have it all over test environment. There is nice GPO: …

Back to Top