In this article you will learn how to use BCP for SQL Server on Linux to export and import data using the BCP command line utility.

Surrender, Just a Little

by Grant Fritchey

SQLServerCentral

Career Growth

Today, Grant talks about how giving up a little control can be useful.

Cloning all the Databases on a Server

by Additional Articles and Phil Factor

Redgate

Phil Factor shows uses SQL Clone and PowerShell to automatically create images of all databases on an instance, if they don't already exist, and then create or refresh clones of each one, on all your development servers.

SQL Server Attach and Detach Database Examples

by Additional Articles

MSSQLTips.com

In this article Dinesh Asanka looks at how to detach and attach a SQL Server database using the SSMS GUI and using T-SQL commands.

Creating a Logical SQL Server: Level 2 of the Stairway to Azure SQL Database

by Arun Sirpal

SQLServerCentral.com

In this second level of the Stairway to Azure SQL Database, we cover the basics of building a logical server using the portal and PowerShell.

Why A Query May be Faster the Second Time it Runs

by Kendra Little

SQLServerCentral

Query Tuning

Today, Kendra Little explains why a query may run faster the second time you run it.

Removing the Square Bracket Decorations with SQL Prompt

by Additional Articles and Phil Factor

Redgate

SQL PROMPT

If you avoid illegal characters and reserved words in your identifiers, you'll rarely need delimiters. Sadly, SSMS applies square bracket delimiters indiscriminately, as a precaution, when generating build scripts. Phil Factor provides a handy function that adds quoted delimiters only where they are really needed and then sits back and lets SQL Prompt strip out any extraneous square brackets, in a flash.

Running Database Console Commands (DBCCs) on Azure SQL Database

by Additional Articles

Database Journal

Azure SQL

Practically every SQL Server Database Administrator operating in an on-premises environment is familiar with Transact-SQL DBCC statements that serve the role of Database Console Commands. However, there are some additional considerations that should be considered when using them in the context of Azure SQL Database deployments.