sqlcmd Archives - Page 2 of 4 - SQL Authority with Pinal Dave

SQL SERVER – How to Set Variable and Use Variable in SQLCMD Mode

June 28, 2013

Here is the question which I received the other day on SQLAuthority Facebook page. Social media is a wonderful thing and I love the active conversation between blog readers and myself – actually I think social media adds lots of human factor to any conversation. Here is the question – “I…

SQL SERVER – Interview Questions and Answers Sample Chapter Free Download – SQL in Sixty Seconds #050

April 24, 2013

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, sqlcmd

This journey of SQL in Sixty Seconds we started almost a year ago and today we are at very interesting milestone where I am recording 50th episode. Thought I wanted to keep the length of each video to sixty seconds, sometimes it went up by a few seconds. Due to this we are also at very…

SQL SERVER – Remove Cached Login from SSMS Connect Dialog – SQL in Sixty Seconds #049

April 17, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio, sqlcmd

One of the most annoying thing which I have personally come across is drop down list of Server Lists on Connect dialog in SQL Server Management Studio. Here are two of the cases when I want to delete something from SSMS Connect Screen: 1) Incorrect server name typed 2) Server…

SQL SERVER – Enable SQLCMD Mode in SSMS – SQL in Sixty Seconds #048

April 10, 2013

Pinal Dave

SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Server Management Studio, sqlcmd

The sqlcmd utility is a command-line utility for ad hoc, interactive execution of Transact-SQL statements and scripts and for automating Transact-SQL scripting tasks. Often a developer believes that sqlcmd works with only command prompt, however that is not true. sqlcmd can also work with SQL Server Management Studio. There are lots of cool tricks we can do with sqlcmd while we are using it along with T-SQL.

SQL SERVER – Exporting Query Results to CSV using SQLCMD

March 5, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

sqlcmd

Social media is evolving at a rapid pace and every day I keep on getting question from different methods. Here is the latest question which I received on my Facebook page. The question was how to export the data of query into CSV using SQLCMD. This is indeed very easy…

SQL SERVER – Backup and Restore Database Using Command Prompt – SQLCMD

February 8, 2013

Pinal Dave

SQL Video

SQL Backup, SQL in Sixty Seconds, SQL Restore, SQL Scripts, SQL Server, sqlcmd

Backup and Restore is one of the core tasks for DBAs. They often do this task more times than they would have ideally loved to do so. One thing I noticed in my career that every successful DBA knows how to automate their tasks and spend their time either playing games on a computer or learning something new!

SQL SERVER – Fix Visual Studio Error : Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL

November 30, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, sqlcmd

In one of the virtual environment while I was trying to add SQL Server Database (.mdf) file to asp.net project I encountered following error: Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: …