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: Model Hierarchies in SQL

Learn the closure table pattern for modeling hierarchies in SQL Server. Convert self-referencing tables to separate node and edge tables...

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

Oracle

Samuel Nitsche in Oracle

Strongholds of Confidence: Self-Testing Your Database

Unit testing and even Test-Driven Development is possible for databases. In this article Samuel Nitsche makes the case for introducing...

04 April 2018 17 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

.NET

Darko Martinović in .NET

Transposing SQL Server Query Results with SQLCLR: Dynamic Row-to-Column Rotation

Transpose SQL Server query results dynamically using a SQLCLR stored procedure - no need to know column names in advance....

13 March 2018 18 min read

T-SQL Programming

Robert Sheldon in T-SQL Programming

SQL Server Graph Databases: Nodes, Edges & MATCH (Part 1)

Introduction to SQL Server graph databases: create node and edge tables, define relationships with CREATE TABLE AS NODE/EDGE, and query...

06 March 2018 17 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

Script SQL Server Extended Properties for Table Documentation

Learn to script SQL Server extended properties for table and column documentation using a JSON-based approach. Includes T-SQL functions, automation...

03 March 2018 31 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

Merge SQL Server Data with CSV Files in Python Using pandas (MLS Part 6)

Merge a SQL Server data frame with a CSV file data frame in Python using pandas merge() inside SQL Server...

28 February 2018 22 min read

Oracle

Nick Buytaert in Oracle

Validating naming conventions in Oracle

Most development teams have agreed upon some sort of naming convention as it typically increases the readability and comprehension of...

20 February 2018 8 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