Mike Walsh, Author at SQL Server Consulting

You are Free: Career Lessons from a farm fence

by Mike Walsh | May 11, 2017 | Uncategorized

When I put Database technology down, I run a 20-acre farm with my family. I love it. It’s fun watching the kids learn from the experience. It’s fun learning my own life lessons and illustrations from the chores and animals. A farm scare today made me...

SQL Server Security Basics

by Mike Walsh | Feb 15, 2017 | Security, StraightUpTips, Syndicate

This isn’t the complete guide to securing a SQL Server, but these are some of the more common things I bump into and wish I wouldn’t when it comes to SQL Server Security. Read these practices, understand them by searching the web or come here and ask me...

SQL Server Max Memory Best Practices

by Mike Walsh | Feb 8, 2017 | Straight Up SQL Server Tips

In this Straight Up SQL Server Tips series, we’re going back to basics. Many of these are findings in our SQL Server Health Assessments or things I bump into on the forums and Q&A sites when I’m out answering questions. Today we’re talking a bit...

How To Manage The SQL Server Transaction Log File

by Mike Walsh | Feb 4, 2017 | Straight Up SQL Server Tips

“Help! My SQL Server transaction log file has run out of space on my SQL Server!”, “Why is my SQL Server Log file so big?”, “How do I shrink my SQL LDF?” – I hear these questions all the time. I’ve been blogging since...

DevOps: Don’t Forget The Ops

by Mike Walsh | Feb 1, 2017 | Learn From Mistakes, Syndicate

I want to commend the team at GitLab.com – they had an issue that took down a key database and everything else with it effectively and when they came back, there was data not coming back. This happens. This happens in “Traditional” 1.0 IT companies...