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 ...
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 ...
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.
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 ...
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 ...
Caucus Issues
The Iowa Caucus Application Malfunction Bad things Happen To Good People and Companies https://techcrunch.com/2020/02/04/iowa-caucus-app-disaster/ 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 ...
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 ...
Continuity
Continuity in the IT world means that if we lose a teammate (hopefully only temporarily) that work and life in our environment can still go on. The most important thing to do is to automate everything that you can. Alerts, ...
