Blog

Project Leadership 102

Project Leadership 102

Penny Garbus, President Soaring Eagle Continued from Project Leadership 101 A solid project leader is great at motivating the team. This person’s human quality must be energy, dedication and excitement for the project, because if the leader thinks the project has no importance or value to the entity then the rest of the team will […]

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
Project Leadership 101

Project Leadership 101

Penny Garbus, President Soaring Eagle A good project leader knows the software that they need to use for managing project TEAMS, including MICROSOFT PROJECTS, AZURE DEV OPS, Trello, Slack to name a few tools. However, a FABULOUS Project Leader COMMUNICATES upward and outward. Everyone in the chain that has a stake hold in the project […]

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
VLDB SQL Server conversions

Very Large Data Conversion Process

By Valentin Iamandi, Principal DBA The conversion myth “The conversion is slow because there is a lot of data” – a SQL developer Context Some of the big conversion SQL Server databases projects are supposed to not only convert very large data sets (billions of rows and multiple terabytes of data) but also to expand […]

READ MORE

Caucus Issues

The Iowa Caucus Application Malfunction Bad things Happen To Good People and Companies If you have participated in a software deployment, then you know how nail biting the production roll out can be. You have tested for everything you could think of. You have people on standby to ensure that the application works as expected […]

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