Ola Maintenance from a Jr. DBA
Straight Path Solutions - SQL Server Consulting
by David Seis
3w ago
Welcome to our month of community tool blog posts! We will be discussing some of our favorite and most used tools, and how we use them, in the coming weeks. Our first post is on Ola Hallengren’s maintenance solution. For some this will be old news, this will be an entry-level offering to refresh the veterans and enlighten the newcomers. Ola maintenance is a set of stored procedures and job scripts that handle most of the daily and weekly maintenance a DBA would be concerned with. I will do a brief overview of each job set and why they are important. How to Install Ola’s Maintenance Solution In ..read more
Visit website
6 Common Mistakes Made With SQL Server Backups
Straight Path Solutions - SQL Server Consulting
by Jeff Iannucci
2M ago
People are always saying things about the importance of data, like how it is the lifeblood of a business. It sounds cliché, but there’s a lot of truth to that. You and I can’t survive without any blood, and there’s a good chance your business wouldn’t exist for long if they suddenly lost all their data. This blog post is intended to help you make sure you and your organization are properly prepared for disasters. And I apologize; that opening paragraph even grossed me out a little. I promise I’m done talking about losing blood. Now, let’s talk about disasters and other mayhem out of your contr ..read more
Visit website
SQL Server Upgrade/Migration Webinar
Straight Path Solutions - SQL Server Consulting
by Mike Walsh
2M ago
This month’s webinar is all about SQL Server upgrades and migration. We cover the following topics: Our Straight Path Upgrade Migration process with log shipping. Why In Place Upgrades are usually bad. Things to think about before, during, and after a migration Best practices for a successful migration Why upgrade? What are some options? This topic is part of our monthly SQL Server webinar series. Webinar registrants get access to the entire recording, which includes the office hours Q&A. If you would like to be notified about upcoming webinars, be sure to subscribe below: Sign Up for ..read more
Visit website
High Availability and Disaster Recovery With SQL Server Standard Edition
Straight Path Solutions - SQL Server Consulting
by Mike Lynn
2M ago
There are many ways to setup High Availability and Disaster Recovery, most of which are focused on SQL Server Enterprise edition.  However, the licensing for Enterprise edition gets costly fast.  One less talked about approach to building a cost-effective HA/DR solution is building a failover cluster instance using SQL Server Standard with SIOS Datakeeper. SQL Server Standard edition over SQL Server Enterprise edition Not every application and database need all the features of SQL Enterprise edition so why pay for those features if you aren’t using them.  SQL Server Standard edi ..read more
Visit website
Books and Covers…
Straight Path Solutions - SQL Server Consulting
by Mike Walsh
2M ago
Believe me, every heart has its secret sorrows, which the world knows not, and oftentimes we call a man cold, when he is only sad. Longfellow, Hyperion (1839) This post has been rattling around in my head for several years. Of late, though, the rattling has turned into a steady vibration. The day before I started writing this, our family did a rare (for us) thing and went to the movies. We went to see “I Heard the Bells,” – a story about Longfellow and the creation of his Poem, “Christmas Bells,” and that quote was on screen at the start of the film – my mind went to this post that was stuck ..read more
Visit website
HA/DR Troubleshooting from a Jr. DBA
Straight Path Solutions - SQL Server Consulting
by David Seis
2M ago
Availability groups, Failover Clusters, Log Shipping, and more. These are tools we use to ensure that the data is highly available and disaster recoverable. This post will be the general walkthrough for how to determine what may be going wrong with your HA/DR solution, as well as some general tips and tricks from what we have seen through working with our clients. With all SQL server issues, there a few locations that can help you determine if something is going wrong at all.  The first of which is the SQL Server Error Log. Once you start up SQL Server Management Studio and connect to the ..read more
Visit website
6 Common Pitfalls of SQL Server Migrations and Upgrades
Straight Path Solutions - SQL Server Consulting
by Jeff Iannucci
2M ago
If you’ve ever tried migrating a SQL Server database from one server to another, you know it can be a white-knuckle ride from start to finish. You need to wait forever while you backup and restore, change all your connection strings to point to the new server, and forget to change the data sources for your SSRS reports because no one remembered you have SSRS reports. I come bearing hope. It doesn’t have to be this way. In this post, I’m going to cover some of the pitfalls of migrating or upgrading your SQL Server instance, gently suggesting you DON’T DO THESE THINGS. I mean, you can do them, b ..read more
Visit website
Data Migration Assistant
Straight Path Solutions - SQL Server Consulting
by Mike Clark
2M ago
It’s upgrade season. Here at Straight Path, we have more than a couple of clients in the process of upgrading their SQL Environments to a more modern version. With the support door slamming shut soon for SQL 2008 (waaaay overdue), and others on 2012 (really not in a much better position – support wise) clients are asking us to help them with their upgrade plans. We had a really great 4-part series on SQL Server upgrades. One question we often receive is, Will my database actually upgrade? Is it compatible with SQL 2017? Do we have deprecated features? It has been running for so long, those of ..read more
Visit website
How to Save Money on SQL Server Licensing by Upgrading
Straight Path Solutions - SQL Server Consulting
by Jeff Iannucci
2M ago
If you have SQL Server instances that are out of support, which is any version prior to SQL Server 2014, then I’m sure you have your reasons for not upgrading to a newer version. Let’s take a quick look at those reasons and then examine one reason you might not have considered. My hope is you might change your mind by the end of this post. Saying no to horsing around with upgrades I have a client that just this year migrated off and decommissioned a SQL Server 2000 instance. If the instance was a person, it would be old enough to drink. That’s a sobering thought. It’s remarkable but not comple ..read more
Visit website
SQL Server Migration Considerations from a Jr. DBA
Straight Path Solutions - SQL Server Consulting
by David Seis
2M ago
SQL Server migrations are a necessary and expected part of keeping a modern SQL Server deployment. We have worked with many clients on migration projects, and I have organized some considerations for you and your team before, during, and after your SQL Server migration. We recommend working with a SQL server DBA on these kinds of projects. Especially because this list is not exhaustive, nor does it take everything for your environment into account, a DBA will be best equipped to help keep things on track. Pre-Migration Considerations The main set of reasons we encounter for a migration project ..read more
Visit website

Follow Straight Path Solutions - SQL Server Consulting on Feedspot

Continue with Google
OR