Svetlana Golovko

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.
  • MSSQLTips Awards: Rising Star (50+ tips) - 2018 | Author of the Year Contender - 2015-2017
Title Category Date
SQL Server Transaction Replication for Tables without a Primary Key Replication2026-06-04
SQL Server Reporting Services Failed Subscriptions Monitoring and Notifications Reporting Services Monitoring2026-03-06
SQL Server Linked Server Encryption for Network Traffic Linked Servers2025-01-06
SQL Server Agent Job Scheduling Management and Troubleshooting SQL Server Agent2022-09-20
Compare SQL Server ##MS_LoginManager## and Securityadmin Role SQL Server 20222022-08-17
Generate SQL Server Sparse Columns Script Database Design2022-01-18
DDL Trigger Example in SQL Server for Login Deletion Triggers2021-11-16
SQL Server Database Administrator Career Planning2021-04-27
Kerberos Configuration Manager for SQL Server SPN Validation Security2021-03-08
SSAS Migration from SQL Server 2012 to SQL Server 2017 Analysis Services Administration2020-01-22
SQL Server Security Best Practices for an Application Install and Uninstall2019-12-18
Script to get CPU and Cores for SQL Server Licensing Licensing2019-01-29
Custom Intrusion Detection Reporting for SQL Server Auditing and Compliance2018-08-07
Automate SQL WMI Alerts for Server and Objects Permissions Changes Monitoring2018-07-24
Automated WMI Alerts for SQL Server Login Property Changes Security2018-06-19
Alerts and Notifications for SQL Server Login, Database User and Role Membership Changes Security2018-04-11
Different ways to sort multi-server SQL Server query results using Central Management Server Central Management Servers2018-02-20
SQL Servers Assessment for the Meltdown and Spectre Vulnerabilities Security2018-01-25
SQL Server Database Mail Health Check with Policy Based Management Database Mail2017-12-27
SQL Server Database Mail Health Check for all SQL Servers Database Mail2017-12-26
Safely Dropping Unused SQL Server Indexes Indexing2017-12-07
Drop Login issues for logins tied to SQL Server Availability Groups Availability Groups2017-12-06
SQL Server Master Data Services Business Rules Notifications Master Data Services2017-11-24
SQL Server Agent Jobs Monitoring Script SQL Server Agent2017-10-17
SQL Server Edition Post-Downgrade Steps Upgrades and Migrations2017-09-21
Non-traditional ways to learn more about SQL Server Job Skills2017-07-07
SQL Server DBA On-Boarding Checklist Management Skills2017-06-20
Finding SQL Server Object Dependencies with DMVs Comparison Data and Objects2017-05-25
Finding SQL Server Object Dependencies for Synonyms Comparison Data and Objects2017-05-10
Template to Create SQL Server Synonyms with checks Synonyms2017-05-02
Create Business Rules in SQL Server Master Data Services Master Data Services2016-08-23
More Master Data Services (MDS) Tips and Tricks Master Data Services2016-08-15
SQL Server Master Data Services (MDS) Tips and Tricks Master Data Services2016-08-08
SQL Server Master Data Services (MDS) custom Delete Stored Procedure Master Data Services2016-08-03
Resolving SQL Server Master Data Services (MDS) Patching Errors Master Data Services2016-07-22
Install and configure multiple instances of Master Data Services MDS on the same server Master Data Services2016-07-12
SQL Server 2014 Master Data Services Assigning Administrator Permissions Master Data Services2016-07-01
SQL Server Database Decommissioning Check List Database Administration2016-06-23
SQL Server Master Data Services (MDS) Versions Master Data Services2016-06-17
SQL Server Master Data Services (MDS) Database Restore Steps Master Data Services2016-05-16
Export Data from IBM DB2 iSeries to SQL Server Other Database Platforms2015-10-13
SQL Server Management Studio Query Store Panes Query Store2015-10-07
SQL Server 2016 Query Store Queries Query Store2015-09-28
SQL Server 2016 Query Store Example Query Store2015-09-23
Low Disk Space Alert for SQL Server Monitoring2015-09-09
Compare SQL permissions using SQL Server Data Tools Security2015-09-04
SQL Server 2016 Query Store Introduction Query Store2015-08-27
Monitor SQL Server Master Database Changes with WMI Alerts Monitoring2015-05-06
New SQL Server Database Request Questionnaire and Checklist Database Administration2015-02-24
Using Policy Based Management for SQL Server Availability Groups Data Loss Alerts Policy Based Management2015-02-09
Using Policy Based Management to check that SQL Server indexes are created in the correct filegroup Policy Based Management2015-01-30
Collect SQL Server Stored Procedure Execution History Stored Procedures2014-07-10
Automated collection of SQL Server database connections for monitoring Monitoring2014-03-28
Using WMI alerts to import SQL Server Default Trace events Profiler and Trace2014-03-14
Monitor SQL Server Database File Growth with WMI Alerts Monitoring2013-12-11
Monitor SQL Server Databases Changes Using WMI Alerts Monitoring2013-11-15
Different Ways to Find SQL Server Object Dependencies Comparison Data and Objects2013-07-16
Multi Server Query SSRS Report using Central Management Servers Reporting Services Development2013-05-15
Policy Based Management to find number of SQL data and log files Policy Based Management2013-04-29
Policy Based Management to check SQL Server database file extensions Policy Based Management2013-04-01
SQL Server Login Management using LOGINPROPERTY function Auditing and Compliance2013-03-21
SQL Server Security Audit Scripts Auditing and Compliance2013-03-07
Using Policy Based Management for checking SQL Server Versions Policy Based Management2013-02-04
Evaluating Policies on Multiple SQL Server Instances using Central Management Server Central Management Servers2013-01-31
SQL Server Multi Database Query with Registered Servers Central Management Servers2013-01-17
SQL Server Database Security Audit (Part 1): What to expect? Auditing and Compliance2012-11-21