MSSQL Tips: Tip #17 – Using Policy Based Management to check that SQL Server indexes are created in the correct filegroup

Another tip about using Policy Based Management for the SQL Server checks.

Please read the latest MSSQL Tip: “Using Policy Based Management to check that SQL Server indexes are created in the correct filegroup“.

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

Share

MSSQL Tips: Tip #11 – Script to get CPU and Cores for SQL Server 2012 Licensing

This MSSQLTips tip will help you to audit your SQL Server licensing with PowerShell script.

Please read the latest MSSQL Tip: “Script to get CPU and Cores for SQL Server 2012 Licensing“.

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

Share

MSSQL Tips: Tip #10 – Different Ways to Find SQL Server Object Dependencies

In my 10th MSSQLTips tip you will learn about different ways to display objects dependencies and you will learn how to use provided scripts in your day-to-day work.

Please read the latest MSSQL Tip: “Different Ways to Find SQL Server Object Dependencies“.

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

Share

MSSQL Tips: Tip #9 – Creating a multi-server query SSRS report using Central Management Servers

In this tip I demonstrate how to create single SQL Server Reporting Services (SSRS) report that will display SQL Servers versions for all of the SQL Servers that are registered in Central Management Server.

Please read this MSSQL Tip: “Creating a multi-server query SSRS report using Central Management Servers“.

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

Share

MSSQL Tips: Tip #8 – Using Policy Based Management to check number of SQL Server data and log files

In this tip I explain how to make sure that you have only one database transaction log file and more than one data file using policy based management.

Please read this MSSQL Tip: “Using Policy Based Management for checking SQL Server database file extensions“.

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

Share