When Is An Index Redundant?

Jeff Garbus – CEO Soaring Eagle Consulting Recently I was called into a shop that had a 4 terabyte database, who claimed they didn’t have anywhere near that much data. Upon investigation, they were correct. They had about 100 gigs of data, and about 3.9 TB of indexes.Is this too much? Well, in order to […]

READ MORE

Backup Frequency

Jeff Garbus – CEO Soaring Eagle Consulting A backup strategy is NOT a technical decision, it is the result of applying technical expertise to business decisions regarding RPO (Recovery Point Objective) and RTO (Recovery Time Objective). For example, if you are backing up a 5T database, it doesn’t really matter if you are backing up […]

READ MORE
Hiring  Database Administrator

Database Administrator – Hiring An Effective DBA

So you’ve started your own business and are looking forward to seeing where this new venture takes you. It’s essential to have a good database administrator to safeguard your business data.Or maybe you’ve been running one for a while, and you’re getting up to date with technology to remain competitive. It’s essential to have a […]

READ MORE

Soaring Eagle & SQL Governor are here to save you money!

Soaring Eagle Database Consulting Inc. and SQL Governor are announcing a partnership to help companies save money SQL Governor®  helps companies to modernize their data platforms, ease migration to the cloud, and reduce their SQL costs and carbon footprint. SQL Governor® capacity optimization and performance optimization solution is ideal for planning the data platform renewal, in […]

READ MORE
SQL 2019 INSTALLATION

SQL 2019 Installation: Tips & Tricks

By Maninder Sing, Principal Consultant SQL Server 2019 has made available 2 core features during the installation(Among a few other like SSIS Scale out which was also available in SQL 2017 ) The 2 Core features available during the installation are Memory settings and MAXDOP settings. I personally believe this is a excellent thing to […]

READ MORE

Automating SQL Server Installation

By Rohit Khadka, Sr. Database Administrator As a Production DBA, I have had the opportunity to do an upgrade/migration from SQL Server 2012 to SQL Server 2016. During the process, I realized that installing a new SQL Server on 20-30 servers in a short time was going to be challenging and monotonous. Going through the […]

READ MORE
The Usefulness of a Little R in SQL

Work smarter: Little R

By Rohit Khadka, Sr. Database Administrator At some point of our DBA career, we all have had an opportunity to run a set of scripts one by one for each instance until your fingers and mouse gave up. Then, we came back to work next day with a bandage wrapped around our fingers and continue […]

READ MORE