How Big Are The Tables In My Databases?
Jeff Garbus – CEO Soaring Eagle Consulting, Inc I stole (and slightly modified) this code, and put it here so that I could find it. Have fun.
Category: Database Administration
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 […]
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 […]
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 […]
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 […]
Migrating on-premise Microsoft SQL Server to Azure
Interested in migrating your on-premise Microsoft SQL Server to Azure? One of Guru DBAs, Maninder Singh, has created this detailed presentation on moving SQL Server VMs to Microsoft Azure.
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 […]
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 […]
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 […]
SQL Tips and Tricks with Jeff Garbus
Things you are doing wrong in SQL Server (and how to do them right). With our CEO, Jeff Garbus.