Database Administration Greg Larsen in Database Administration SQL Server Synonyms SQL Server synonyms can be used to permanently alias database objects in the same or another database. In this article,... 22 September 2020 13 min read
BI Bill Pearson in BI DAX financial functions: Loan calculations Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson kicks off a series to introduce the DAX financial functions.... 19 September 2020 27 min read
BI Rodney Landrum in BI Azure Data Factory pipelines: Filling in the gaps Azure Data Factory is a cloud based data orchestration tool that many ETL developers began using instead of SSIS. In... 18 September 2020 17 min read
T-SQL Programming Joe Obbish in T-SQL Programming Dynamic Data Unmasking The SQL Server 2016 dynamic data masking feature may seem like a great way to obfuscate data for downstream systems... 15 September 2020 12 min read
Career Pamela Mooney in Career DBA in training: Know your environment(s) It doesn’t matter if you become an “accidental DBA” or are actively looking for a database administrator position, you may... 14 September 2020 11 min read
Performance Robert Sheldon in Performance SQL Server Computed Columns: Persisted vs Indexed Performance Compare SQL Server computed column performance across four configurations: non-persisted, persisted, indexed, and indexed-persisted. Includes execution plans and benchmarks using... 10 September 2020 14 min read
T-SQL Programming Edward Pollack in T-SQL Programming Query Patterns for Columnstore Indexes: Joins & Performance (Part 4) Optimize query patterns against columnstore indexes in SQL Server. Learn segment and rowgroup elimination, dimension table joins, performance pitfalls, and... 01 September 2020 21 min read
Database Administration Greg Larsen in Database Administration Understanding SQL Server Recovery Models The database recovery model controls how a SQL Server database can be backed up and restored. In this article, Greg... 27 August 2020 12 min read
Career Pamela Mooney in Career DBA in training: Preparing for interviews Getting that first job as a DBA is not easy for most of us. In this article, Pamela Mooney explains... 26 August 2020 17 min read
Database Administration Robert Sheldon in Database Administration Storage 101: The Future of Storage Robert Sheldon continues his series on storage by discussing the latest storage innovation and ideas. … 21 August 2020 13 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 3 Nonclustered Indexes Uwe Ricken continues his series on heaps. This time he demonstrates a common scenario where the query against a heap... 18 August 2020 8 min read
Career Pamela Mooney in Career DBA in Training: So, you want to be a DBA… Many people with tech careers did not follow a straight path to get there. In this article, Pamela Mooney gives... 11 August 2020 14 min read
BI Vince Iacoboni in BI Clarifying Data Warehouse Design with Historical Dimensions The standard data warehouse design from Kimball with facts and dimensions has been around for almost 25 years. In this... 04 August 2020 17 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server Temp Tables: Types, Syntax & Best Practices Complete guide to SQL Server temporary tables - local (#), global (##), table variables, and table-valued parameters. Includes syntax, performance... 01 August 2020 23 min read
Database Administration Robert Sheldon in Database Administration Storage 101: Data Security and Privacy No discussion about storage is complete without thinking about security of the data. In this article, Robert Sheldon explains what... 22 July 2020 12 min read
Performance Edward Pollack in Performance Columnstore Index Maintenance: Rebuild, Reorganize & Options Guide to columnstore index maintenance in SQL Server. Covers rebuild vs reorganize, rowgroup management, nonclustered columnstore indexes, and memory-optimized columnstore... 21 July 2020 23 min read
T-SQL Programming Edward Pollack in T-SQL Programming Columnstore Index Best Practices: Data Order & Partitioning (Part 2) SQL Server columnstore index best practices: optimize data order for rowgroup elimination, use segment metadata, implement partitioning, and apply archive... 24 June 2020 20 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Optimize Heap Table Reads in SQL Server (Part 2 of 4) Optimize read performance on SQL Server heap tables. Covers advanced scanning, predicate pushdown, allocation order scans, partitioning, and compression techniques.… 22 June 2020 19 min read
Database Administration Robert Sheldon in Database Administration Storage 101: Cloud Storage Throughout this series, I’ve discussed a range of storage-related topics, some of which I mentioned only briefly. One of those... 22 June 2020 12 min read
Containers and Virtualization Carlos Robles in Containers and Virtualization Connecting to a SQL Server Docker Container Running in macOS Since SQL Server is supported in containers, you can now run a SQL Server instance in your macOS without dual-booting... 22 June 2020 14 min read
