Svetlana Golovko

Svetlana Golovko is a DBA with 13 years of the IT experience (including SQL Server and Oracle) with main focus on performance.

   

Svetlana has been working in IT for more than 17 years. Most of her career has focused on Database Administration (both SQL Server and Oracle) and Database Development. Databases are Svetlana's passion, but she also has fun helping co-workers and friends in troubleshooting non-database related issues. Svetlana tries to explore and learn as many SQL Server features as possible. Her favorite SQL Server features are Policy Based Management, SSIS, SSRS and Master Data Services. One of Svetlana's areas of expertize is cross systems / database integration.  Svetlana is currently a hands-on Database Team Lead in Calgary, Canada where she promotes SQL Server.

Svetlana likes to share her knowledge with others and enjoys learning herself. Her hobby is photography, but now she spends her free time away from Database Administration with her little girl who proudly wears her MSSQLTips shirt. Svetlana blogs at http://databaserefresh.com and posts her pictures to https://plus.google.com/u/0/111115767149899859037/posts.  Her Twitter account is @magasvs.

2018 Awards   

2017 Awards   

2016 Awards   

2015 Awards      

CategoryTitle
Analysis Services AdministrationSQL Server Analysis Services Migration from SQL Server 2012 to SQL Server 2017
Auditing and ComplianceCustom Intrusion Detection Reporting for SQL Server
Auditing and ComplianceSQL Server Database Security Audit (Part 1): What to expect?
Auditing and ComplianceSQL Server Login Management using LOGINPROPERTY function
Auditing and ComplianceSQL Server Security Audit (Part 2): Scripts to help you or where can you find more information
Availability GroupsDrop Login issues for logins tied to SQL Server Availability Groups
Central Management ServersDifferent ways to sort multi-server SQL Server query results using Central Management Server
Central Management ServersEvaluating Policies on Multiple SQL Server Instances using Central Management Server
Central Management ServersSQL Server Multi Database Query with Registered Servers
Comparison Data and ObjectsDifferent Ways to Find SQL Server Object Dependencies
Comparison Data and ObjectsFinding SQL Server Object Dependencies for Synonyms
Comparison Data and ObjectsFinding SQL Server Object Dependencies with DMVs
Database AdministrationNew SQL Server Database Request Questionnaire and Checklist
Database AdministrationSQL Server Database Decommissioning Check List
Database DesignHow to Use the SSIS Profiling Output File to Generate SQL Server Sparse Columns Script
Database MailSQL Server Database Mail Health Check for all SQL Servers
Database MailSQL Server Database Mail Health Check with Policy Based Management
IndexingSafely Dropping Unused SQL Server Indexes
Install and UninstallSQL Server Security Best Practices for an Application Installed on SQL Server
LicensingScript to get CPU and Cores for SQL Server Licensing
Master Data ServicesCreate Business Rules in SQL Server Master Data Services
Master Data ServicesInstall and configure multiple instances of Master Data Services MDS on the same server
Master Data ServicesMore Master Data Services (MDS) Tips and Tricks
Master Data ServicesResolving SQL Server Master Data Services (MDS) Patching Errors
Master Data ServicesSQL Server 2014 Master Data Services Assigning Administrator Permissions
Master Data ServicesSQL Server Master Data Services (MDS) custom Delete Stored Procedure
Master Data ServicesSQL Server Master Data Services (MDS) Database Restore Steps
Master Data ServicesSQL Server Master Data Services (MDS) Tips and Tricks
Master Data ServicesSQL Server Master Data Services (MDS) Versions
Master Data ServicesSQL Server Master Data Services Business Rules Notifications
MonitoringAutomated collection of SQL Server database connections for monitoring
MonitoringAutomated SQL Server WMI Alerts for Server Scope and Server Objects Permissions Changes
MonitoringLow Disk Space Alert for SQL Server
MonitoringMonitor SQL Server Database File Growth with WMI Alerts
MonitoringMonitor SQL Server Databases Changes Using WMI Alerts
MonitoringMonitor SQL Server Master Database Changes with WMI Alerts
Other Database PlatformsExport Data from IBM DB2 iSeries to SQL Server
Policy Based ManagementUsing Policy Based Management for checking SQL Server database file extensions
Policy Based ManagementUsing Policy Based Management for checking SQL Server Versions
Policy Based ManagementUsing Policy Based Management for SQL Server Availability Groups Data Loss Alerts
Policy Based ManagementUsing Policy Based Management to check number of SQL Server data and log files
Policy Based ManagementUsing Policy Based Management to check that SQL Server indexes are created in the correct filegroup
Professional Development Career PlanningSQL Server Database Administrator
Professional Development ManagementSQL Server DBA On-Boarding Checklist
Professional Development Skills DevelopmentNon-traditional ways to learn more about SQL Server
Profiler and TraceUsing WMI alerts to import SQL Server Default Trace events
Query StoreSQL Server 2016 Query Store Example
Query StoreSQL Server 2016 Query Store Introduction
Query StoreSQL Server 2016 Query Store Queries
Query StoreSQL Server 2016 Query Store SSMS Panes
ReplicationTransactional Replication for SQL Server Tables without Primary Keys
Reporting Services DevelopmentCreating a multi-server query SSRS report using Central Management Servers
SecurityAlerts and Notifications for SQL Server Login, Database User and Role Membership Changes
SecurityAutomated WMI Alerts for SQL Server Login Property Changes
SecurityCompare SQL permissions using SQL Server Data Tools
SecuritySQL Servers Assessment for the Meltdown and Spectre Vulnerabilities
SecurityUsing Kerberos Configuration Manager for SPNs Validation
SharePointBuild SQL Server End of Support Report Using Multiple SharePoint Lists
SharePointJoin Multiple SharePoint Lists to build SQL Server Reporting Services Report
SQL Server 2022SQL Server 2022 Server Level Role Updates
SQL Server AgentSQL Server Agent Jobs Monitoring Script
SQL Server AgentSQL Server Agent Jobs Schedules - Review, Cleanup, and Special Cases
Stored ProceduresSeveral Methods to collect SQL Server Stored Procedure Execution History
SynonymsTemplate to Create SQL Server Synonyms with checks
TriggersSQL Server DDL Trigger to Prevent Logins Deletion
Upgrades and MigrationsSQL Server Edition Post-Downgrade Steps
No Records Found
No Records Found
CategoryGroupCategory (articles)
Analysis ServicesAnalysis Services Administration (31)
Analysis ServicesAnalysis Services Development (95)
Analysis ServicesAnalysis Services Dimensions (16)
Analysis ServicesAnalysis Services Measure Groups (7)
Analysis ServicesAnalysis Services Performance (14)
Analysis ServicesAnalysis Services Security (7)
Analysis ServicesAnalysis Services Tools (1)
Analysis ServicesAnalysis Services Tutorials (6)
Analysis ServicesCortana (5)
Analysis ServicesPerformance Point (4)
Business IntelligenceBig Data (25)
Business IntelligenceData Warehousing (4)
CloudAmazon AWS (47)
CloudApache Spark (3)
CloudAzure (188)
CloudAzure Backup and Restore (25)
CloudAzure Cosmos DB (12)
CloudAzure Data Factory (68)
CloudAzure Databricks (23)
CloudAzure Integration Services (14)
CloudAzure Synapse Analytics (36)
CloudCloud Strategy (12)
Data QualityData Quality Services (7)
Data QualityMaster Data Services (41)
Database AdministrationAvailability Groups (75)
Database AdministrationBackup (78)
Database AdministrationCentral Management Servers (9)
Database AdministrationClustering (73)
Database AdministrationComparison Data and Objects (14)
Database AdministrationCompression (22)
Database AdministrationContained Databases (4)
Database AdministrationContainers (12)
Database AdministrationDatabase Administration (190)
Database AdministrationDatabase Configurations (18)
Database AdministrationDatabase Console Commands DBCCs (25)
Database AdministrationDatabase Mail (18)
Database AdministrationDatabase Mirroring (33)
Database AdministrationDBA Best Practices (39)
Database AdministrationDedicated Administrator Connection (4)
Database AdministrationDeprecated Features (5)
Database AdministrationDevOps (34)
Database AdministrationDisaster Recovery (23)
Database AdministrationError Logs (11)
Database AdministrationExpress Edition (16)
Database AdministrationExtended Events (22)
Database AdministrationFILESTREAM (9)
Database AdministrationFragmentation and Index Maintenance (27)
Database AdministrationHardware (13)
Database AdministrationHigh Availability (3)
Database AdministrationIndexing (82)
Database AdministrationInstall and Uninstall (32)
Database AdministrationLicensing (4)
Database AdministrationLinked Servers (18)
Database AdministrationLocking and Blocking (38)
Database AdministrationLog Shipping (18)
Database AdministrationMaintenance (34)
Database AdministrationMonitoring (115)
Database AdministrationOther Database Platforms (74)
Database AdministrationPartitioning (15)
Database AdministrationPerformance Data Warehouse (4)
Database AdministrationPerformance Tuning (123)
Database AdministrationPolicy Based Management (29)
Database AdministrationPowerShell (129)
Database AdministrationProfiler and Trace (20)
Database AdministrationQuery Store (7)
Database AdministrationRecovery Models (4)
Database AdministrationReplication (75)
Database AdministrationResource Governor (5)
Database AdministrationRestore (41)
Database AdministrationSQL Server 2016 (100)
Database AdministrationSQL Server 2017 (44)
Database AdministrationSQL Server 2019 (19)
Database AdministrationSQL Server 2022 (10)
Database AdministrationSQL Server Configurations (75)
Database AdministrationSQL Server on Linux (76)
Database AdministrationStreamInsight (2)
Database AdministrationSystem Databases (31)
Database AdministrationUpgrades and Migrations (54)
Database AdministrationVirtualization (25)
Database AdministrationWindows Internal Database (1)
Database DevelopmentApplication Development (36)
Database DevelopmentChange Data Capture (15)
Database DevelopmentCommon Runtime Language (13)
Database DevelopmentCommon Table Expressions (3)
Database DevelopmentConstraints (20)
Database DevelopmentData Cleansing for Validation (2)
Database DevelopmentData Science (3)
Database DevelopmentData Types (17)
Database DevelopmentDatabase Design (71)
Database DevelopmentDates (49)
Database DevelopmentDebugging (4)
Database DevelopmentDynamic Management Views and Functions (33)
Database DevelopmentDynamic SQL (7)
Database DevelopmentEntity Framework (13)
Database DevelopmentError Handling (8)
Database DevelopmentFull Text Search (21)
Database DevelopmentFunctions System (70)
Database DevelopmentFunctions User Defined UDF (40)
Database DevelopmentIdentities (17)
Database DevelopmentImport and Export (77)
Database DevelopmentIn Memory OLTP (32)
Database DevelopmentJOIN Tables (21)
Database DevelopmentLanguage Integrated Query LINQ (7)
Database DevelopmentMicrosoft Access Integration (8)
Database DevelopmentMicrosoft Excel Integration (40)
Database DevelopmentMicrosoft Flow (1)
Database DevelopmentPaging (5)
Database DevelopmentPython (48)
Database DevelopmentQuery Optimization (14)
Database DevelopmentQuery Plans (20)
Database DevelopmentR Language (11)
Database DevelopmentScripts (35)
Database DevelopmentService Broker (11)
Database DevelopmentSpatial Data Storage (9)
Database DevelopmentSQL Injection (5)
Database DevelopmentSQL Server Management Objects SMO (3)
Database DevelopmentStored Procedures (28)
Database DevelopmentSynonyms (5)
Database DevelopmentTable Valued Parameters (4)
Database DevelopmentTemp Tables (9)
Database DevelopmentTemporal Tables (13)
Database DevelopmentTesting (31)
Database DevelopmentTransactions (9)
Database DevelopmentTriggers (44)
Database DevelopmentTSQL (321)
Database DevelopmentUser Defined Type UDT (3)
Database DevelopmentViews (13)
Database DevelopmentXML (14)
Integration ServicesData Transformation Services (5)
Integration ServicesIntegration Services Administration (10)
Integration ServicesIntegration Services Analysis Services Tasks (5)
Integration ServicesIntegration Services Best Practices (12)
Integration ServicesIntegration Services Configuration Options (21)
Integration ServicesIntegration Services Connection Managers (5)
Integration ServicesIntegration Services Control Flow Transformations (14)
Integration ServicesIntegration Services Data Flow Transformations (19)
Integration ServicesIntegration Services Development (107)
Integration ServicesIntegration Services Email (3)
Integration ServicesIntegration Services Error Handling (8)
Integration ServicesIntegration Services Excel (14)
Integration ServicesIntegration Services Execute Package Options (8)
Integration ServicesIntegration Services Import and Export Wizard (2)
Integration ServicesIntegration Services NULL Management (4)
Integration ServicesIntegration Services Oracle (4)
Integration ServicesIntegration Services Performance (12)
Integration ServicesIntegration Services Security (7)
Integration ServicesIntegration Services Upgrade (4)
Power PlatformPower Apps (17)
Power PlatformPower BI (133)
Power PlatformPower BI Charts (46)
Power PlatformPower BI Formatting (15)
Professional DevelopmentProfessional Development Books (3)
Professional DevelopmentProfessional Development Branding (13)
Professional DevelopmentProfessional Development Career (17)
Professional DevelopmentProfessional Development Career Planning (16)
Professional DevelopmentProfessional Development Career Transition (4)
Professional DevelopmentProfessional Development Certifications (47)
Professional DevelopmentProfessional Development Community (16)
Professional DevelopmentProfessional Development Conferences (2)
Professional DevelopmentProfessional Development Interview Questions BI (15)
Professional DevelopmentProfessional Development Interview Questions DBA (23)
Professional DevelopmentProfessional Development Interview Questions Developer (9)
Professional DevelopmentProfessional Development Interviewing (38)
Professional DevelopmentProfessional Development Job Search (17)
Professional DevelopmentProfessional Development Management (9)
Professional DevelopmentProfessional Development Recruiters (6)
Professional DevelopmentProfessional Development Resume (13)
Professional DevelopmentProfessional Development Skills Development (18)
Reporting ServicesReporting Services Administration (19)
Reporting ServicesReporting Services Analysis Services (4)
Reporting ServicesReporting Services Best Practices (6)
Reporting ServicesReporting Services Charts (25)
Reporting ServicesReporting Services Configuration (10)
Reporting ServicesReporting Services Custom Report (2)
Reporting ServicesReporting Services Dashboard (1)
Reporting ServicesReporting Services Data Sources (10)
Reporting ServicesReporting Services Development (37)
Reporting ServicesReporting Services Drill Through (4)
Reporting ServicesReporting Services Dynamic Reports (11)
Reporting ServicesReporting Services Filtering (3)
Reporting ServicesReporting Services Formatting (26)
Reporting ServicesReporting Services Functions (5)
Reporting ServicesReporting Services Images (2)
Reporting ServicesReporting Services Installation (9)
Reporting ServicesReporting Services KPI (5)
Reporting ServicesReporting Services Maps (4)
Reporting ServicesReporting Services Migration (5)
Reporting ServicesReporting Services Monitoring (5)
Reporting ServicesReporting Services Network Load Balancing (4)
Reporting ServicesReporting Services Overview (5)
Reporting ServicesReporting Services Parameters (15)
Reporting ServicesReporting Services Performance (6)
Reporting ServicesReporting Services Report Builder (9)
Reporting ServicesReporting Services Report Models (1)
Reporting ServicesReporting Services Security (8)
Reporting ServicesReporting Services SharePoint (1)
Reporting ServicesReporting Services Subreports (4)
Reporting ServicesReporting Services Tutorials (1)
SecurityAuditing and Compliance (45)
SecurityEncryption (32)
SecuritySecurity (196)
SecuritySurface Area Configuration Manager (4)
SharePointSharePoint (130)
SharePointSharePoint Administration (46)
SharePointSharePoint Configuration (27)
SharePointSharepoint Design (46)
SharePointSharePoint Document Management (20)
ToolsAzure Data Studio (16)
ToolsSQL Operations Studio (11)
ToolsSQL Server Agent (93)
ToolsSQL Server Management Studio (77)
ToolsSQL Server Management Studio Configuration (22)
ToolsSQL Server Management Studio Shortcuts (9)
ToolsTools (33)