dbForge Studio for SQL Server from Devart is a powerful IDE for managing, configuring and developing SQL Server, with coding help and SQL formatting.
SQL SERVER – Playing with Backups and Compression
Playing with backups and compression at a client showed how much disk space old habits were wasting. Here is the test and what we found.
SQL SERVER – Simple Example of BCP Command Line Utility
Need to export table data fast? A step by step, simple example of the BCP Command Line Utility, from finding bcp.exe to running the export.
SQL SERVER – Database Backup and Restore Job Management
ApexSQL Backup handles database backup and restore job management: full, differential and log backups you can schedule and monitor from one place.
SQL Complete – Smart Code Completion and SQL Formatting
My impressions of dbForge SQL Complete 5.5: SSMS 2016 integration, support for the new SQL Server 2016 syntax, smarter code completion and SQL formatting.
SQL SERVER – Create Database and BI (SSAS, SSRS, SSIS) Documentation
ApexSQL Doc documents SQL Server databases and BI items (SSAS, SSRS, SSIS) in CHM, HTML, PDF or Word format, from a GUI or the command line.
How to Use Zip With SSIS? – Notes from the Field #130
SSIS has everything for moving files except zipping them. Kevin Hazzard shows how to zip data files inside an SSIS package before sending them over FTP.