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.
Explores a disclosure vulnerability in SQL Server's Row- and Cell-Level Security when implemented with views, demonstrating how protected data can be exposed.
A security-focused session at SQL Rally Amsterdam demonstrating privilege elevation and DoS attacks via SQL Injection on SQL Server.
Announcement and agenda for a full-day SQL Server performance analysis and tuning PreCon workshop at SQLSaturday Istanbul.
Benchmarks comparing the CPU performance overhead of SQL Server Extended Events vs. SQL Trace under high CPU load.
Explores SQL Server privilege escalation from CONTROL SERVER to sysadmin, debunking myths and comparing to Oracle's security model.
Guide to securely connect SQL Server Management Studio to an Azure IaaS SQL Server instance by configuring endpoints and enabling encrypted connections.
Compares file sizes between SQL Server Extended Events and deprecated SQL Trace, finding XML format adds ~29% overhead.
Fixing a SQL Server 2008 R2 in-place upgrade error related to service account logon format (UPN vs. Down-Level Name).
A database expert reflects on the 2013 Frankfurt Database Days conference, comparing SQL Server and Oracle features like isolation levels and security.
A technical guide on using SQL Server Extended Events for tracing and monitoring Analysis Services (SSAS) performance, replacing SQL Profiler.
A bug in SQL Server Management Studio's Table Designer can cause filtered unique indexes to lose their WHERE clause when altering a table, leading to duplicate key errors.
A guide on connecting to and working with Windows Azure SQL Database directly within the PhpStorm IDE, covering setup, queries, and database management.
Analyzes SQL Server locking behavior for tables on READONLY filegroups vs. READONLY databases, debunking common myths.
Author shares personal achievement of earning the Microsoft Certified Master SQL Server 2008 certification, the highest technical certification from Microsoft.
Guide on configuring the Azure Storage Emulator to use a custom SQL Server instance instead of the default local SQL Express.
