Microsoft SQL Server articles

---

Databases create database using transact sql (mdf ldf) select database using transact sql Import Import a flat file Import flat file data into Microsoft SQL Server using Windows PowerShell (part 1) Import flat file data into Microsoft SQL Server using Windows PowerShell (part 2) Modify an Excel for import Install Install Microsoft SQL Server Developer in Windows Install Microsoft SQL Server Express in Windows Migration Transfer data from MySQL to SQL Server PowerShell Run a SSIS DTSX package using Windows PowerShell Stored procedures Stored procedures Tables Add a new column to a table Copy records from one table to another table Create a new table select tables using transact sql Troubleshooting Resolve "A network-related or instance-specific error occurred while establishing a connection to SQL Server" Resolve "Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF" Resolve "No extension None of the supported PHP extensions (SQLSRV MSSQL) are available" Resolve "None of the supported PHP extensions (SQLSRV, MSSQL) are available" Resolve "The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption." Resolve "The network path was not found" Users and Groups Create a new user username and password