How to Restore Files and Filegroups Using T-SQL. Alternatively, you can use the T-SQL commands to restore a database file or filegroup. RESTORE DATABASE [Northwind] FILE = N'Northwind' FROM DISK = N'C ...

Note: Since the node name may differ depending on your version(s) of SQL Server, the simplest way to find it is to open regedit and search for SQLDataRoot. Using T-SQL, there's an extended stored ...

With SQL Server Ledger, the blockchain technology is centralized within the core SQL Server database engine, so there are no complex setup requirements, and delivers significantly better performance ...

Transact SQL, or T-SQL, provides you with the language to create the dynamic code. It retrieves data from a database and adds data into your server's tables. Click the Windows "Start" button and ...

Joey on SQL Server. Why SQL Server Is Still Worth It. Despite its steep licensing costs, SQL Server continues to prove its worth over open-source alternatives in some key areas.

The program only generates a T-SQL script; it does not make any changes to the database structure or data directly when run. Print statements are included throughout the script to display a log of ...

T-SQL Smarts -- Preventing Injection Attacks . Working with dynamic SQL is all well and good, but avoid the risks that can lead to your code being susceptible to a SQL injection attack.

In SQL Server Management Studio (SSMS), you can see the SQL Server database state. Alternatively, you can use T-SQL commands to verify your database status. You can use the DATABASEPROPERTYEX function ...

To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages. I am going to be focusing on the SQL Server 2012 packages in this article.

A view is a saved T-SQL query in SQL Server. ... Tim Chapman is a SQL Server database administrator who works for a bank in Louisville, KY, and has more than 7 years of IT experience.