Education/Courses

Featured

Posted on by

Listing of work-related courses/training I took:

  • Extend your datacenter to the cloud with Microsoft Azure
  • Active Leadership
  • DESIGNING A DATA SOLUTION WITH MICROSOFT SQL SERVER
  • Implementing a Data Warehouse with Microsoft SQL Server 2012
  • Administering Windows Server 2012
  • Administering Microsoft SQL Server 2012 Databases
  • Automating Administration with Windows PowerShell 2.0
  • Implementing and Maintaining a Microsoft SQL Server 2008 Database
  • ITIL V3 Foundation
  • Oracle 11g Administration I; Oracle 11g Administration II
  • Oracle 10g Performance Tuning
  • Troubleshooting and optimising database servers using Microsoft SQL Server 2005
  • Implementing Microsoft Office SharePoint Server 2007
  • Administrating and Automating Microsoft SQL Server 2005 Database & Servers
  • Updating Database Development Skills to Microsoft SQL Server 2005
  • Introduction to Oracle 9i: PL/SQL; Oracle 9i DBA Fundamentals
  • Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000
  • Implementing Business Logic with MDX in Microsoft SQL Server 2000
  • Database Administrator – Microsoft SQL Server 2000
  • Systems Engineer on Windows NT 4.0 (MSCE bundle).

MSSQLTips: Tip #48 – SQL Server Database Mail Health Check with Policy Based Management

Posted on by

Email alerting is an important feature that helps to automate a lot of Database Administration tasks. How can we be sure that Database Mail works properly? If there is email problem there is no another email that will notify us of an issue and it could be days before we realize that there is a problem.

In this tip we will provide a solution to check all of your servers for the different types of Database Mail issues. We are going to use Policy-Based Management (PBM) to perform these checks.

Please read the latest MSSQLTips post: “SQL Server Database Mail Health Check with Policy Based Management“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQLTips: Tip #47 – SQL Server Database Mail Health Check for all SQL Servers

Posted on by

Most of the SQL Server DBAs will agree that we rely on email alerts too much. Tasks are automated, we have emails notifying us of failed jobs, of errors, etc. But how can we be sure that emails are always sent? If there is an email problem there is not another email that will notify us of an issue and it could be days before we realize that there is a problem.

In this tip we will provide a solution to monitor all of your servers for the different types of Database Mail issues. We will provide a T-SQL script that is executed with a PowerShell script. The PowerShell script can be scheduled to run on a Central Management Server (CMS) or another SQL Server. In our example we will run it once a day to check the Database Mail health, but you can modify it and run it every hour or as often as you need.

Please read the latest MSSQLTips post: “SQL Server Database Mail Health Check for all SQL Servers“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQLTips: Tip #46 – Safely Dropping Unused SQL Server Indexes

Posted on by

There are many resources online about finding and dropping unused SQL Server indexes, but there a number of issues related to unused indexes removal. How can we make sure that we are dropping unused SQL Server indexes safely? What are the potential issues?

Some DBAs probably have an unused indexes review as part of their routine. Experienced DBAs understand the consequences of index removal and the potential issues. In this tip, we will review some of these potential issues and we will provide you with a couple of examples when you should just leave the indexes as is (even if they are unused).

Please read the latest MSSQLTips post: “Safely Dropping Unused SQL Server Indexes“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQLTips: Tip #45 – Drop Login issues for logins tied to SQL Server Availability Groups

Posted on by
Reply

During our regular security reviews we have discovered that one of the SQL Servers with Availability Groups has an individual DBA’s login in addition to the DBA group as a member of the sysadmin server role. The DBA is already a member of the DBA Domain group, so we are not sure why we had this login on SQL Server.

We have tried to remove the login, but couldn’t remove it.

In this tip we will be providing troubleshooting steps required for the Drop Login issues.

Please read the latest MSSQLTips post: “Drop Login issues for logins tied to SQL Server Availability Groups“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQLTips: Tip #44 – SQL Server Master Data Services Business Rules Notifications

Posted on by
Reply

You can validate Business Rules manually using MDS Explorer, Version Validation or the MDS Excel add-in. You can also automate validation of the Business Rules by using the mdm.udpValidateModel stored procedure. In this case we don’t have information about the validation results right away (as the validation process might run at night), but we can setup email notifications to review the Business Rules validation status later or without using the MDS Administrator site.

In this tip we will be providing steps required for the notifications setup.

Please read the latest MSSQLTips post: “SQL Server Master Data Services Business Rules Notifications“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQLTips: Tip #43 – SQL Server Agent Jobs Monitoring Script

Posted on by
Reply

Problems with SQL Server Agent Jobs can lead to missing backups, missing notifications about a failed job and sometimes missing mission critical tasks that are run as scheduled jobs.

Some of the common SQL Server Agent Job problems are described in other MSSQLTips tips. In this tip we have provided a single script that will check the jobs for a number of issues including:

  • Disabled SQL Server Agent Jobs
  • Failed SQL Server Agent Jobs or Job Steps
  • SQL Server Agent Jobs without a Description
  • SQL Server Agent Jobs without Schedules
  • Disabled SQL Server Agent Job Schedules
  • SQL Server Agent Jobs without Categories
  • SQL Server Agent Jobs Owned by a DBA or Other Privileged User
  • SQL Server Agent Jobs with no Owner or Owner Login is Denied “CONNECT TO SQL”
  • No SQL Server Agent Notifications on Job Failure or Completion
  • SQL Server Agent Operators Issues
  • SQL Server Agent Missing Job History
  • Potential SQL Server Agent Job Step Issue or Step Won’t Execute

Please read the latest MSSQLTips post: “SQL Server Agent Jobs Monitoring Script“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQLTips: Tip #42 – SQL Server Edition Post-Downgrade Steps

Posted on by
Reply

After downgrading SQL Server Enterprise Edition to the Standard one some of the configuration settings are reset to the default values. In this tip we provide examples of some of the issues you may have after the SQL Server Edition downgrade.

Please read the latest MSSQLTips post: “SQL Server Edition Post-Downgrade Steps“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQLTips: Tip #41 – Non-traditional ways to learn more about SQL Server

Posted on by
Reply

In this tip we have provided two non-traditional ways of learning SQL Server. These methods are not for exam preparation or for learning SQL Server from scratch, but more for learning small things that you may be not aware of or forgot about.

Please read the latest MSSQLTips post: “Non-traditional ways to learn more about SQL Server“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQL Tips: Tip #40 – SQL Server DBA On-Boarding Checklist

Posted on by
Reply

Database Administrator (DBA) on-boarding is not always as efficient as it could be. Whether this is for new full time employees or contractors. We often have to wait for system access, computers to be setup, the right software to be installed, etc. How can we be sure that the new DBAs are productive a soon as possible? How can we use highly qualified contractors in the most effective way from day one?

Please read the latest MSSQL Tip: “SQL Server DBA On-Boarding Checklist“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.