Find String in Tables in SQL Server
Finding strings in SQL is usually done within a WHERE clause – you’re searching for rows in a table containing your condition which can of course include a string.
Finding strings in SQL is usually done within a WHERE clause – you’re searching for rows in a table containing your condition which can of course include a string.
When performing data analysis of email data in SQL, there’s often a need to show only the domain of an email address.
The Use command in SQL Server is a way to change context to a specified database, which I often refer to this as scoping to a database for a query.
When you log into SQL Server using SQL Server Management Studio (SSMS), opening a new query window will automatically scope you within the default database set when your user was created.
Oh-my-posh is a theme engine for PowerShell that’s separate from your default PowerShell console. It’s powered by posh-git and has status indications for git, failed, and admin commands.
Windows Terminal is a more modern command-line tool that has features including “multiple tabs, panes, Unicode and UTF-8 character support, a GPU accelerated text rendering engine, and the ability to create your own themes and customize text, colors, backgrounds, and shortcuts“.
Posh-git is a PowerShell module that integrates with Git to show git status information on the command line, and it comes with tab completion for common commands.
This post is a guide on installing the Chocolatey package manager on Windows by running a PowerShell command. Chocolatey allows you to manage software packages on your system with simple ‘choco’
The Disk Usage by Top Tables Report in SQL Server is a quick way to get sizes of all tables within a database.
This is a quick guide for if you’ve cloned a git repo via HTTPS and you want to change it to SSH.
This is a post containing a query that’ll bring back all schemas, tables, and columns in Redshift or Postgres databases. I’m combining the Redshift and Postgres database blog categories here…
Superusers in RedShift hold the permissions to perform any action in the cluster, the same access as ‘master’ or whatever you named the superuser during creation.
Here’s a simple guide on creating a new AWS RedShift Cluster within a personal AWS test environment. Warning, if you’re testing this AWS Service you have to be rigorous with managing the cluster for billing reasons.
If you’re running a SQL Server and you care about the data held in it, you should already be backing up the databases.
A common SQL question is, why does anyone use WHERE 1=1 in their queries? And what does it do? The condition means WHERE TRUE, so it’s just bringing back the same query result as it would without.