Madeira TeamJan 3, 20184 minHow to fix Orphaned Users easilyWhat are Orphaned Users “Orphaned Users” is a common issue in SQL Server where a Database User is no longer associated with its relevant...
Madeira TeamDec 7, 20173 minHow to Update @@SERVERNAME to Actual Machine Name?The @@SERVERNAME Global Variable The system global variable @@SERVERNAME can be used to return the name of the machine the SQL Server is...
Madeira TeamApr 25, 20161 minPartition to Filegroup Mapping in SQL ServerSuppose you have a partition function and a corresponding partition scheme in SQL Server. The partition scheme maps each partition to a...
Madeira TeamDec 17, 20151 minHow to Get the Size of Tables in VerticaIf you need to query the size of tables in Vertica, then you have several ways to do it. I will demonstrate two options. The first is...
Madeira TeamApr 8, 20152 minHow to Measure IO Latency for Database Files in SQL ServerIn order to get information about the amounts of PHYSICAL reads we perform on database files, SQL Server exposes a DMV called...
Madeira TeamFeb 26, 20158 minMonitor Query StatisticsOne of the most common tasks that DBAs are required to perform is monitoring. This is not just a task. Monitoring is a strategy, and a...