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

SSMS – Having “Select and Print” Share Same Output Space with sqlcmd mode

Background Ever since I can remember, transact SQL select and print statements send do not share same output area; especially when the the "Results To" is Grid. SQL For instance this SQL Statements produces both a Grid and a Text Output. Code Output Grid Text   Another Way Like TC, Tevin Campbell, another way, is … Continue reading SSMS – Having “Select and Print” Share Same Output Space with sqlcmd mode

Error processing execution plan results. The error message is: There is an error in XML document

Background Tried to access a Query's execution plan and ran into a wall. The error is pasted below. Error Message Image Text   Resolution Looked more into it. And, determined that I was using SQL Server Management Studio v2005. In this case I should be using a newer version, v2014 to be exact.

SSMS – v2008 – Error – “Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)”

Background Drew a quick error running Sql Server Management Studio (SSMS). Error Text The error reads :- Index was outside the bounds of the array. (Microsoft.SqlServer.Smo) Image Explanation Error reads Microsoft.SqlServer.Smo Index was outside the bounds of the array Recreate Tried connecting to Microsoft SQL Server v2017 instance with Sql Server Management Studio v2008.   … Continue reading SSMS – v2008 – Error – “Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)”

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