Performance Fabiano Amorim in Performance Tempdb – Here’s a Problem You Didn’t Know You Had Because of its many roles, tempdb is the source of performance issues in SQL Server, and there are recommended configuration... 21 April 2020 14 min read
Database Administration Pamela Mooney in Database Administration How to Set Up Transactional Replication Replication is one way to copy data to another database or server. In this article, Pamela Mooney describes how to... 16 April 2020 11 min read
Database Administration Robert Sheldon in Database Administration Storage 101: Data Center Storage Configurations In this article in the series, Robert Sheldon explains the differences between direct-attached storage, network-attached storage, and storage area networks.… 08 April 2020 11 min read
T-SQL Programming Edward Pollack in T-SQL Programming Stale SQL Server Views: Detecting and Fixing Views After Table Changes SQL Server views can silently return wrong columns after underlying tables are altered. Learn to detect stale views with sp_refreshview,... 31 March 2020 24 min read
T-SQL Programming Greg Larsen in T-SQL Programming SQL Server Batch Mode on Rowstore: Reduce CPU on Analytic Queries SQL Server 2019 Batch Mode on Rowstore reduces CPU usage of large analytic aggregate queries by 20–30% without rewriting any... 25 March 2020 19 min read
Roy Ernest Introduction to SQL Server Spatial Data Many applications require the handling of geospatial data. Roy and Surenda take you through the basics of SQL Server spatial... 18 March 2020 22 min read
Database Administration Robert Sheldon in Database Administration Storage 101: Understanding the NAND Flash Solid State Drive Today, most organization are using solid-state drives for everything from laptops to enterprise database storage and virtual machines. In this... 11 March 2020 13 min read
PowerShell Greg Moore in PowerShell SQL Server and Undocumented Extended Procedures Smart DBAs automate tasks whenever possible. In this article, Greg Moore shows the need to use caution when using undocumented... 03 March 2020 11 min read
Database Administration Robert Cain in Database Administration How to Create an Ubuntu PowerShell Development Environment – Part 2 You’ll need several tools in place to effectively work with SQL Server in Linux. In this article, Robert Cain explains... 03 March 2020 13 min read
Tools Edward Pollack in Tools Knowledge Sharing with SQL Notebooks SQL Notebooks, based on Jupyter Notebooks, is one of the best things about Azure Data Studio. In this article, Edward... 03 March 2020 16 min read
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Power BI Visualizations Power BI is perfect for analyzing surveys. In this article, Sanil Mhatre demonstrates how to build several visualizations for key... 02 March 2020 15 min read
Database Administration Robert Sheldon in Database Administration Storage 101: Understanding the Hard-Disk Drive In this article in the series, Robert Sheldon provides a deep dive into HDDs.… 18 February 2020 12 min read
T-SQL Programming Monica Rathbun in T-SQL Programming SQL Server Memory-Optimized Tables: Beginner’s Guide Learn how memory-optimized tables work in SQL Server - In-Memory OLTP architecture, creating durable and schema-only tables, natively compiled stored... 14 February 2020 18 min read
BI Andy Brown in BI Creating Time-Intelligence Functions in DAX DAX contains a host of time-intelligence functions with exotic names such as SAMEPERIODLASTYEAR and PARALLELPERIOD. In the last article in... 14 February 2020 19 min read
Performance Greg Larsen in Performance Get Your Scalar UDFs to Run Faster Without Code Changes Microsoft has added a group of features called Intelligent Query Processing to SQL Server 2017 and 2019. In this article,... 10 February 2020 14 min read
BI Sanil Mhatre in BI Sentiment Analysis with Power BI and Azure AI Language: A Practical Introduction Perform sentiment analysis on survey responses using Power BI and Azure AI Language (formerly Azure Text Analytics). Part 1 covers... 03 February 2020 13 min read
Database Administration Robert Sheldon in Database Administration Storage 101: The Language of Storage Robert Sheldon continues his series on storage. This article covers some of the basics of performance metrics, HDDs, and SSDs.… 22 January 2020 13 min read
Containers and Virtualization Carlos Robles in Containers and Virtualization Managing SQL Server Docker containers in macOS In the second article of this series, Carlos Robles explains how to manage Docker images and containers.… 21 January 2020 11 min read
T-SQL Programming Edward Pollack in T-SQL Programming Gaps and Islands in SQL Server: Efficient Window Function Solutions Advanced gaps and islands analysis in SQL Server using efficient window function patterns. Covers streak detection, PARTITION BY for multi-entity... 21 January 2020 32 min read
BI Andy Brown in BI Power BI Calendar Table: Create & Use Dates Learn how to create calendar tables in Power BI using DAX functions like CALENDARAUTO and CALENDAR. Covers fiscal years, multiple... 03 January 2020 18 min read
