Quickly Investigating What's in the Tables of SQL Server Databases
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Wed, 20 Aug 2014 06:00:00 UT
Indexed on
2014/08/21
22:24 UTC
Read the original article
Hit count: 220
From SQL Server Management Studio it's hard to look through the first few rows of a whole lot of tables in a database. This is odd, since it is a great way to get quickly familiar with a database. Phil tidied up a SQL routine he uses to investigate databases quickly in a browser. He explains how to use it, how it works, and how to use it from PowerShell.
Want faster, smaller backups you can rely on? Use SQL Backup Pro for up to 95% compression, faster file transfer and integrated DBCC CHECKDB. Download a free trial now. |
© SQL Server Central or respective owner