Get Free Tips
MSSQLTips.com

Author: Svetlana Golovko

Home » Archives for 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

TitleCategoryDate
SQL Server Linked Server Encryption for Network TrafficLinked Servers2025-01-06
SQL Server Agent Job Scheduling Management and TroubleshootingSQL Server Agent2022-09-20
Compare SQL Server ##MS_LoginManager## and Securityadmin RoleSQL Server 20222022-08-17
Generate SQL Server Sparse Columns ScriptDatabase Design2022-01-18
DDL Trigger Example in SQL Server for Login DeletionTriggers2021-11-16
SQL Server Database AdministratorProfessional Development Career Planning2021-04-27
Kerberos Configuration Manager for SQL Server SPN ValidationSecurity2021-03-08
SQL Server Transaction Replication for Tables without a Primary KeyReplication2020-10-02
SSAS Migration from SQL Server 2012 to SQL Server 2017Analysis Services Administration2020-01-22
SQL Server Security Best Practices for an ApplicationInstall and Uninstall2019-12-18
Build SQL Server End of Support Report Using Multiple SharePoint ListsSharePoint2019-04-26
Join Multiple SharePoint Lists to build SSRS ReportSharePoint2019-03-13
Script to get CPU and Cores for SQL Server LicensingLicensing2019-01-29
Custom Intrusion Detection Reporting for SQL ServerAuditing and Compliance2018-08-07
Automate SQL WMI Alerts for Server and Objects Permissions ChangesMonitoring2018-07-24
Automated WMI Alerts for SQL Server Login Property ChangesSecurity2018-06-19
Alerts and Notifications for SQL Server Login, Database User and Role Membership ChangesSecurity2018-04-11
Different ways to sort multi-server SQL Server query results using Central Management ServerCentral Management Servers2018-02-20
SQL Servers Assessment for the Meltdown and Spectre VulnerabilitiesSecurity2018-01-25
SQL Server Database Mail Health Check with Policy Based ManagementDatabase Mail2017-12-27
SQL Server Database Mail Health Check for all SQL ServersDatabase Mail2017-12-26
Safely Dropping Unused SQL Server IndexesIndexing2017-12-07
Drop Login issues for logins tied to SQL Server Availability GroupsAvailability Groups2017-12-06
SQL Server Master Data Services Business Rules NotificationsMaster Data Services2017-11-24
SQL Server Agent Jobs Monitoring ScriptSQL Server Agent2017-10-17
SQL Server Edition Post-Downgrade StepsUpgrades and Migrations2017-09-21
Non-traditional ways to learn more about SQL ServerProfessional Development Skills Development2017-07-07
SQL Server DBA On-Boarding ChecklistProfessional Development Management2017-06-20
Finding SQL Server Object Dependencies with DMVsComparison Data and Objects2017-05-25
Finding SQL Server Object Dependencies for SynonymsComparison Data and Objects2017-05-10
Template to Create SQL Server Synonyms with checksSynonyms2017-05-02
Create Business Rules in SQL Server Master Data ServicesMaster Data Services2016-08-23
More Master Data Services (MDS) Tips and TricksMaster Data Services2016-08-15
SQL Server Master Data Services (MDS) Tips and TricksMaster Data Services2016-08-08
SQL Server Master Data Services (MDS) custom Delete Stored ProcedureMaster Data Services2016-08-03
Resolving SQL Server Master Data Services (MDS) Patching ErrorsMaster Data Services2016-07-22
Install and configure multiple instances of Master Data Services MDS on the same serverMaster Data Services2016-07-12
SQL Server 2014 Master Data Services Assigning Administrator PermissionsMaster Data Services2016-07-01
SQL Server Database Decommissioning Check ListDatabase Administration2016-06-23
SQL Server Master Data Services (MDS) VersionsMaster Data Services2016-06-17
SQL Server Master Data Services (MDS) Database Restore StepsMaster Data Services2016-05-16
Export Data from IBM DB2 iSeries to SQL ServerOther Database Platforms2015-10-13
SQL Server Management Studio Query Store PanesQuery Store2015-10-07
SQL Server 2016 Query Store QueriesQuery Store2015-09-28
SQL Server 2016 Query Store ExampleQuery Store2015-09-23
Low Disk Space Alert for SQL ServerMonitoring2015-09-09
Compare SQL permissions using SQL Server Data ToolsSecurity2015-09-04
SQL Server 2016 Query Store IntroductionQuery Store2015-08-27
Monitor SQL Server Master Database Changes with WMI AlertsMonitoring2015-05-06
New SQL Server Database Request Questionnaire and ChecklistDatabase Administration2015-02-24
Using Policy Based Management for SQL Server Availability Groups Data Loss AlertsPolicy Based Management2015-02-09
Using Policy Based Management to check that SQL Server indexes are created in the correct filegroupPolicy Based Management2015-01-30
Collect SQL Server Stored Procedure Execution HistoryStored Procedures2014-07-10
Automated collection of SQL Server database connections for monitoringMonitoring2014-03-28
Using WMI alerts to import SQL Server Default Trace eventsProfiler and Trace2014-03-14
Monitor SQL Server Database File Growth with WMI AlertsMonitoring2013-12-11
Monitor SQL Server Databases Changes Using WMI AlertsMonitoring2013-11-15
Different Ways to Find SQL Server Object DependenciesComparison Data and Objects2013-07-16
Multi Server Query SSRS Report using Central Management ServersReporting Services Development2013-05-15
Policy Based Management to find number of SQL data and log filesPolicy Based Management2013-04-29
Policy Based Management to check SQL Server database file extensionsPolicy Based Management2013-04-01
SQL Server Login Management using LOGINPROPERTY functionAuditing and Compliance2013-03-21
SQL Server Security Audit ScriptsAuditing and Compliance2013-03-07
Using Policy Based Management for checking SQL Server VersionsPolicy Based Management2013-02-04
Evaluating Policies on Multiple SQL Server Instances using Central Management ServerCentral Management Servers2013-01-31
SQL Server Multi Database Query with Registered ServersCentral Management Servers2013-01-17
SQL Server Database Security Audit (Part 1): What to expect?Auditing and Compliance2012-11-21

Categories

Recent Articles

  • SQL Server Transaction Log

  • 10 New Features in SQL Server 2025

  • Elevate Your ETL: Seamlessly Integrate Melissa’s SSIS Data Quality Tools with Azure Data Factory

  • Database Modernization with AI-Powered Tools

  • Optimizing SQL Server Integration: Automated Data Movement for Analytics and Operations

mssqltips white logo

MSSQLTips.com delivers SQL Server resources to solve real world problems for DBAs, Architects, DevOps Engineers, Developers, Analysts, Cloud and Business Intelligence Pros – all for free. The content we serve is all human written and based on our authors’ real-world experience. Check out tips, articles, scripts, videos, tutorials, live events and more all related to SQL Server on-premises and in the cloud.

Resources

Community

Subscribe

Be a better SQL Server Professional – Join MSSQLTips.com

Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
Facebook X-twitter Rss Envelope Linkedin
Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
sql server 2025 guide