Let’s get back to DBAs@Midnight, and talk enterprise management in SQL Server.

This time, here’s what’s up:
– Colorado Forest Fires: Yup, we had to evacuate the house for about 4 days last week. Luckily, nobody hurt and the house still stands!

– SQL Server and PowerShell: That’s what we’re all about. This series of DBAs at Midnight is dedicated to managing SQL Server instances in an enterprise environment.

– Announcement: SQL Saturday Denver! Sean taught a whole day of PowerShell, and we live streamed it. Vids: https://www.youtube.com/@MidnightDBA/streams

– Enterprise Principle #2: “The More Things Change, the More They Stay the Same”: Yeah yeah yeah, new versions and features. But the *core* elements of SQL Server have remained consistent over time.
– SQL Server Version Compatibility: Scripts can be written to be compatible across multiple versions of SQL Server, from older versions like SQL 2000 to the latest ones.

– Coding Best Practices: You can – and SHOULD – use a single script to manage multiple SQL versions. “Data, then usage” principle.

– Normalize your Code: Structure your code to reduce redundancy and increase efficiency.

– Object-Oriented Programming (OOP) Concepts: You can apply OOP principles, like not repeating code (DRY – Don’t Repeat Yourself), in SQL Server management.

– Closing: We’re attending the upcoming PASS Community Data Summit! Not sponsoring or speaking this year, which means another year of…..well, not “relaxing” exactly. But “not stressing”.

Here is our no-nonsense, live LinkedIn event recording: “The Ultimate Guide to SQL Server Management with Minion Enterprise.”

Ask about the Minion Enterprise Starter Pack: https://www.minionware.net/automation-starter-pack/
Contact us: Sales@MinionWare.net

This event is designed for SQL Server professionals who demand efficiency and results.

Here are 5 things you will discover:

1. Automated Maintenance: How to automate backups, index maintenance, and more, saving you valuable time.
2. Comprehensive Monitoring: How to monitor all your SQL Servers from a single dashboard with real-time alerts.
3. Advanced Security: How to protect your data with robust security features, including detailed audit logs and user activity tracking.
4. Scalable Management: How to easily manage hundreds of servers. Minion Enterprise scales with your business.
5. Performance Optimization: How to identify and resolve performance bottlenecks with detailed insights and recommendations.

This is a must-attend event for SQL Server DBAs, database developers, and IT managers.

It’s time to elevate your SQL Server management game with Minion Enterprise.

Have you ever wondered how Windows keeps track of file security, or how it knows which attributes are assigned to each file? The answer is named file streams. Here I discuss what file streams are and how to work with them.

Have you ever wondered what prepared SQL is? It’s something you see in both profiler and xevents all the time. Here I explain what it is and how to use it.

This is the intro to backup that set the mood for the rest of the classes.

You can create custom columns using expressions in format-table.
Here I show you how.

Once Minion Enterprise is installed and configured, you need to know your way around!

Here we quickly cover:
– the heart of M.E., the dbo.Servers table
– shortcut functions dbo.ServerName() and dbo.ServiceLevel()
– “Collector” schema tables
– “Collector” schema views: Current and Previous

Continuing with desktop apps, we talk about populating combo boxes, and putting the code in methods where it belongs.

Here we’re starting with the basics of C# desktop apps for those who have never done it before.
We start out with creating the project, the basic layout of where code is written, events, and more.

Here I’m talking about scale-out vs scale-up, along with SQL log basics and Restore with Move.