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

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: Performance, NTILE & Framing

Master T-SQL window function performance: understand OVER clause sorting, PARTITION BY, NTILE, framing (ROWS vs RANGE), indexing strategies, and how...

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

AWS

David Yahalom in AWS

Combining Amazon Aurora, Lambda, and SQS to go Beyond the Native Capabilities of MySQL

Tapping the power of serverless computing via Lambda functions and cloud-native technologies allows us to extend the native capabilities that...

26 May 2018 18 min read

T-SQL Programming

Darko Martinović in T-SQL Programming

Migrate a SQL Server Database to In-Memory OLTP: Full Guide

Step-by-step guide to migrating a SQL Server database to In-Memory OLTP. Covers limitations, foreign key workarounds, data type compatibility, natively...

10 May 2018 30 min read

BI

Robert Sheldon in BI

Power BI Introduction: Tour of Power BI — Part 1

Power BI has been available for a number of years, but new functionality is added regularly. In this new series...

10 May 2018 17 min read

T-SQL Programming

Phil Factor in T-SQL Programming

Importing JSON into SQL Server: OPENJSON for Arrays, Nested Arrays, and Complex Collections

Import JSON documents into SQL Server using OPENJSON - covering simple arrays of objects, nested arrays (with CROSS APPLY), and...

09 May 2018 21 min read

Oracle

Mike Smithers in Oracle

utPLSQL 3.0 – How To Have Your Cake and Eat It

This article was originally published on mikesmithers.wordpress.com. “You can’t have your cake and eat it!” This seems to be a regular...

08 May 2018 27 min read

T-SQL Programming

Robert Sheldon in T-SQL Programming

SQL Server Graph Databases Part 5: Import Relational Data into Graph Tables

Learn how to import AdventureWorks relational data into SQL Server graph node and edge tables, query the graph data with...

30 April 2018 20 min read

T-SQL Programming

Robert Sheldon in T-SQL Programming

Graph Databases for Hierarchical Data in SQL Server (Part 4)

Model hierarchical data in SQL Server graph databases: org charts, multi-level relationships, MATCH queries, and closure table workarounds for complex...

23 April 2018 21 min read