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”.
Loading...