“Switch” Huge Non Partitioned Tables in Seconds
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 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.
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.