SSMS – AWS/RDS – Error – “The EXECUTE permission was denied on the object ‘xp_regread'”

Background When SQL Server Management Studio ( SSMS ) is ran against an Amazon/RDS SQL Server instance, we can get a little error. Error The error reads :- Error Message Image Text Error Message - Advanced Information Image Text Explanation Looking at the Stack Trace the error occurs at :- Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName() TroubleShooting What is the … Continue reading SSMS – AWS/RDS – Error – “The EXECUTE permission was denied on the object ‘xp_regread'”

SSMS :- Integration Services Catalog – Create Catalog – Version Compatibility

Background Needing to deploy SSIS packages on a new machine, noticed that the SQL Server Instance has yet to be provisioned with an Integration Services Catalog. Let us address fairly quickly. Outline Launch SQL Server Management Studio ( SSMS ) Connect to the SQL Server Instance Navigate to the Integration Services Catalog Create Catalog Right … Continue reading SSMS :- Integration Services Catalog – Create Catalog – Version Compatibility

SQL Server – SSMS – Query Plan – Compare

Background One of my favorite go to tool with SQL Server Query troubleshooting is to simple use SQL Server Management Studio (SSMS) to compare the query plans generated via running the same SQL across different machines or SQL Server Versions.\ Use To use, please follow these simple steps :- Invoke SSMS Query 1 Enable "Include … Continue reading SQL Server – SSMS – Query Plan – Compare

SQL Server On Linux – Post Installation – Configuration – Set Folders

Background Upon installation, SQL Server on Linux utilizes the same storage folders for data, log, and backups. Outline Review Current Settings Provision Folders Register Folder Settings on SQL Server Restart SQL Server Review new folder settings Processing Review Current Settings SQL Server Management Studio ( SSMS ) Let us use our GUI Tool, SSMS, to … Continue reading SQL Server On Linux – Post Installation – Configuration – Set Folders

SQL Server Agent – Configuration on Linux

Background Post installation of SQL Server on our Linux Box, it is time to review our SQL Server Agent component. Lineage SQL Server – Installation on Linux/CentOS Link Check List Let us go through our checklist. Outline Is SQL Server Configured? SQL Server Metadata sys.dm_server_services SQL Output Explanation sys.dm_server_services Startup Type Automatic Status Stopped Service … Continue reading SQL Server Agent – Configuration on Linux