Open links in new tab
  1. How to Create SQL Server Management Studio 18 (SSMS) Extension

    Apr 7, 2019 · The SSMS team at Microsoft finally decided to remove the constraint that allowed only extensions with whitelisted package ids to be loaded into SSMS. Now you just develop …

  2. Create a SQL Server Management Studio Extension - CodeProject

    Jul 2, 2021 · For years I’ve been using excel or dynamic SQL to generate SQL scripts to do data loads and updates and to generate IN predicates . For a small number of rows or values this is …

  3. Options for Database Backup and Restore - How to Export …

    Apr 5, 2021 · This article describes the options to restore and backup database in SQL Server and explains how to Export BACPAC from SQL Server Management Studio.

  4. spSearchTables: Search and Find Tables or Columns by Name or …

    Oct 26, 2023 · Here follows a sample table output: spSearchTables logs for troubleshooting in the Messages tab in SSMS the general script at the beginning followed by all the queries issued …

  5. HowTo: Install the Northwind and Pubs Sample Databases in SQL …

    Oct 4, 2009 · Note: SQL Server 2005 Users Click Here for the SQL Server 2005 version of this article Download Northwind and Pubs database files only - 1.17 MB Download Northwind and …

  6. Exploring Database Schemas on SQL Server - CodeProject

    Oct 20, 2008 · Learn how to quickly and easily explore database schemas in SQL Server using GUI and SQL INFORMATION_SCHEMA features.

  7. Learn to Write Custom MDX Query First Time - CodeProject

    Jan 14, 2014 · Using SQL Server Management Studio (SSMS), we can only browse values on two axis, Columns (Axis 0) and Rows (Axis 1). Getting Started With MDX 1. Start with Simple …

  8. Export All Tables from Microsoft SQL Server Database in Flat File ...

    Jul 15, 2020 · We will use T-SQL Cursor to prepare script and run BCP commands for each table of the selected database and execute command using Windows command shell xp_cmdshell …

  9. How to Migrate SQL Database to Azure SQL Database using SSMS …

    Nov 26, 2018 · As a next step, this article tells about migrating SQL Database to Azure SQL Database using SQL Server Management Studio (SSMS) deploy. In the next few articles, we …

  10. Dev's User Guide To SqlLocalDb (Sql Express) - CodeProject

    Aug 14, 2017 · It also provides us with the named pipe that we can use to connect to the server instance using SSMS (Sql Server Management Server). However to connect to this database …