New England SQL Server User Group

You spend at least an hour or two every day checking to make sure that your SQL Server databases are compliant with your organization’s best practices. Even if your day starts in chaos trying to resolve other urgent issues, you still need to perform these daily checks. Wouldn’t it be great if you can outsource these checks to someone (or something) who will be more than willing to do these day in and day out?

In this session, learn how you can leverage PowerShell to automate your daily checks to make sure that your SQL Server databases are compliant with your organization’s best practices. You will learn how to create your own automated checks and even display the results in a Power BI dashboard. This allows you to have more time to do things that only you can do.

The elephant in the room
The culture shock of moving from SQL Server to PostgreSQL

You are moving your data store from SQL Server to PostgreSQL and everything seems to be different.

In this talk, we'll discuss some fundamental differences between the two systems, rooted in the history of their development, from physical storage to transaction support, and from replication to backups. Be prepared for when it's time to flip the switch!

Prerequisites: Superficial familiarity with basic database concepts, such as indexing, transactions, and replication.

Audience: Database developers, DBA, and system architects.