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

Posted on December 7, 2017 by Svetlana Golovko

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 December 6, 2017 by Svetlana Golovko

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 November 24, 2017 by Svetlana Golovko

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 #42 – SQL Server Edition Post-Downgrade Steps

Posted on September 21, 2017 by Svetlana Golovko

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 July 7, 2017 by Svetlana Golovko

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 #39 – Finding SQL Server Object Dependencies with DMVs

Posted on May 25, 2017 by Svetlana Golovko

This is the last tip about objects dependencies.

What should you know about the sys.sql_expression_dependencies DMV (Dynamic Management View)?

Please read the latest MSSQL Tip: “Finding SQL Server Object Dependencies with DMVs“.

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

MSSQL Tips: Tip #38 – Finding SQL Server Object Dependencies for Synonyms

Posted on May 10, 2017 by Svetlana Golovko

This tip describes how we can check SQL Server synonym dependencies (including for cross database situations).

Please read the latest MSSQL Tip: “Finding SQL Server Object Dependencies for Synonyms“.

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

MSSQL Tips: Tip #37 – Template to Create SQL Server Synonyms with checks

Posted on May 2, 2017 by Svetlana Golovko

When a SQL Server synonym is created with T-SQL the base object’s existence is checked only at run time. SQL Server Management Studio (SSMS) has some built-in checks that are performed during synonym creation whereas T-SQL scripts can be written several different ways and do not have any checks by default. In this tip I explain what is the best way to create synonyms and why.

Please read the latest MSSQL Tip: “Template to Create SQL Server Synonyms with checks“.

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