Explains how oversized VARCHAR columns in SQL Server can negatively impact query performance by inflating memory grant requests.
Analysis of the Meltdown/Spectre processor flaws and their critical impact on SQL Server deployments, security, and performance.
Explains implementing Separation of Duties and role-based security in SQL Server for data protection, focusing on Least Privilege principles.
Benchmarking SQL Server cluster sizes on SSDs to determine if 64K allocation units are still optimal under various RAID configurations.
Highlights from PASS Summit 2017 Day 1 keynote, covering SQL Server 2017, Azure data services, and Microsoft's data platform announcements.
Live coverage and highlights from PASS Summit 2017, focusing on Microsoft Data Platform updates, Azure services, and SQL Server.
A guide to using SQL Server's SWITCH operation to quickly modify schema on massive, non-partitioned tables with billions of rows.
A guide to using the new 'Compare ShowPlan' feature in SQL Server Management Studio 2017 to analyze and contrast SQL execution plans.
Explores performance challenges when using SQL Server's In-Memory and Natively Compiled Objects, showing they don't always provide expected speed gains.
A deep dive into SQL Server's In-Memory technologies, including Columnstore Indexes and In-Memory OLTP, presented at a tech conference.
A deep dive into troubleshooting performance issues with SQL Server's natively compiled stored procedures, focusing on unexpected preemptive waits and memory contention.
A guide to using the Tedious driver for Node.js to connect to Microsoft SQL Server, including a sample phone book application.
Announcement and feature breakdown of SQL Server 2016 general availability, highlighting new security, performance, and edition-specific capabilities.
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.
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.
