Close
  • Tech Blog
  • About
×
×
  • Tech Blog
  • About
Menu & Search
Peter Whyte
Category

SQL Server


November 30, 2020
SQL Server
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.

Read More
November 27, 2020
SQL Server
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.

Read More
November 25, 2020
SQL Server
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.

Read More
November 23, 2020
SQL Server
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.

Read More
Disk Usage by Top Tables SQL Server
October 4, 2020
SQL Server
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.

Read More
Show Last Backup Times SQL Server Feature
September 22, 2020
SQL Server
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.

Read More
SQL Scripts Feature
September 21, 2020
MySQL
PostgreSQL
RedShift
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.

Read More
July 15, 2020
MySQL
SQL Server
Windows
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.

Read More
Check & Restart SQL Server Services on Linux
July 14, 2020
Linux
SQL Server
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.

Read More
Forcing Encryption in SQL Server
May 6, 2020
PowerShell
SQL Server
Windows
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.

Read More
Load More
No More Posts

Blog Menu

  • Homepage
  • All Posts (Grid)
  • All Posts (List)
  • Index
  • Traffic
  • Scripts
  • Notes

Categories

  • AWS (2)
  • Linux (15)
  • MySQL (4)
  • PostgreSQL (5)
  • PowerShell (23)
  • RedShift (5)
  • Scripts (1)
  • SQL Server (53)
  • Windows (36)
  • WordPress (5)

Tags

Certificates & Encryption (3) CSV Files (3) Database Admin (35) Database Backups (5) Data Types (2) Deleting Data (2) Error Messages (4) Exporting Data (1) Featured (6) Git (6) Importing Data (1) Installing SQL Server (8) Linked Servers (3) Linux Admin (2) Logging & Monitoring (1) Measuring Databases (7) Restoring Databases (4) SQL Server Agent (3) SQL Server ETL (2) SQL Server Management Studio (9) SQL Server Processes (4) SQL Server Scripts (2) Windows Admin (9) WordPress Technical Issues (2) WordPress Tutorials (3) WSL (6)