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

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

.NET

Darko Martinović in .NET

MongoDB .NET Driver Guide: CRUD, LINQ & Aggregation

Learn how to use the MongoDB .NET driver with C#. Covers connecting to MongoDB, BSON type mapping, CRUD operations, LINQ...

24 October 2018 41 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

Oracle

Ben Brumm in Oracle

10 Best Practices for Writing Oracle SQL

There is often more than one way to write a query that returns the same results, but some methods may...

30 August 2018 13 min read

Register for Simple Talk

Databases

Empty Thoughts: Working with NULL

Protecting SQL Server Data Using Static Data Masking

Introduction to SQL Server Security — Part 1

Creating DAX Measures in Power BI: Calculated Fields, Time Intelligence, and CALCULATE

SQL Server Export Formats Compared: BCP, XML, CSV, Tab-Delimited Performance and Gotchas

SSRS Reporting Basics: When is SSRS the Right Tool?

How to Linux for SQL Server DBAs — Part 3

Data Quality

Visualize SQL Server Audit Data in Power BI: Tables, Charts, and Gauges

There is a New COUNT in Town

SQL Server JSON: Transferring Data with FOR JSON, OPENJSON, and JSON Schema Validation

DAX Calculated Columns in Power BI: Syntax, Row Context, RELATED, SUMX, and Measure Comparison

What Is SQLPSX?

MongoDB .NET Driver Guide: CRUD, LINQ & Aggregation

Adaptive Query Processing in SQL Server 2017

Extended Events Workbench: SQL Server Recipes

How to Linux for SQL Server DBAs — Part 2

Creating Machine Learning Applications using Azure Cognitive Services

Power BI Introduction: Publishing Reports to the Power BI Service — Part 8

10 Best Practices for Writing Oracle SQL