Performance Edward Pollack in Performance Efficiently polling remote data sources In this article, Edward Pollack describes some of the issues when querying against remote data sources. He covers remote SQL... 30 September 2020 22 min read
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 Computed Column Performance in SQL Server Computed columns may be the cause of hard to track down performance issues. In this article, Robert Sheldon reviews the... 10 September 2020 14 min read
T-SQL Programming Edward Pollack in T-SQL Programming Hands-On with Columnstore Indexes: Part 4 Query Patterns All queries run fast against columnstore indexes, right? In this article, Edward Pollack demonstrates some query patterns that don’t perform... 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
Phil Factor Temporary Tables in SQL Server Temporary tables are used by every DB developer, but they're not likely to be too adventurous with their use, or... 01 August 2020 22 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 Hands-On with Columnstore Indexes: Part 3 Maintenance and Additional Options In this article of this series, Edward Pollack demonstrates the maintenance of columnstore indexes. He also takes a look at... 21 July 2020 22 min read
T-SQL Programming Edward Pollack in T-SQL Programming Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines In the second article of this series, Edward Pollack demonstrates some ways to design and populate a columnstore index to... 24 June 2020 20 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 2 Optimizing Reads In the second article of this series, Uwe Ricken discusses ways to affect the performance of queries involving heaps, including... 22 June 2020 18 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
