DBA Scrolls - SQL Stories from the Trenches

DBA Scrolls - SQL Stories from the Trenches

  • Home
  • Contact
  • About
Showing posts from August, 2023

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

byLince Sebastian •August 25, 2023

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&…

Load More
That is All

Follow Us

Popular Posts

Powerful Connections: How to Connect to SQL Server Using PowerShell

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

Uncovering High-CPU Queries: A Guide for Database Optimization

Recent Posts

Main Tags

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

Search This Blog

  • 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)

Labels

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

Per-Database CPU Usage in SQL Server

byLince Sebastian•July 20, 2024
DBA Scrolls - SQL Stories from the Trenches

DBA

He's making a database. He's sorting it twice. SELECT * from contacts WHERE behavior = 'nice'. SQL Clause is coming to town.

dbascrolls
  • Home
  • About
  • Contact Us
  • RTL Version

Our website uses cookies to improve your experience. Learn more


Ok