This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQLOutlook, SQL Server, database, file locations.

SQL SERVER – Find Current Location of Data and Log File of All the Database

February 17, 2009
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server Security, SQL System Table

A one line query on sys.master_files that shows the current data and log file location for all databases, handy when cleaning up old .mdf and .ldf files.

Read More
SQL SERVER - Reasons to Backup Master Database - Why Should Master Database Backedup

SQL SERVER – Reasons to Backup Master Database – Why Should Master Database Backedup

February 15, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Backup and Restore, SQL Data Storage, SQL Server Security, SQL Utility

Why should you backup master database? It holds all logins, system configuration and the details SQL Server needs to reach every other database.

Read More
SQLCMD command window with a query.

SQL SERVER – Restore Master Database – An Easy Solution

February 14, 2009
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server Security, SQL Utility

A two step easy way to restore master database: start SQL Server in single user mode, then restore from a full backup of master. No full backup, no restore.

Read More
SQL Server Management tools.

SQL SERVER – Start SQL Server Instance in Single User Mode

February 10, 2009
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio, SQL Server Security, SQL Utility

How to start a SQL Server instance in single user mode: add the -m; startup parameter in SQL Server Configuration Manager and restart the service.

Read More
A garden snail carries its shell from one wet stepping stone to the next, a silver trail behind it.

Contained Databases and Contained Users

February 5, 2009
Pinal Dave
SQL Tips and Tricks
DBA, SQL Login, SQL Migration, SQL Server Security

Understand contained users in SQL Server databases, how they travel with a database, and the security trade-offs of partial containment.

Read More
Displaying AdventureWorks database files.

SQL SERVER – Shrinking NDF and MDF Files – A Safe Operation

January 25, 2009
Pinal Dave
SQL Performance
SQL Data Storage, SQL Scripts, SQL Server DBCC, SQL Server Security

Is shrinking NDF and MDF files safe? A reader asked if it causes data loss. It does not, but I explain why shrinking them is often not a good idea.

Read More
A small serving hatch in a brick wall with a tray of loaves on its ledge, the bakery kitchen hidden behind the wall

Connecting Excel to SQL Server Safely

January 24, 2009
Pinal Dave
SQL Tips and Tricks
Excel, SQL Server, SQL Server Security, SQL View

Connecting Excel to SQL Server safely means a narrow read-only view, a scoped login, controlled refresh load, and no saved password in the workbook.

Read More
Previous 1 … 40 41 42 43 44 45 46 … 57 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com