SQL Operations Studio is a free tool that runs on Windows, macOS, and Linux, for managing SQL Server databases. I have a great experience running this tool on Linux CentOS and you can build server and database management dashboards like below. To create custom dashboards check out my tip https://www.mssqltips.com/sqlservertip/5434/customize-sql-operations-studio-dashboards/
What is Stretch Database?
Stretch Database is a feature of SQL Server where data can be split between on-premises storage and cloud storage. With Stretch Database, cold, historical data is kept in the cloud and active data is kept on-premises for maximum performance. Stretch Database requires no changes to client applications or existing Transact-SQL queries, so you can implement … Continue reading What is Stretch Database?
Thinking in Sets
Thinkins in sets is a great book by Joe Celko's. This book tell us about concepts how we need to think when we were working with databases. Columns are not fields, rows are not records and tables are note files, hence SQL is declarative, not procedural. There is no sequential access or ordering in table, … Continue reading Thinking in Sets
