MSSQLTips: Tip #50 – Different ways to sort multi-server SQL Server query results using Central Management Server

Featured

Central Management Server (CMS) is a SQL Server feature that allows you to manage multiple SQL Servers at the same time. You can run T-SQL scripts or execute Policy-Based Management policies on multiple servers. You can also group SQL Servers and run the scripts on a specific group of SQL Servers.

How else can CMS be used? How can we overcome some of the limitations when we run queries against CMS Server Groups?

In this tip we will show you a couple of CMS tricks. In our examples below we will show how you can sort the CMS query results for different scenarios. We will also provide a couple of examples of alternative uses of CMS.

Please read the latest MSSQLTips post: “Different ways to sort multi-server SQL Server query results using Central Management Server“.

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

Share

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

Featured

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

Share

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

Featured

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

Share

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

Featured

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

Share