A guide to SQL Server schema design focusing on security best practices, moving beyond the default dbo schema for better access control.
A database professional's travelogue of speaking at SQL Server and tech conferences across Asia, Europe, and America in late 2015.
Discusses critical SQL Server security patches (MS15-058) and emphasizes the importance of following security best practices like least-privilege access.
Overview of SQL Server 2016's key security and performance features, including Always Encrypted, Stretch Database, and real-time analytics.
Troubleshooting Entity Framework with SQL Server Synonyms and Integrated Security, offering a View-based solution.
Resolving Entity Framework errors with SQL Server Synonyms and Integrated Security by using Views instead.
Explains how to optimize SQL Server performance and reduce costs on Microsoft Azure using flexible IaaS configurations and storage strategies.
A technical guide on using SQL Server Extended Events to capture, import, and parse deadlock graphs for analysis and troubleshooting.
Announcing a free, open-source tool for collecting and parsing SQL Server deadlock graphs from system memory, aiding administrators and developers.
A technical walkthrough implementing Row-Level Security (RLS) in Azure SQL Database using the AdventureWorks sample database.
A technical walkthrough on setting up and using the Dynamic Data Masking feature in Azure SQL Database for on-the-fly data obfuscation.
A summary of key SQL Server management takeaways from a TechEd Europe 2014 session, covering backups, TempDB, and indexing.
Explains why SQL Server's dm_exec_query_plan returns NULL for stored procedures with conditional logic and temp tables, and how to diagnose it.
A technical guide on loading detailed AWS billing data into a SQL Server data warehouse for advanced cost analysis.
Survey results on SQL Server database ownership reveal security risks, with recommendations for best practices and secure configurations.
Explains new SQL Server 2014 permissions like IMPERSONATE ANY LOGIN and how they interact with CONTROL SERVER for security and privilege escalation.
Overview of new Extended Events packages and features introduced in SQL Server 2014, focusing on the In-Memory OLTP (XTP) engine.
Author announces receiving the Microsoft MVP Award for SQL Server, highlighting their community contributions and speaking engagements.
Explores the security implications of disabling SQL Server logins and denying permissions, focusing on how impersonation remains possible.
Announcement and details for two upcoming SQLSaturday tech conferences in Copenhagen and Lisbon, featuring expert sessions on SQL Server topics.
