T-SQL Tuesday #83: Roundup

For this month’s T-SQL Tuesday, I asked people to blog about the same old problems we’ve been dealing with for years. There were some great posts, including a batch of first-time contributors. You’ll notice some overlapping themes as you read through these responses–I think those themes represent some of the biggest, most important problems we have (like being […]

Podcast: Mirroring, Availability Groups, Replication, and Log shipping

Have you ever wondered what the best option is for making your data available in your environment? I was asked by Carlos L Chacon (blog|twitter) to be part of a panel on his podcast for an episode discussing some of the options–availability groups, mirroring, log shipping, and replication. We cover each topic in detail and explain the positives and […]

Benefits tell you a lot about a company

Catbert Vacation Policy

When you’re interviewing with a new company, pay attention to their benefits. Even the ones that aren’t important to you personally. Benefits don’t just include health/dental/vision insurance and retirement/pension (I’ll call these “core benefits”). It includes life insurance, disability, maternity leave, vacation, sick time, as well as “perks” like free snacks in the lunch room, paying […]

Moving SSRS Reports between servers


Today, my friend Derik Hammer (blog|twitter) asked about moving SSRS reports between (versions and) instances of SSRS: What is the best way to move 2008 R2 SSRS reports into an existing 2012 SSRS instance? Catalog move is insufficient here. #sqlhelp — Derik Hammer (@SQLHammer) June 29, 2016 This reminded me of a PowerShell script I […]

Andy Mallon © 2015 Frontier Theme