SQL Bulk Insert has been tuned over the years to work well with the Microsoft .NET Framework. This tutorial shows you how to take advantage of its power.

Using SQL as your approach to interrogating data in one data component makes it easier to transfer over to using another option if your needs change.

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.

The world of the data professionals and DBAs is swirling with threats and risks, and those dangers are on the rise. You're probably accustomed to using longstanding database fea­tures to secure your ...

FileTables, a new feature introduced in SQL Server 2012, is a unique table that reflects metadata of files in a specified folder.

How to Create Full Database Backup Using T-SQL If you want to automate the backup, you can use the T-SQL code. T-SQL is the SQL Server language used to automate SQL Server tasks. The following example ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

If you are a developer experiencing “Connect to Server” errors using SQL Server Management Studio on your local machine or development box, consult the checklist below to quickly find, and fix ...