147 example scripts for managing SQL Server objects. Initialize PowerShell modules and work with databases. Scripts for Analysis, Integration, and Reporting services. Support for SQL Server 2016 & 2017, Azure SQL Database, and Windows Server 2016.
SQL Data Profiler is a free tool that provides quick visibility into data patterns contained in SQL Server databases from a single user interface. Its user interface simplifies exploring patterns in data by streamlining and automating the process.
Get one visual view of storage in all tables of a database. See storage allocation, utilization, and type of data. Great for capacity reviews and planning. Quickly locate tables and indexes that need more allocated storage.
Displays page level data summary and detail information. Elegant GUI design for fast access in one click. Select any SQL server and database table. Navigate to any page data quickly in a tree view. Launch directly within SSMS for optimal usability.
Monitor the impact of memory optimized tables on server memory. Identify high memory utilizing tables. Assess server memory capacity. Simulate moving to In-Memory OLTP.
Discover all SQL Server versions. Patch compliance checks on SQL servers. Discover important information about SQL Server instances. Simple installation, no agents required.
Launch directly within SSMS for optimal usability. Identify out-of-date SQL Server table and index statistics. View and change database statistics options. Create graphical histograms for each columns statistics.
Aggregate IO statistics to identify problem tables. Correlate disk activity with query plan nodes. Compare runs of a query over time. Export and import results for easy collaboration.