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.
Show Only the Domain of an Email Address in SQL Server
When performing data analysis of email data in SQL, there’s often a need to show only the domain of an email address.
USE Command in SQL Server
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.
Change Default Database in SQL Server
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.
Disk Usage by Top Tables Report in SQL Server
The Disk Usage by Top Tables Report in SQL Server is a quick way to get sizes of all tables within a database.
Show Last Backup Times in SQL Server
If you’re running a SQL Server and you care about the data held in it, you should already be backing up the databases.
Why use WHERE 1=1 in SQL Queries
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.
Creating a Linked Server with a MySQL Database
This is my 3rd Linked Server post, and this time it’s to a MySQL database. Noteworthy weblinks: # My Linked Server Blog Posts.# Microsoft Docs – Linked Servers.
Check & Restart SQL Server Services on Linux
Restarting services is a simple one, although it could be an unfamiliar environment for pre-SQL Server 2017 (only) administrators; which was the edition that allowed SQL Server to run on Linux.
Forcing Encryption in SQL Server
If you’re ever planning to allow external connections to a SQL Server, one of the first things to ensure is that the data is encrypted at rest and in-transit.
