Skip to content

SQLMac

Database & Code

  • Home
  • DBA
    • Database
    • SQL Resources collection
  • Dev
    • Powershell
    • SQL Code
  • Technology

Tag: powershell

Restore to a point in time

Posted on March 20, 2020January 21, 2021 by Garland MacNeill

This week I had to restore to a point in time for an entire instance. The instance had approx 25 databases on it, and all of them had to be replaced to get the information we needed. As this was on a SQL Availability Group, we are backing up the logs every 15 minutes. We also use Ola’s backup scripts,

Read More
Powershell powershell Leave a comment

DBATools

Posted on March 20, 2020January 21, 2021 by Garland MacNeill

I don’t know why I am slow to take up new tools, but I am. I recently, like back in December, began working with DBATools. In case you’re not familiar, DBATools is a PowerShell module assembled by the community over at DBATools.io. This module, oh this wonderful module, makes some of the most aggravating parts of a DBA’s job so

Read More
DBA DBA, powershell, tools Leave a comment

Search

Recent Posts

  • Migrating my Blog
  • Changes and Evolution
  • Error: SQL Replication – Remote Server does not exist, or not designated
  • TGIF: It’s been one of those weeks
  • Be Wary of Windows Firewall

Archives

Tags

#NewSQLBlogger (1) #tsql2sday (8) availability group (2) aws (1) backups (2) blog (1) career (12) cloud (2) code (1) DBA (6) development (1) devops (2) firewall (1) Goals (2) learning (4) linux (1) logins (1) management (1) microsoft (2) office environment (2) personal tech (1) postgres (2) powershell (2) replication (1) security (1) sql code (1) sql development (1) SQLsaturday (3) SQL Saturday (1) SQL Server (3) SSMS (2) tempdb (1) tools (5) training (4) tsql (2) wfh (1)