Pivoting Data in SQL Server with JSON: A Generic Dynamic Matrix Approach

A JSON-based approach to pivoting and transposing data in SQL Server that works without knowing column names in advance. Covers...

16 January 2018 17 min read

BI

Robert Sheldon in BI

SQL Server Machine Learning Services – Part 4: Finding Data Anomalies with Python

Python is widely used to analyze data. One such use is to find anomalies or outliers. In this article, Robert...

16 January 2018 16 min read

BI

Robert Cain in BI

Mobile Report Publisher – Dashboards Everywhere

The new feature, Mobile Reports, was added to SSRS in 2016. It provides the ability to create attractive and useful...

11 January 2018 24 min read

BI

Rick Dobson in BI

Historical Stock Prices and Volumes from Python to a CSV File

Python is a versatile language that is gaining more popularity as it is used for data analysis and data science....

05 January 2018 23 min read

Database Administration

Darko Martinović in Database Administration

Custom Blocked Process Report for SQL Server

Build a custom SQL Server blocked process report with readable email alerts. Identify root blockers, blocking chains, and lock details...

05 January 2018 32 min read

BI

Robert Sheldon in BI

SQL Server Machine Learning Services – Part 3: Plotting Data with Python

One of the advantages of running Python from SQL Server is the ability to create graphics to assist in analysis...

02 January 2018 26 min read

T-SQL Programming

Joe Celko in T-SQL Programming

Validation, Verification, and Modification

A proper database design is very important, and changes to fix problems after the fact are expensive. In this article,...

26 December 2017 20 min read

Tools

Robert Cain in Tools

A Walk Around SQL Operations Studio

SQL Server Management Studio has been the default tool for working with SQL Server for over a decade. It’s not,...

18 December 2017 13 min read

BI

Robert Sheldon in BI

SQL Server Machine Learning Services – Part 2: Python Data Frames

SQL Server Machine Learning Services provides the ability to run Python scripts directly against data in SQL Server. To do...

18 December 2017 28 min read

Blogs

John Paul Cook in Blogs

Troubleshooting Failed PolyBase Installation in SQL Server 2017

This article shows you how to troubleshoot a failed installation of SQL Server and how to implement a workaround to...

12 December 2017 4 min read

BI

Robert Sheldon in BI

SQL Server Machine Learning Services: Python with sp_execute_external_script

Run Python scripts in SQL Server using sp_execute_external_script in Machine Learning Services. Part 1 covers enabling MLS, naming input/output variables,...

30 November 2017 21 min read

Database Administration

Robert Sheldon in Database Administration

Still More SQL Server Features that Time Forgot

As the final entry in this series, Robert Sheldon leads you through a group of forgotten features that have been...

17 November 2017 15 min read

T-SQL Programming

Alfonso Hernandez in T-SQL Programming

Summarizing Data Using the GROUPING SETS Operator

Writing aggregate queries is one of the most important tasks for anyone working with T-SQL. Determining the expressions required in...

14 November 2017 9 min read

Database Administration

Dennes Torres in Database Administration

Checking SQL Server with Policy-Based Management

Policy-Based Management, a feature of SQL Server, is a flexible tool that can help DBAs manage one or more SQL...

09 November 2017 15 min read

BI

Robert Sheldon in BI

SQL Server R Services: Working with Multiple Data Sets

Although it is easy to use SQL Server R Services to create R scripts that incorporate SQL Server data by...

03 November 2017 19 min read

T-SQL Programming

Phil Factor in T-SQL Programming

Import and Validate JSON from Web Services into SQL Server: T-SQL Techniques

Import and validate JSON from web services into SQL Server using T-SQL. Covers path expression parsing, metadata comparison, data type...

27 October 2017 35 min read

Database Administration

Dennes Torres in Database Administration

Extended Events Profiler (XE Profiler) in SSMS

Starting in SSMS version 17.3, we have an interesting new feature: Extended Events Profiler (XE Profiler). This new feature is in...

20 October 2017 2 min read

T-SQL Programming

Joe Celko in T-SQL Programming

Simple SQL: Handling Location Datatypes

How do you record locations in SQL? Most relational database systems support spatial and geographical data, generally using the round-earth...

19 October 2017 14 min read

Laerte Junior

Questions About Amazon Data Migration Service (AWS DMS) That You Were Too Shy to Ask

Can you imagine it? You are in a group of smart database people, and they are debating the finer points...

18 October 2017 9 min read

Database Administration

Robert Sheldon in Database Administration

Even More SQL Server Features that Time Forgot

SQL Server works well, and Microsoft does everything it can to keep it relevant and competitive: As with everything in...

18 October 2017 13 min read

Register for Simple Talk

Databases

Pivoting Data in SQL Server with JSON: A Generic Dynamic Matrix Approach

SQL Server Machine Learning Services – Part 4: Finding Data Anomalies with Python

Mobile Report Publisher – Dashboards Everywhere

Historical Stock Prices and Volumes from Python to a CSV File

Custom Blocked Process Report for SQL Server

SQL Server Machine Learning Services – Part 3: Plotting Data with Python

Validation, Verification, and Modification

A Walk Around SQL Operations Studio

SQL Server Machine Learning Services – Part 2: Python Data Frames

Troubleshooting Failed PolyBase Installation in SQL Server 2017

SQL Server Machine Learning Services: Python with sp_execute_external_script

Still More SQL Server Features that Time Forgot

Summarizing Data Using the GROUPING SETS Operator

Checking SQL Server with Policy-Based Management

SQL Server R Services: Working with Multiple Data Sets

Import and Validate JSON from Web Services into SQL Server: T-SQL Techniques

Extended Events Profiler (XE Profiler) in SSMS

Simple SQL: Handling Location Datatypes

Questions About Amazon Data Migration Service (AWS DMS) That You Were Too Shy to Ask

Even More SQL Server Features that Time Forgot