Tag: SQL Server

All the articles with the tag "SQL Server".

• SQL Server Loop

  Published:Oct 1, 2016 |  at 04:15 AM

  Learn how to create a simple loop in SQL Server to automate repetitive tasks.

• MSSQL Collation Management

  Published:Mar 2, 2016 |  at 11:32 PM

  Learn how to change the collation of a SQL Server database and its columns, ensuring consistency across tables.

• MSSQL Full-Text Search Configuration and Check

  Published:Feb 9, 2016 |  at 12:26 AM

  Learn how to configure and check for Full-Text Search capabilities in MSSQL Server, including verifying installation status.

• Step-by-Step Guide to Running NopCommerce on Microsoft Azure

  Published:Dec 6, 2015 |  at 08:03 AM

  A comprehensive step-by-step guide to deploying NopCommerce 3.1 on Microsoft Azure Cloud Service and Azure SQL Database.

• MSSQL Over LAN

  Published:Jul 30, 2015 |  at 03:00 AM

  A guide to configure MSSQL to work over a Local Area Network (LAN).

• EF with SP using ExecuteSP

  Published:Jul 14, 2015 |  at 06:39 AM

  Explanation of how to use stored procedures in Entity Framework (EF), particularly with dynamic queries and temporary tables, and how to handle the limitations EF has with such SPs.