Explore how to use SQL Server CLR Integration to enhance database functionality with .NET languages. This detailed guide covers enabling CLR, creating and deploying .NET assemblies, and executing CLR functions in SQL Server. Learn the benefits of using managed code for complex operations and accessing extensive .NET libraries, with a step-by-step example for practical implementation.
Author: Stephen Planck
SQL Server on Linux: Getting Started with SQL Server 2022 on Red Hat 9
Learn how to install and configure SQL Server 2022 on Red Hat Enterprise Linux (RHEL) 9. This guide provides step-by-step instructions for adding the Microsoft repository, installing SQL Server and its tools, and performing basic configurations to optimize SQL Server for enterprise environments on RHEL 9.
Taking Action with SQL Server Triggers: Automating Tasks for Efficiency
This post explores SQL Server triggers, a tool for automating database tasks. Learn how triggers can enforce data integrity, maintain referential integrity, and automate routine operations to enhance efficiency. The post includes practical examples and explains how to implement triggers to improve operational efficiency and compliance in database management. No previous experience with triggers is required to understand their benefits and applications.
Automated Database Health Checks: Leveraging SMO in PowerShell
Safeguard your databases with automated PowerShell scripts! This guide walks you through creating scripts to check critical database health metrics like size and free space. Learn how to connect to SQL Server and format results for clarity. The post also explores optional features for enhanced functionality.
Enterprise SQL Server Security: Best Practices and Strategies to Protect Your Data
Explore essential SQL Server security best practices for large enterprises. This blog covers encryption, access control, infrastructure security, threat detection, and compliance to enhance data protection, ensure regulatory adherence and more. Learn what more you can do to secure your critical production SQL Server environments.
Optimizing Large Tables in SQL Server Using Table Partitioning
SQL Server table partitioning is an invaluable feature for improving database performance and management, especially for large-scale databases. This blog post provides an overview of setting up and managing partitioned tables in SQL Server, using TSQL commands. Partitioning helps manage large tables by dividing them into smaller, more manageable segments known as partitions. Each partition can be stored on a separate filegroup, enhancing query performance and simplifying maintenance tasks such as backups and index rebuilds.
System Level Performance Tuning for SQL Server 2022 on Linux
Running SQL Server on Linux offers many advantages, including cost savings and robust management tools. To fully realize these benefits, certain Linux-specific configurations must be tuned. This post focuses on three specific areas: I/O scheduler, swapfiles, and swappiness. So let’s jump in and start tinkering!
Capturing SQL Server Inventory with PowerShell
Maintaining an accurate and comprehensive inventory of your SQL Server environment is crucial for effective database management, ensuring security, and meeting compliance requirements. With PowerShell, database administrators can automate the collection of detailed information about SQL Server instances and databases, streamlining the inventory process. This blog post introduces a PowerShell script designed to efficiently gather SQL Server inventory data, separating instance-level information from database-specific details into two distinct reports.
Ensuring Optimal Execution Plans in SQL Server
Explore professional strategies for managing SQL Server Plan Regression. This guide offers insight into preventing performance degradation through efficient execution plan selection and maintenance, ensuring optimal query performance in SQL Server environments.
Migrating SQL Server On-Prem Workloads to Azure Virtual Machines
Migrating from an on-premises SQL Server to an Azure Virtual Machine (VM) encompasses not just a technological shift but also a strategic transformation that demands foresighted planning and preparation. This refined approach focuses on the preliminary steps necessary to ensure not just a seamless transition but also an optimized post-migration environment. Emphasizing benchmarking your current infrastructure and tailoring capacity planning to the specific types of workloads being migrated, this guide aims to lay a solid foundation for your move to Azure.