Anna Fedosseeva @ SATS TechnologiesReplacing Truncate with Partitions Rotation in Oracle and Why it’s UsefulSay that once a day, your application populates a table that is used throughout the day. The data is purged the next day and replaced with…Feb 13, 2018Feb 13, 2018
Anna Fedosseeva @ SATS TechnologiesA New Year, A New DBA ApproachHappy 2018! You’re probably been thinking about your personal new year resolutions, but how about a new years resolution for your business…Jan 4, 2018Jan 4, 2018
Anna Fedosseeva @ SATS TechnologiesCloning a SQL Server Database is Useful and EasySometimes, for development or testing purposes, we find ourselves in need of a copy of an existing production database. There are multiple…Nov 7, 2017Nov 7, 2017
Anna Fedosseeva @ SATS TechnologiesLinking Oracle SQL Net to a Global DatabaseSay you have two databases with the same database name, but located on different servers. You want to link them together so the data could…Oct 24, 2017Oct 24, 2017
Anna Fedosseeva @ SATS TechnologiesShrink Oversized Data Files in Microsoft SQL ServerWe’ve all been there: a giant data file is sitting somewhere on a disk drive and you regret letting it get this big in the first place. If…Oct 19, 20172Oct 19, 20172
Anna Fedosseeva @ SATS TechnologiesYou Don’t Need Automation in Oracle DBStarting from Version 10.1 and all the way to current 11.2, recent versions of Oracle software delivers more and more automation in…Oct 10, 2017Oct 10, 2017
Anna Fedosseeva @ SATS TechnologiesSpeeding Up MySQL Using Materialized ViewsSometimes, MySQL users would like to allow frequent access to big and active tables. SATS RDBAs already described how to do this in…Sep 28, 20172Sep 28, 20172
Anna Fedosseeva @ SATS TechnologiesFinding an Remote DBA That Works With Multiple PlatformsFinding the right tool to monitor one database could sometimes be tough enough — but what about finding a tool to monitor multiple…Sep 27, 2017Sep 27, 2017
Anna Fedosseeva @ SATS TechnologiesSpeeding Up PostgreSQL in 3 Easy StepsHere at SATS, our Database Administrators have seen it all. One of the common issues with our clients who use Postgres is that they would…Aug 22, 2017Aug 22, 2017
Anna Fedosseeva @ SATS TechnologiesHow to Upgrade to Oracle 12c (Version 12.1)As of October 2013, we at SATS have noticed that production error-free upgrades to Oracle 12c are becoming hot projects among many database…May 2, 2017May 2, 2017