Executives: Are you doing this wrong with your data?

Jeffrey Garbus, CEO Soaring Eagle Consulting Featured on Tampa Bay Business Journal When I began writing this article, I thought to myself, “I’ve written books about this…where do I stop?” I won’t make you read a book today. I’m going to hit some highlights for executives who may spend more time running their business than […]

READ MORE

Data Loss Tolerance

Penny Garbus, President of Soaring Eagle Consulting Author of:  Mining New Gold May 2021 will probably be known for a couple of news stories but one that affected our daily lives was the shut down of the Colonial Pipeline and how it frightened people so badly that they felt they needed to collect gas in […]

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

Components of Data Protection

Penny Garbus, President Data protection has many facets. First there are hardware structures, software, and procedural processes. Then you have defensive maneuver strategies that you complete through Audit Penetration tests and Phishing tests. You need all the different layers from many types of software and hardware firewalls, SSL certificates, then layers of security monitoring software […]

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
Eliminating Redundant Indexes

Reclaiming Space

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 gig of data, and about 3.9 T of indexes. Is this too much? Well, in order to make that kind of judgement call […]

READ MORE