Learn how to view and update user/group roles in Azure SQL Database using Azure Data Studio's preview features.
A series of technical how-to guides for Azure SQL Managed Instance, written by a Microsoft employee, with new posts planned.
Explores hidden PostgreSQL features like upsert row counts, column grants, and pivot tables to improve database workflows.
A guide to installing and configuring PostgreSQL on Linux, covering user setup, database creation, and common connection issues.
Technical analysis advising against using Basic and Standard (S0 & S1) tiers in Azure SQL Database, citing performance, permissions, and feature limitations.
A guide to converting SQL Server Profiler templates to Extended Events (XEvents) sessions using the SSMS GUI for performance monitoring.
A former Application DBA shares advanced SQL and database optimization techniques for developers, focusing on performance and efficiency.
A technical guide on configuring Workload Classifiers in Azure Synapse Analytics to map users and queries to specific workload groups for resource management.
A technical guide covering PostgreSQL basics, including schemas, user/role management, and SQL commands for permissions.
A technical guide exploring workarounds to update SQL Server statistics on secondary replicas in Availability Groups, including scripts and methods.
A critique of a MongoDB outage post-mortem, discussing the pitfalls of 'accidental DBAs' and the need for specialized database reliability engineering.
A technical walkthrough on setting up and testing the Auditing feature in Azure SQL Database, including configuration and reporting.
A technical walkthrough on setting up and using the Dynamic Data Masking feature in Azure SQL Database for on-the-fly data obfuscation.
Explains new SQL Server 2014 permissions like IMPERSONATE ANY LOGIN and how they interact with CONTROL SERVER for security and privilege escalation.
A tutorial on connecting to Apache Hive using the open-source SQL Workbench tool via JDBC, covering driver setup and connection configuration.
Announcement and details for two upcoming SQLSaturday tech conferences in Copenhagen and Lisbon, featuring expert sessions on SQL Server topics.
Compares file sizes between SQL Server Extended Events and deprecated SQL Trace, finding XML format adds ~29% overhead.
A developer shares his preferred method for working with PostgreSQL, advocating for the psql command-line tool and sharing key tips and configurations.
Analysis of MongoDB v1.8's new write-ahead journaling feature, testing its performance impact on data import speeds.
Explains MongoDB's oplog, its role in replication, how to configure its size, and discusses a historical bug in version 1.6.5.
