#sqlcmd
This article organizes Microsoft’s SQL tools by role and use case, including SSMS, the MSSQL extension for Visual Studio Code, SQL Database Projects, sqlcmd, and SqlPackage.

#databases #Azure #AzureSQL #AzureSQLDB #SQLServer #vscode #visualstudiocode #SQL

learn.microsoft.com/en-us/sql/to...
SQL Tools Overview - SQL Server
SQL query and management tools for SQL Server, Azure SQL (Azure SQL database, Azure SQL managed instance, SQL virtual machines), and Azure Synapse Analytics.
learn.microsoft.com
October 26, 2026 at 3:36 AM
Schedule and automate backups of SQL Server Express databases. The article has been updated by Microsoft Learn with disclosed AI involvement (Sep, 2026).

#databases #Azure #SQLServer #ITTutorial #SQLServerExpress #SQLServerDBA

learn.microsoft.com/en-us/troubl...
Schedule and Automate Backups of SQL Server Express Databases - SQL Server
Learn how to use the sp_BackupDatabases stored procedure, sqlcmd utility, and Windows Task Scheduler to automate scheduled backups of SQL Server Express databases.
learn.microsoft.com
October 9, 2026 at 4:33 AM
Enumerating loopholes works when the mechanism list is finite — sqlcmd, Invoke-Sqlcmd. Ours wasn't. We run a store on AI agents; we banned phrases and the agent kept the behavior under new wording. Strings are enumerable, intent isn't. The fix was a property test on the draft.
July 28, 2026 at 2:37 PM
PowerShell: Invoke-Sqlcmd –Hostname Parameter sets the Application Name instead of the Host Name

blog.greglow.com/2026/06/27/p...
Powershell: Invoke-Sqlcmd –Hostname Parameter sets the Application Name instead of the Host Name
Two of the parameters in SQL Server connections are the Application Name and the Host Name. You can see these in SQL Server if you execute the following command: SELECT HOST_NAME() AS HostName,…
blog.greglow.com
June 27, 2026 at 5:52 AM
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger

I was messing around with SQLCMD and I realized something I hadn’t known. I’ve never tried it, but the batch separator has to be separate, which I’ll show. Another post for me that is simple and hopefully serves as an example for people…
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve never tried it, but the batch separator has to be separate, which I’ll show. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The Batch Terminator The default batch terminator in SQL Server tools is “GO”.
voiceofthedba.com
June 17, 2026 at 1:01 PM
What the fuck is homebrew/linuxbrew? Some Mac ass package manager to install go-sqlcmd on Linux? What happened to good old G-d fearing yum and apt?
June 17, 2026 at 12:53 PM
May 30, 2026 at 3:05 AM
May 27, 2026 at 11:44 AM
klist get <SPN> works, so not an SPN issue ✅
sqlcmd -S <server> always connects via NTLM ❌
May 26, 2026 at 9:40 AM
Most database projects focus on schema deployment. The real magic? SQLCMD variables 🪄

One project, environment-specific configuration, and reusable publish profiles 👇🏼
andybrownsword.co.uk/2026/05/05/s...
Smarter Database Project Deployments with SQLCMD Variables
A regular Database Project deployment is static and delivers consistent results regardless of environment. When it comes to schema, that’s usually desired, but data is a different s…
andybrownsword.co.uk
May 6, 2026 at 7:53 PM
SQL Server: SQLCMD mode and batch separators

blog.greglow.com/2026/04/22/s...
April 22, 2026 at 5:00 AM
FreeTDS is still around in the Ubuntu apt repos... no idea how often it gets updated, though. I tried it against an ancient MSSQL server we have at work and it worked fine. Dunno if it would break against the modern SQL server (if this helps): learn.microsoft.com/en-us/sql/li...
Ubuntu: Install SQL Server on Linux - SQL Server
This quickstart shows how to install SQL Server 2017 and later versions on Ubuntu and then create and query a database with sqlcmd.
learn.microsoft.com
April 18, 2026 at 10:27 PM
Opinion - permissions in databases should be provided to application roles. Creating the roles comes with code deployment. After the event, DBAs should add the relevant logins to the roles - this can be done via private repo using anything from sqlcmd to ado depending on the use case.
February 4, 2026 at 7:55 PM
airflow-sqlcmd-operator 0.5.1 (Alpha)

Custom Airflow BashOperator for Microsoft sqlcmd

Author: Rodrigo Dewes
📦Download

🏠Homepage
December 29, 2025 at 8:00 PM
If it's microsoft sql, Sqlcmd can do it with a sql job scheduing the script, or with SSRS you can have a subscription that can do the same thing but with less faffy scripting and permissions issues.
September 24, 2025 at 6:13 PM
PowerShell and a Windows Scheduled Task should be able to handle this for you. At a previous org I accomplished something similar.

learn.microsoft.com/en-us/powers...
Invoke-Sqlcmd (SqlServer) - SQL Server PowerShell
The Invoke-Sqlcmd cmdlet runs a script containing the languages and commands supported by the SQL Server SQLCMD utility. The commands supported are Transact-SQL statements and the subset of the XQuery...
learn.microsoft.com
September 23, 2025 at 4:53 PM
Guarda…non parlo, manco riuscivamo a digitare in sqlcmd gli script sql e per avere le istanze db+web pronte facciamo prima ad andare in pensione.
Cazzari fotonici
September 9, 2025 at 4:04 PM
go-sqlcmd to create containers. Even using it in production. For coding/trials/demos/teaching it's a no-brainer.
September 5, 2025 at 6:22 PM
This is a good way, but because SQL Server 2025 turns on encryption by default you need the prerelease sqlcmd 1.9x
September 4, 2025 at 3:02 PM
The new Sqlcmd makes it really easy because you can ask it to spin up an image and restore a sample database in a single command. Relies on you having docker or podman…

github.com/microsoft/go...
GitHub - microsoft/go-sqlcmd: The new sqlcmd, CLI for SQL Server and Azure SQL (winget install sqlcmd / sqlcmd create mssql / sqlcmd open ads)
The new sqlcmd, CLI for SQL Server and Azure SQL (winget install sqlcmd / sqlcmd create mssql / sqlcmd open ads) - microsoft/go-sqlcmd
github.com
August 30, 2025 at 3:25 PM
SSMS Tips and Tricks 4.9 Setting SQLCMD mode for all new query windows

blog.greglow.com/2025/08/15/s...
August 15, 2025 at 5:00 AM
#devesaurito
E tanto per dimostrarvi che le cagate le faccio (enormi) pure io:
sqlcmd-S ipserver -i script_ripristino.sql
Secondo voi, nello script, come prima cosa, ho specificato in quale DB ripristinare?
127 MB di oggetti cagati dentro il “master”, io un secondo dopo averlo eseguito:
June 30, 2025 at 5:19 PM
New blog post:
Which covers creating SQL Server 2025 containers in #Podman, #Qnap Container Station, #sqlcmd, and restoring a sample database to test the new version.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #container #docker #podman #qnap
Create a SQL Server 2025 container
This post covers creating SQL Server 2025 containers in Podman, Qnap, and sqlcmd, and restoring a sample database to test the new version.
vladdba.com
May 30, 2025 at 1:43 PM
New blog post:
Which covers a potentially breaking change that comes with the version of sqlcmd shipped with SQL Server 2025.
vladdba.com/2025/05/25/b...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
Breaking change in the sqlcmd version shipped with SQL Server 2025
This short blog post covers a potentially breaking change that comes with the version of sqlcmd shipped with SQL Server 2025.
vladdba.com
May 27, 2025 at 3:35 PM
Feed: "Cyber Security News"
By: Mandvi on Monday, May 26, 2025
Threat Actors Use Database Client Tools on Compromised Systems to Steal Sensitive Data
Investigators have observed a marked rise in threat actors leveraging DB client tools such as DBeaver, Navicat, and Microsoft's sqlcmd to steal data.
cyberpress.org
May 26, 2025 at 9:24 PM