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

Featured


Creating MySQL Databases and Tables
October 8, 2019
Linux
MySQL
Windows
Creating MySQL Databases & Tables (with added tips)

This is a post on creating databases/tables in MySQL on both Windows and Linux, with added tips to help with general usage.

Read More
Create Linked Server with Postgres
March 10, 2019
PostgreSQL
SQL Server
Creating a Linked Server with a Postgres Database

In my previous post, I created a Link Server to another SQL Server instance This time, it’s a link to a Postgres database!

Read More
January 13, 2019
SQL Server
Applying Data Retention to a SQL Table

There are many reasons why you’d need to delete old data from a table within a database, some of which include;

Read More
Count Rows within CSV Files
October 9, 2018
PowerShell
Count rows within CSV files using PowerShell

This post is a quick run-through of using a PowerShell script to count rows within many CSV files, with a quick check of the data afterwards.

Read More
May 21, 2018
SQL Server
sp_who, sp_who2 & sp_whoisactive

Sp_whatnow? sp_who, sp_who2 and sp_whoisactive are stored procedures that allow you to view current users, sessions, and processes within a SQL Server instance.

Read More
Download Live Website
April 22, 2018
WordPress
How To Copy A WordPress Website Onto MAMP

This is a follow-on post from Configuring MAMP (with WordPress) and is a guide on how to copy a website onto MAMP.

Read More

Blog Menu

  • Homepage
  • All Posts
  • Index
  • Traffic
  • Scripts
  • Notes

Categories

  • Linux (11)
  • MySQL (4)
  • PostgreSQL (5)
  • PowerShell (18)
  • RedShift (4)
  • Scripts (1)
  • SQL Server (53)
  • Windows (32)
  • 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)

Recent Posts

Find String in Tables in SQL Server
November 30, 2020
Show Only the Domain of an Email Address in SQL Server
November 27, 2020
USE Command in SQL Server
November 25, 2020
Change Default Database in SQL Server
November 23, 2020
Install oh-my-posh On Windows
November 13, 2020