DBA Scrolls - SQL Stories from the Trenches

Welcome to my blog about SQL Server database administration! As a SQL DBA, I've worked with databases for many years and have learned a lot about best practices, common pitfalls, and new features. On this blog, I'll be sharing my insights, tips, and tricks related to SQL Server administration, performance tuning, data analysis, and more. Whether you're a beginner or an experienced SQL DBA, you'll find valuable information and practical solutions to real-world challenges. Join me on this journey

How to persist SQL Agent job history in Azure SQL Managed Instance

By Lince Sebastian September 17, 2023 #TSQL
How to persist SQL Agent job history in Azure SQL Managed Instance

Azure SQL Managed Instance provides a robust environment for running SQL Server workloads in the cloud. However, it does come with certain limitations, one of which revolves around the retention of SQL Agent job history…

Read Tutorial

Uncovering High-CPU Queries: A Guide for Database Optimization

By Lince Sebastian September 17, 2023 #performance
Uncovering High-CPU Queries: A Guide for Database Optimization

In the world of database management, identifying queries responsible for high CPU usage is paramount for maintaining optimal performance. This article will guide you through two essential SQL statements that can help…

Read Tutorial

SQL Server query to retrieve all permission details for users within a database

By Lince Sebastian August 25, 2023 #permissions #TSQL
SQL Server query to retrieve all permission details for users within a database

In the realm of database management, ensuring robust security measures is paramount. As a dedicated SQL enthusiast, I recently stumbled upon an incredibly useful SQL query on Stack Overflow. While I didn't create th…

Read Tutorial

How can I check the failover history of the nodes in Always On availability groups ?

By Lince Sebastian July 25, 2023 #HA&DR #TSQL
How can I check the failover history of the nodes in Always On availability groups ?

SQL Server Availability Groups (AG) provide high availability and disaster recovery solutions for critical databases. Understanding the history of failovers in an AG is crucial for tracking changes in primary and second…

Read Tutorial

Streamline TSQL Result Delivery: Automate Emailing of TSQL Results in HTML Format using PowerShell - Any-TSQL Results to HTML EMail

By Lince Sebastian July 22, 2023 #Powershell #TSQL
Streamline TSQL Result Delivery: Automate Emailing of TSQL Results in HTML Format using PowerShell - Any-TSQL Results to HTML EMail

In this blog post, we will explore a useful PowerShell script that allows you to execute TSQL queries and send the results via email. The script is versatile and can work with any type of TSQL query. It also provides op…

Read Tutorial

How to find tempdb file size in SQL server and Azure SQL Managed Instance (configured / initial / Current)

By Lince Sebastian July 20, 2023 #performance #TSQL
How to find tempdb file size in SQL server and Azure SQL Managed Instance (configured / initial / Current)

In SQL Server, TempDB is a system database used to store temporary objects such as temporary tables, table variables, and other internal objects created during query processing. It is essential for managing sorting, gro…

Read Tutorial
← Newer Posts Older Posts →

Tags / Labels

  • backup (2)
  • Blocking (1)
  • disk (1)
  • encryption (3)
  • HA&DR (1)
  • non labeled (2)
  • performance (11)
  • permissions (4)
  • Powershell (3)
  • qureystore (5)
  • Security (4)
  • SQL users (3)
  • TSQL (11)

Popular Tutorials

  • How can I check the failover history of the nodes in Always On availability groups ?
  • Powerful Connections: How to Connect to SQL Server Using PowerShell
  • How to Find Users and their AD groups in SQL Server - SQL Server DBA

SQL Server Access Audit: A Comprehensive Script - Azure SQL Compatible

byLince Sebastian•October 21, 2024

Search This Blog

  • October 2024(1)
  • July 2024(1)
  • June 2024(2)
  • May 2024(1)
  • April 2024(1)
  • November 2023(1)
  • October 2023(3)
  • September 2023(2)
  • August 2023(1)
  • July 2023(4)
  • June 2023(1)
  • May 2023(1)
  • April 2023(6)
  • March 2023(2)
  • February 2023(1)
  • January 2023(1)

Main Tags

  • backup
  • Blocking
  • disk
  • encryption
  • HA&DR
  • non labeled
  • performance
  • permissions
  • Powershell
  • qureystore
  • Security
  • SQL users
  • TSQL

© DBA Scrolls - SQL Stories from the Trenches - SQL Stories from the Trenches. Built with modern Blogger layout.