Skip to content

Instantly share code, notes, and snippets.

View sql-sith's full-sized avatar

Chris Leonard sql-sith

  • principal domains data architect at godaddy
  • cedar rapids, iowa, usa
  • X @databaseguy
View GitHub Profile

Configure JetBrains DataGrip to Access SQL Server Using Windows Authentication

Motivation

Many developers who use SQL Server are used to the security and ease of using Windows-authenticated connections. If their job changes such that they switch to a non-Windows workstation operating system, such as Linux or macos, but still need to connect to SQL Server, they now need to switch to SQL Authentication. This means having a different account (and therefore, hopefully a different password) on every SQL Server they use. Also, if password expiration policies are inherited from an Active Directory domain, all of those passwords will expire, and possibly not at the same time. And worst of all, some companies will not even allow SQL Authentication, so the developers using Linux and macos have to figure out a way to connect to SQL Server using Windows Authentication when they are not using Windows.

Many use some type of virtualization to run "just enough Windows" to establish Windows Authentication to SQL Serve

@sql-sith
sql-sith / enable-openweather-extension-on-ubuntu-20.04.md
Created November 22, 2021 15:05
Enable OpenWeather Extension on Ubuntu 20.04

Enabling the OpenWeather Extension on Ubuntu 20.04

The problem

The OpenWeather extension is a Gnome Shell extension that places a basic summary of current weather conditions in the top panel. This expands to show more detailed weather information if you click it.

Screenshot of OpenWeather Gnome Shell extension The OpenWeather Gnome Shell extension in action on my laptop.

The Internet has several stories of people having trouble enabling this extension in Ubuntu 20.04. Here are the suggestions I found on just one page from AskUbuntu:

Keybase proof

I hereby claim:

  • I am sql-sith on github.
  • I am christopherl (https://keybase.io/christopherl) on keybase.
  • I have a public key ASBV93QTi2LlzUeTk1t8E_vkD2FHVRPZkJ_hyGdEtJYFnQo

To claim this, I am signing this object: