Luke Campbell’s Post

We are thrilled to announce the launch of our brand new SQL Server Scripts repository powered by the Pure Storage PowerShell SDK2! 💻 The repository covers snapshot, clone, recovery, and advanced automation scenarios tailored specifically for SQL Server environments...enabling you to decouple space and time for your data! Here's what you can expect: 🔄 Seamless Database Refreshes ⏰ Point in Time Recovery Capabilities 🌱 Availability Group Seeding from Snapshot 🔍 Multi-Array Snapshots 🛠️ ActiveDR Failover and Failback Scenarios ... and the list goes on! Check out the code: https://lnkd.in/eHiR44Vk This achievement wouldn't have been possible without the incredible teamwork of Andy Yun and Andrew Pruski 🙌 #SQLServer #PowerShell #PureStorage

Understand SQL Server Management Studio

Today's blog provides a tutorial for generating a table of records in PowerShell using a .NET DataTable object and saving that data to a SQL Server table. If you're interested in manipulating ADO.NET data objects within PowerShell and saving your results to a SQL Server table, this post should point you in the right direction. You can read the full post at the following URL: https://lnkd.in/gV4QXWE5 #sqlserver #sqlserverdba #sqlserverdeveloper #powershell #sqltips

Just released the first video in the Stream Processing series "Stream Processing 101 - An introduction" https://lnkd.in/esPqTTdp I hope you like it :) ps: like, share and subscribe. #streamprocessing #risingwave #sql #postgresql #kafkastreams #flink

Today's blog continues our look at using PowerShell scripting to improve our efficiently as DBAs. Rolling out configuration changes to a large number of SQL Server instances can be a daunting manual task. This post walks you through a script that connects to a SQL Server instance, retrieves current configuration settings, updates these settings, and applies the changes. You can read the full post here: https://lnkd.in/gVN9_qb3 #sqlserver #sqlserverdba #powershell #sqltips

#8 - Docker Volumes for SQL Server to persist data In this eight lecture of our course Understanding Docker in 2024, we will understand how Docker volume persists SQL Server data https://lnkd.in/gafjqrie #executeautomation #docker #dockerimages #containers

Today's blog takes a look at GO-SQLcmd. Learn how Go-SQLcmd enhances the traditional SQLCMD by providing a lightweight and efficient way to manage SQL Server environments using Docker containers. You can read the full post at the URL below: https://lnkd.in/g22BzYRc #sqlserver #sqlserverdba #sqltips

✨ Dive into the world of Apache Airflow and Docker with my latest Medium post! 🚀 🔍 In this article, you'll discover: 1️⃣What is Airflow and Docker? A beginner-friendly introduction to these powerful tools for workflow automation and containerization. 2️⃣ Pre-configurations for Airflow: Learn how to set up Airflow with Docker and WSL2 to work seamlessly with a local SQL Server. 3️⃣ Testing Connections with a DAG: Step-by-step guidance to create and trigger a DAG that verifies your database connection. 💡 Whether you're new to Airflow or looking to enhance your data engineering skills, this guide will help you get started with confidence! 👉 Read now: https://lnkd.in/g_-BWgjT Your thoughts and feedback are always welcome! 🙌 #airflow #dataengineering #docker

grafana + prometheus + sql server

Suggestions, comments, and feedback on using Datadog for a SQL Server monitoring? #sqlserver #alerting #monitoring #observability #databases #applications