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

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

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

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/.

MSSQL Tips: Tip #39 – Finding SQL Server Object Dependencies with DMVs

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

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

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/.

MSSQL Tips: Tip #36 – Create Business Rules in SQL Server Master Data Services

In this tip we have provided the MDS Business Rules overview. You can also find out how to create a simple rule.

Please read the latest MSSQL Tip: “Create Business Rules in SQL Server Master Data Services“.

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

MSSQL Tips: Tip #35 – More Master Data Services (MDS) Tips and Tricks

Here are more tricks and tips that will help you to get more familiar with SQL Server Master Data Services (MDS), it’s functionality and interfaces.

Please read the latest MSSQL Tip: “More Master Data Services (MDS) Tips and Tricks“.

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

MSSQL Tips: Tip #34 – SQL Server Master Data Services (MDS) Tips and Tricks

In this and one of the following tips we will provide several tricks and tips that will help you to get more familiar with SQL Server Master Data Services (MDS), it’s functionality and interfaces.

Please read the latest MSSQL Tip: “SQL Server Master Data Services (MDS) Tips and Tricks“.

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

MSSQL Tips: Tip #33 – SQL Server Master Data Services (MDS) custom Delete Stored Procedure

By default entity members in Master Data Services (MDS) are not deleted permanently. They are “soft” deleted (deactivated) and available for recovery from a transaction history.

In this tip we have listed several methods for deleting MDS members and we have provided a script for the custom “delete” stored procedure.

Please read my¬†latest MSSQL Tip: “SQL Server Master Data Services (MDS) custom Delete Stored Procedure“.

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