SQL Server Migration Tips with Andrew Snodgrass

SQL Server 2016 and 2017 are retiring soon. But there are smooth ways to migrate that will keep you supported and minimise disruption.

Creating my Practical #SQLServer High Availability and Disaster Recovery online course has been the most challenging one so far. Even more challenging than the Always On Availability Groups: The Senior DBA's Ultimate Field Guide. One reason is the breadth of the coverage. The other is the infinite number of combinations of all the different #SQLServer HA/DR features.

SQL Server backups cannot be restored to older versions, which can block migrations when version compatibility gets in the way. Brien Posey explains a practical workaround using Export and Import Data-Tier Application to move a database across versions, followed by reconfiguring permissions, logins, and application connection strings after the import. Read the step-by-step process for migrating to an older SQL Server version: https://lnkd.in/dMnDifni #SQLServer #DatabaseAdmin #SQLServer #DataMigration #ITOps

🛠️ Quick Guide: Renaming & Moving Exchange #Mailbox_Databases 1️⃣ Preparation Rename: Use the EAC (Servers > Databases) to give your database a logical name (e.g., DB01). Storage: Ensure you have two dedicated volumes ready—one for the Database (DB) and the another one for (Logs). /// Recommended /// 2️⃣Execution (The PowerShell Way) Moving via Shell is often faster and more reliable. Follow these steps: # Check Current Path: Get-MailboxDatabase | fl Name, EdbFilePath, LogFolderPath # Dismount the Database: Dismount-Database -Identity DB01 # Move Database & Logs: Move-DatabasePath -Identity DB01 -EdbFilePath D:\DB01\DB01.edb -LogFolderPath E:\DB01 # Mount the Database: Mount-Database -Identity DB01 3️⃣Verification Confirm the move was successful: Get-MailboxDatabase | fl Name, EdbFilePath, LogFolderPath Done✅

How not to install SQL Server? Next, Next, Next, Done. If you aren't sure what options to choose from the Installation Center, take some time to understand what is being asked. It will be so worthwhile in the long run. #SQLServer #DBA #DatabaseManagement

Every DBA has either lived through it — or will. TempDB fills up. The server slows to a crawl. Transactions pile up. And suddenly it’s an early morning fire drill. SQL Server 2025 changes that conversation. With TempDB resource governance, accelerated database recovery, and new monitoring insights, you finally have tools that prevent the outage instead of just reacting to it. Want to see exactly how it works and what it means for your environment? Watch the full clip now on our YouTube channel, or rewatch our most recent 2 webinars where we breakdown all of the updates in SQL Server 2025 in detail. https://lnkd.in/eHQPYr4M SQL Server SQL Server 2025 TempDB database performance DBA life resource governor accelerated database recovery SQL Server monitoring database reliability blocking and concurrency

New video on our youtube channel - Running MariaDB in Production – Lessons from the Real World | MariaDB Day Brussels What does it actually take to run MariaDB successfully in production? In this talk Roman Agabekov (Releem - Silver Sponsor of MariaDB Foundation) walks through the practical side of operating #MariaDB at scale. Rather than focusing on theory, the session explores real operational experiences: how systems are deployed, what challenges appear in production environments, and how teams address performance, scalability, and reliability in everyday database operations. A practical session for DBAs, engineers, and architects interested in how modern database performance work actually happens behind the scenes. https://lnkd.in/ddX6Hviz

SQL Server 2016 is reaching end of life—no more patches, no more security updates. If you’re still running 2016 in production, now’s the time to plan your move to SQL Server 2022 or 2025 and reduce risk. At SQL Solutions Group, we can handle end‑to‑end migrations or support your team. Want to DIY? Check out our YouTube migrations playlist for tips and tricks. https://lnkd.in/eJWJv8CS What’s your biggest concern about upgrading? SQL Server 2016, SQL Server 2022, SQL Server 2025, end of life, database migration, SQL modernization, performance, security, compliance, SQL consulting #SQLServer #SQLServer2016 #SQLServerMigration #DataPlatform #DatabaseAdministration #InfoSec #Compliance #PerformanceTuning #CloudAndOnPrem #TechLeadership

📢 Important update for anyone still on SQL Server 2016: end of life is here. No patches. No security updates. 📝 Upgrading to SQL Server 2022/2025 is no longer optional—it’s essential.

SQL Server monitoring for MSPs isn't a one-size-fits-all problem. Some MSPs are absorbing the cost of enterprise tools themselves - pricing that was never designed for multi-client operations. Some are navigating their clients' existing monitoring across multiple dashboards and logins. Some have built their own solution that works, but is hard to maintain and harder to scale. After 25 years as a SQL DBA, I built SQLWATCH to address all three. Multi-tenant architecture. All clients on one screen. From £35/server/month -less as you scale. And if your clients are overpaying for their existing tools, we can help you fix that too. We're onboarding a small number of MSP founding partners for a 30-60 day trial. Your feedback shapes the product. Your pricing gets locked for 3 years if you decide to stay with us. No lock-in. No surprise pricing. No enterprise nonsense.