SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer ...

How to Attach an SQL Database to a Web Page. Your Web page can display up-to-date information dynamically -- all the time. And you never have to edit the page again. Attach your SQL database to ...

Repair a corrupted SQL database by running Recovery Toolbox's repair solution. (Photo : Kevin Ku / Unsplash) Over the years, servers have suffered terribly from malicious attacks that users had to ...

With the latest public preview available, it's time to see if you want to upgrade to the most cloud-connected version of SQL Server so far.

This software repairs the database based on the SQL Server data file. It can restore tables, views, stored procedure, functions, and other SQL Server database objects.

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups.

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...

By using a single tool like PowerShell, you can access your data wherever it is stored. It does not matter if it is in the cloud in an Azure SQL database or in an on-premises MS-SQL server, MySQL or ...

Create a database table to log data in SQL Server You might want to create the log table yourself as well. Below is the script you can use to create a log table in the SQL Server database.

If screaming speed in data access is the most important thing in your life, SQL Server's durable in-memory, memory-optimized tables are your answer. They were good in SQL Server 2014 and they're even ...