Darko Martinović An Easier Way of Transposing Query Result in SQL Server T-SQL does not have an easy way to transpose a row and a column. Of course, there is the PIVOT... 13 March 2018 17 min read
T-SQL Programming Robert Sheldon in T-SQL Programming SQL Server Graph Databases – Part 1: Introduction SQL Server 2017 now includes a new feature to represent complex relationships in data called Graph Databases. Robert Sheldon introduces... 06 March 2018 16 min read
Performance Uwe Ricken in Performance READ COMMITTED SNAPSHOT ISOLATION and High version_ghost_record_count Developer shops may decide to use Read Committed Snapshot Isolation (RCSI) to reduce contention, and possibly improve performance, but it... 06 March 2018 12 min read
Database DevOps Phil Factor in Database DevOps Scripting the Description of Database Tables Using Extended Properties Stored procedures, for example, are very easy to document. The comment block at the beginning stays with the code and... 03 March 2018 28 min read
T-SQL Programming Joe Celko in T-SQL Programming Charles Bachman and Pointer Chains Joe Celko reminisces about the origins of databases and one of the early pioneers, Charles Bachman. He explains how pointer... 28 February 2018 16 min read
BI Robert Sheldon in BI SQL Server Machine Learning Services – Part 6: Merging Data Frames in Python In the final article in this series, Robert Sheldon demonstrates combining data sources with multiple formats into one Python data... 28 February 2018 21 min read
Database Administration Danny Kruge in Database Administration Changing Data Types on Large Tables: The INT to BIGINT Conundrum Changing a data type seems like a simple task unless the table is quite large and downtime must be kept... 19 February 2018 10 min read
BI Robert Sheldon in BI SQL Server Machine Learning Services – Part 5: Generating Multiple Plots in Python Visualization is often the first step in analyzing data. Python makes visualization easy. In this article, Robert Sheldon demonstrates how... 07 February 2018 28 min read
Career Monica Rathbun in Career How to Survive as a Lone DBA Database administrators have enormous responsibility whether they manage one or hundreds of servers. Monica Rathbun tells us how she survived... 06 February 2018 16 min read
Opinion Pieces Joe Celko in Opinion Pieces Degree of Duplication Technology is constantly moving forward, but it is also helpful to understand how we arrived where we are today. Joe... 25 January 2018 13 min read
T-SQL Programming Phil Factor in T-SQL Programming An Easier Way of Pivoting Data in SQL Server There are several methods to pivot, or transpose, data in T-SQL, but most are difficult to understand and write. Phil... 16 January 2018 16 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 Building a Custom Blocked Process Report Blocking in SQL Server is normal behavior, but excessive blocking can lead to many complaints and is a symptom of... 05 January 2018 31 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
