T-SQL Programming Phil Factor in T-SQL Programming Saving Data to Various Formats, Using SQL You have many options when exporting data from a database. In this article, Phil Factor compares several methods including XML... 24 December 2018 12 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 Power BI Introduction: Visualizing SQL Server Audit Data — Part 9 SQL Server Audit is a powerful feature that can help you comply with regulations such as HIPAA and SOX, but... 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 Transferring Data with JSON in SQL Server JSON is a viable option for transferring data between systems. It has the ability to include schema information along with... 25 November 2018 31 min read
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
