PowerShell Greg Moore in PowerShell Using a Server List to Control PowerShell Scripts PowerShell is the preferred tool for many DBAs when automating SQL Server administration. In this article, Greg Moore demonstrates how... 29 January 2019 13 min read
BI Gogula Aryalingam in BI The BI Journey: The Analyst Most organizations today understand the value of analysing their data. In some cases, they haven’t realized the value or are... 21 January 2019 15 min read
BI Andy Brown in BI DAX CALCULATE & VALUES Functions Explained Understand the DAX CALCULATE and VALUES functions with practical examples. Learn filter context, ALL function, and how to build percentage... 14 January 2019 21 min read
T-SQL Programming Joe Celko in T-SQL Programming Empty Thoughts: Working with NULL Whether or not to have NULLable columns in a table can be a religious debate, and how missing data is... 10 January 2019 12 min read
Database Administration Greg Larsen in Database Administration Protecting SQL Server Data Using Static Data Masking In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and... 07 January 2019 19 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 1 Security is often considered the most important of a database administrator's responsibilities. SQL Server has many powerful features for security... 31 December 2018 14 min read
BI Andy Brown in BI Creating DAX Measures in Power BI: Calculated Fields, Time Intelligence, and CALCULATE Learn to create DAX measures in Power BI: SUM, AVERAGE, COUNT for single columns, SUMX and COUNTX iterator functions for... 28 December 2018 23 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server Export Formats Compared: BCP, XML, CSV, Tab-Delimited Performance and Gotchas Benchmarked comparison of SQL Server export formats - native BCP, XML via BCP, CSV, tab-delimited - for performance and handling... 24 December 2018 13 min read
BI Eugene Meidinger in BI SSRS Reporting Basics: When is SSRS the Right Tool? SSRS has undergone a number of changes over the past few versions. It remains a very popular reporting tool in... 18 December 2018 11 min read
Database Administration Kellyn Pot'Vin-Gorman in Database Administration How to Linux for SQL Server DBAs — Part 3 DBAs running SQL Server on Linux will not only need to understand SQL Server security well, they will also need... 07 December 2018 14 min read
T-SQL Programming Joe Celko in T-SQL Programming Data Quality Problems with data quality are easier and cheaper to prevent than to solve later. In this article, Joe Celko talks... 05 December 2018 11 min read
BI Robert Sheldon in BI Visualize SQL Server Audit Data in Power BI: Tables, Charts, and Gauges Connect Power BI Desktop to SQL Server Audit data to create interactive reports. Covers test database setup, DML/DDL audit generation,... 29 November 2018 21 min read
T-SQL Programming Greg Larsen in T-SQL Programming There is a New COUNT in Town Now that SQL Server 2019 is on the way, it’s time to start learning about the new capabilities. In this... 29 November 2018 14 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server JSON: Transferring Data with FOR JSON, OPENJSON, and JSON Schema Validation Transfer data between SQL Server databases using JSON - exporting tables with FOR JSON, importing with OPENJSON, validating file contents... 25 November 2018 31 min read
PowerBI Andy Brown in PowerBI DAX Calculated Columns in Power BI: Syntax, Row Context, RELATED, SUMX, and Measure Comparison Creating DAX calculated columns in Power BI and Tabular models - syntax basics, handling data types, understanding row context (which... 02 November 2018 21 min read
Database Administration Laerte Junior in Database Administration What Is SQLPSX? SQLPSX is a useful library you can add to PowerShell to automate many DBA tasks. In this article, Laerte Junior... 29 October 2018 12 min read
Database Administration Robert Sheldon in Database Administration Adaptive Query Processing in SQL Server 2017 As new versions of SQL Server have been released, the Query Optimizer has undergone many improvements. Adaptive Query Processing, new... 01 October 2018 17 min read
Database Administration Phil Factor in Database Administration Extended Events Workbench: SQL Server Recipes Practical Extended Events (XEvents) recipes for SQL Server. Ready-to-use sessions for error tracking, query monitoring, wait stats, and performance troubleshooting.… 27 September 2018 35 min read
Database Administration Kellyn Pot'Vin-Gorman in Database Administration How to Linux for SQL Server DBAs — Part 2 SQL Server DBAs are typically quite familiar with security and best practices in Windows but may not understand how security... 26 September 2018 17 min read
BI Supriya Pande in BI Creating Machine Learning Applications using Azure Cognitive Services Azure contains a vast array of services that can be used for machine learning, text analysis, and more. In this... 26 September 2018 17 min read
