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
SQL Server and PowerShell Automation – DBATools

SQL & PowerShell

By Rohit Khadka, Sr. Database Administrator Many of us – Production DBAs, at some of our career have had to work with PowerShell to perform operations outside of SQL Server. Sometimes, this task can be a bit intimidating considering that it wasn’t really part of the job description (let’s just admit that we didn’t read […]

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