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.
Guide to exiting SINGLE_USER mode in SQL Server by killing connections and switching to MULTI_USER.
Steps to exit SINGLE_USER mode in SQL Server by killing connections and switching back to MULTI_USER.
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.
A guide on configuring MongoDB to run as a Windows service, including command setup and troubleshooting tips.
A detailed review of the SQL Server MasterClass 2010 event, covering sessions on DevOps, myth-busting, recovery, and GUID performance.
