Do you need to find out where the location of your SQL Server's database is? Use this quick tip from Arthur Fuller to show you how. Sometimes your application needs to know the specific directory ...

including the full device and directory path, as the following example illustrates:c:\data files\my_data.mdfClick the "OK" button. SQL Server Management Studio loads the database from the .MDF file.

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 ...

Locate the directory of your SQL Database needing to be moved. By default (which isn’t a good practice) the location of your databases are here: C:\Program Files\Microsoft SQL Server\MSSQL10_50 ...

Another effective automation method is using T-SQL Scripts with SQL Server Agent. This method is more popular with DBAs who operate within a database instance. In addition to the standard commands ...

SQL Server database corruption is troublesome for DBAs, particularly if the situation arrives suddenly and there is no backup. This situation can lead to prolonged downtime and permanent data loss in ...

To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages. I am going to be focusing on the SQL Server 2012 packages in this article.

Within SQL Server, temporary tables are stored in the Temporary Tables folder of the tempdb database. Transactions allow you to group SQL commands into a single unit. The transaction begins with a ...