Command-line utilities enable you to script [!INCLUDE ssdenoversion-md] operations. The following table contains a list of several command-line utilities that ship with [!INCLUDE ssNoVersion]. For ...

Sometimes, you may be unable to perform a sync on the server. Maybe you’re trying to sync a resource that doesn’t exist, or maybe you’ve got too much data and ...

Migrating your SQL Server to a new server or platform can be a challenging and time-consuming task. You need to ensure that the data, schemas, permissions, jobs and server settings are transferred ...

You may encounter the SQL Server Error 18456 if the server could not authenticate the connection and this can be caused by the non-availability of the administrator ...

The following T-SQL statement retrieves information such as Hostname, Current instance name, Edition, Server type, Service Pack and version number from current SQL Server connection. 'Edition' will ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Often overlooked, it's a powerful tool that can make your life a lot easier. Especially now that Microsoft has updated its functionality. It is safe to say that the command line tool sqlcmd has not ...

Part of the SQL Server 2022 blog series. In SQL Server 2008 Enterprise Edition, backup compression was introduced adding WITH COMPRESSION as an option in the T-SQL backup command. SQL Server backup ...

Mary writes for the programming section and has been doing so for the past two years. Her educational background is in Computer Science and Physics. By restoring an SQL database, you can recover from ...

Volume Shadow Copy Service or VSS enables the Windows computer to create snapshots of your local files. The Vssadmin command-line tool allows to access these snapshots, and lists and deletes the ...