BI Andy Brown in BI Creating Calculated Columns Using DAX In this article, Andy Brown shares his knowledge of how to create calculated columns in tables, using Power BI as... 02 November 2018 20 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 The Extended Events (or XEvents) feature has been part of SQL Server since 2008, but many database professionals struggle to... 27 September 2018 34 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 The Crimes of Chicago: Working with Data in MongoDB NoSQL databases like MongoDB are gaining popularity, but using the right tools for the job at hand is most important.... 03 August 2018 26 min read
Featured Robert Sheldon in Featured Power BI Introduction: Power Query M Formula Language in Power BI Desktop — Part 6 In this article of the Power BI series, Robert Sheldon demonstrates how to work with the Power Query M language... 01 August 2018 21 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
BI Robert Sheldon in BI Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4 Power BI allows you to use parameters to make your reports dynamic. In this article, Robert Sheldon demonstrates how parameters... 05 July 2018 14 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming T-SQL Window Functions and Performance T-SQL window functions, introduced in 2005 with enhancements in 2012, are great additions to the T-SQL language. In this article,... 27 June 2018 11 min read
T-SQL Programming Joe Celko in T-SQL Programming Missing Data Missing data is a difficult and common problem to solve. In this article, Joe Celko explains several approaches to deleting... 20 June 2018 10 min read
BI Robert Sheldon in BI Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3 R is a powerful language for manipulating data and creating visualizations. In this article in the series, Robert Sheldon demonstrates... 20 June 2018 17 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming Introduction to T-SQL Window Functions T-SQL window functions were introduced in 2005 with more functionality added in 2012. Many database professionals are not aware of... 13 June 2018 13 min read
BI Robert Sheldon in BI Power BI Introduction: Working with Power BI Desktop — Part 2 Power BI Desktop is the free tool from Microsoft for developing in Power BI. In this article, Robert Sheldon walks... 06 June 2018 24 min read
