Skip to content

SQLMac

Database & Code

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

Tag: SQL Server

Space: Unused vs Unallocated

Posted on March 7, 2018January 21, 2021 by Garland MacNeill

I had previously blogged about working on a SQL job that deleted data older than 13 months. Today I thought I would follow up with the database and check to see how much space was available in the database. So I ran a disk usage report out of SSMS and got the following result: Wait, what? I was looking at

Read More
Database SQL Server Leave a comment

Check for corruption

Posted on July 16, 2017January 21, 2021 by Garland MacNeill

If you work, or have worked, in a shop with lots of SQL servers then you either have, or will, experience an issue with storage. Like for instance you’re storage controllers go down, knocking down your SQL instances. As we all know, this is a good way to corrupt databases. That’s why Sys Admins should never just hit the power

Read More
SQL Code SQL Server, tsql Leave a comment

Working with TempDB

Posted on May 4, 2016February 15, 2021 by Garland MacNeill

A while back I was working on setting up a new Availability Group (AG), which required working with tempdb. It was a bit of an advanced setup in the sense that it was a five node cluster, four nodes set up in a standard AG – two active/passive AGs. The fifth node was a participant in both AGs as a

Read More
Database SQL Server, tempdb 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)