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.
Guide to using the new Geolocation field in SharePoint 2013, including setup, Bing Maps integration, and prerequisites.
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.
Troubleshooting SQL Server 2012 Reporting Services and SharePoint 2010 integration error with BI Semantic Model Connection fix.
Troubleshooting SSRS 2012 and SharePoint 2010 integration error, focusing on missing Reporting Services Add-in on WFE nodes.
Author shares personal achievement of earning the Microsoft Certified Master SQL Server 2008 certification, the highest technical certification from Microsoft.
A developer shares their motivation for starting a tech blog to explain programming and data topics from the ground up.
A tech blogger shares their motivation for starting a blog to explain programming and data topics from the ground up.
Guide on configuring the Azure Storage Emulator to use a custom SQL Server instance instead of the default local SQL Express.
