Microsoft SQL Server vs Snowflake

Comparing Microsoft SQL Server vs Snowflake

Snowflake is a cloud-based data warehouse. Sure, you can integrate streaming data, work with unstructured data, and build it into an encompassing data lakehouse. But Snowflake is a cloud-based data warehouse. It’s meant to process data for your business analytic purposes. If your use case is not building a data warehouse, but rather an OLTP...Continue reading

automate to delete aged backup files

How to Automate PowerShell Scripts through Task Scheduler to delete SQL Server backup files

Although there are many different ways to automate deleting SQL Server’s old backup files on the SQL Server, because of some permission issues for this specific client, I used Microsoft Windows Task Scheduler to help me automatically launch a PowerShell script to purge the unwanted files. I also prefer to use a PowerShell script since...Continue reading

SQL Server 2016 and SQL Server 2019

What are some differences between SQL Server 2016 and SQL Server 2019

Over the last few years, SQL Server had three major releases: SQL Server 2016 SQL Server 2017 (with the big milestone of SQL on Linux) SQL Server 2019 Compared to those two previous versions, SQL Server 2019 has some new and valuable features, such as Big Data Clusters, additional capabilities and improvements, SQL Server Analysis...

SQL Integration Services Catalog

How to create the SQL Integration Services Catalog

The Integration Services Catalog was introduced in SQL Server 2012 to provide in-house logging and reporting infrastructure. SSISDB database is central place for SSIS projects to execute a wide range of data migration tasks: Database backup Database encryption Support for environments Support project and package parameters Package versioning Customer SSRS performance reports built into SSMS...Continue reading

retrieve linked server information from master database backup

How to retrieve linked servers out of system database backup files in SQL Server

After a big disaster crash on one of our customers SQL Server 2016, luckily, we had the data and log files of a SQL-Server that has crashed. User databases have been restored. But we also needed to retrieve linked servers details. We attached the old master databases with a different name “master_recover” and also attached...Continue reading

retrieve logins from a master database backup file

How to retrieve logins from a master database backup file in SQL Server

After a big disastrous crash on one of our customers SQL Server 2016,  the server could not be brought online. But luckily, we were able to recover most of everything from our scheduled full backups. User databases have been restored easily but we also needed to retrieve logins details that have been there before the...Continue reading

Scroll to top