T-SQL Programming Darko Martinović in T-SQL Programming Converting a Database to In-Memory OLTP In-Memory OLTP was introduced with SQL Server 2014 as a way to improve transaction performance. There are several scenarios that... 10 May 2018 29 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 Collections into SQL Server Microsoft introduced native support for JSON in SQL Server in version 2016. In this article, Phil Factor shows how to... 09 May 2018 20 min read
T-SQL Programming Robert Sheldon in T-SQL Programming SQL Server Graph Databases – Part 5: Importing Relational Data into a Graph Database In the final article of this series, Robert Sheldon shows how to move from a relational structure to a graph... 30 April 2018 19 min read
T-SQL Programming Robert Sheldon in T-SQL Programming SQL Server Graph Databases – Part 4: Working with Hierarchical Data in a Graph Database The Graph Database feature, new with SQL Server 2017, can be used to represent hierarchies. In this article of the... 23 April 2018 21 min read
Containers and Virtualization Laerte Junior in Containers and Virtualization Provisioning SQL Server Instances with Docker With SQL Server 2017, Microsoft announced the exciting news that SQL Server would now run in Docker containers. Laerte Junior... 16 April 2018 12 min read
Data Privacy and Protection Hugo Kornelis in Data Privacy and Protection Execution Plans and Data Protection One of the most important tools for query tuning is the ability to view execution plans. They are even portable;... 10 April 2018 23 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server Closure Tables SQL Server has a couple of different ways to represent hierarchies, but they do not allow storing any additional information... 10 April 2018 21 min read
T-SQL Programming Robert Sheldon in T-SQL Programming SQL Server Graph Databases – Part 3: Modifying Data in a Graph Database Modifying data in Graph Database tables is similar to working with traditional tables, but there are several things to consider.... 10 April 2018 19 min read
Darko Martinović Programming SQL Server with SQL Server Management Objects Framework SQL Server Management Objects (SMO) is a great tool for managing SQL Server. Darko Martinovic demonstrates how to use SMO... 09 April 2018 26 min read
Database Administration Seth Delconte in Database Administration Recover Data in SQL Server AWS RDS with the Help of BACPAC With Amazon RDS, it’s easy to have a SQL Server running in minutes. There are some limitations, though. Seth Delconte... 22 March 2018 15 min read
T-SQL Programming Robert Sheldon in T-SQL Programming SQL Server Graph Databases – Part 2: Querying Data in a Graph Database Along with Graph Databases, Microsoft has introduced the new MATCH function for querying them. Robert Sheldon explains how to use... 22 March 2018 14 min read
Database Administration Prashanth Jayaram in Database Administration Mount SQL Server DMVs and Custom Queries Using DBFS on Linux With SQL Server now supported on Linux, traditional SQL Server DBAs will need to learn how to work with Linux,... 20 March 2018 14 min read
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
