Skip to content

SQLMac

Database & Code

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

Category: DBA

Update: Six Months later

Posted on May 26, 2018January 21, 2021 by Garland MacNeill

Six months ago, I accepted a new position in Duluth, MN and moved to house we already owned in Wisconsin not too far from Duluth. And by not too far, my commute is about an hour, depending on the weather. It’s about the same drive time I had in Denver, except there’s no traffic. There’s some other changes that we

Read More
DBA Leave a comment

Wait Stats Library

Posted on May 9, 2018January 21, 2021 by Garland MacNeill

Every so often you come across one of those tools that just changes everything. When it comes to troubleshooting tools, this is one of those defing tools. Paul Randal has assembled the greatest library of SQL wait statistics known to man – well to me anyway. If you have questions about what a wait stat is, check out Mr. Randal’s

Read More
SQL Resources tools Leave a comment

DateTime2 not like DateTime

Posted on April 20, 2018January 21, 2021 by Garland MacNeill

I came across an article on SQL Server Central written by Claudio Silva (b/t) discussing that you can’t do arithmetic operations on DateTime21 like you can with DateTime. For example: Old Way OrderDate < GETDATE() -1 You need to do something like this: OrderDate < DATEADD(dd, -1, @vOrderDate) Original Article here

SQL Resources Leave a comment

Database Administration is evolving

Posted on April 12, 2018January 21, 2021 by Garland MacNeill

Steve Jones (t|b) wrote a blog post talking about the death of the title Database Administrator. Mind you, he was talking about the title of DBA, not the actual job of being a DBA. Semantics, right? If you look across the inter-webs, the death of the DBA has been a favorite of the tech prophets for a long time.  It

Read More
DBA career Leave a comment

TSQL Tuesday #99 – Outside Interests

Posted on February 13, 2018February 10, 2021 by Garland MacNeill

This month, Aaron Bertrand (b/t) is hosting the TSQL Tuesday topic. And this month, the topic of choice is either 1) an outside hobby or 2) bad habits found/used in TSQL. I somehow think by the time I’m done with this post, I’m going to blur the two together. My Outside Interests: Motorcycles I have a number of interests outside

Read More
DBA #tsql2sday Leave a comment

A Month of SSMS

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

One of the things that has always frustrated me with Microsoft’s tools like SSMS and Visual Studio, is the sheer depth of the tool. Figuring out how to create an SSRS or SSIS package in Visual Studio the first few times can result in half a day wasted. SSMS can be just as bad some days. So it’s nice when

Read More
SQL Resources SSMS, tools Leave a comment

SQL version numbers

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

This is one of those tools I use all the time. I’m always looking at the version number to see which version of SQL with SP/CU version I am working with. SQL Version numbers and patch history

SQL Resources tools Leave a comment

Error 18456 State x

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

I use this link all the time to troubleshoot login errors in the SQL error log. Aaron Bertrand recently moved his blog, so I wanted to make sure I had an updated link for my reference. https://sqlblog.org/2011/01/14/troubleshooting-error-18456

SQL Resources logins, tools Leave a comment

TSQL Tuesday #97: Learning in 2018

Posted on December 12, 2017February 10, 2021 by Garland MacNeill

This month’s blog topic for TSQL Tuesday is learning goals in 2018 and is being hosted by Mala Mahadevan ( b / t ). Mala has challenged the SQL community to list out specific learning plans for the upcoming year. It’s an awesome topic for this time of year, especially as we’re slowing a bit to focus on family and

Read More
DBA #tsql2sday Leave a comment

New Job Update

Posted on November 27, 2017January 21, 2021 by Garland MacNeill

I’m a bad DBA, at least from the standpoint of blogging. Only because I haven’t done much of a lately. I did make sure to get a post in for TSQL2sDay to mention who I was thankful for. That was a great topic. So…if you’re wondering why I haven’t blogged, or have checked to see how I like the new

Read More
DBA career, DBA 1 Comment
  • ← Previous
  • 1
  • 2
  • 3
  • 4
  • Next →

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)