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
BI Andy Brown in BI 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
BI Robert Sheldon in BI Power BI Introduction: Publishing Reports to the Power BI Service — Part 8 Power BI Desktop is typically used to create reports that will eventually be published to Power BI Services where dashboards... 17 September 2018 16 min read
Database Administration Kellyn Pot'Vin-Gorman in Database Administration How to Linux for SQL Server DBAs — Part 1 As running SQL Server on Linux becomes more common, DBAs must learn and become comfortable with the Linux OS. In... 29 August 2018 11 min read
Database Administration Kathi Kellenberger in Database Administration Questions About Kerberos and SQL Server That You Were Too Shy to Ask Kerberos authentication is a topic that many database administrators avoid. It’s really not that difficult to understand, but it’s also... 21 August 2018 12 min read
BI Robert Sheldon in BI Power BI Introduction: Building Reports in Power BI Desktop — Part 7 Power BI contains rich visualizations that allow anyone to build insightful dashboards. In this article, Robert Sheldon shows you how... 21 August 2018 22 min read
PowerShell Greg Moore in PowerShell Introduction to PowerShell with SQL Server Using Invoke-SQLCMD PowerShell is the preferred scripting tool used by Windows and Active Directory administrators. It can also be used to administer... 08 August 2018 10 min read
T-SQL Programming Phil Factor in T-SQL Programming Getting Started with MongoDB and PowerShell: A Real-World Data Walkthrough Learn MongoDB with PowerShell using a real 6.5 million record dataset: install MongoDB, import CSV data, create indexes, run aggregation... 03 August 2018 26 min read
Robert Sheldon Power Query M Language in Power BI: Data Transformation Step-by-Step Guide Learn the Power Query M formula language in Power BI Desktop with a step-by-step data transformation pipeline: remove columns, promote... 01 August 2018 22 min read
BI Robert Sheldon in BI Power BI Introduction: Working with SQL Server data in Power BI Desktop — Part 5 Data for Power BI can come from many sources, but often the data is hosted in SQL Server. In this... 17 July 2018 18 min read
