Free eBook: Understanding SQL Server Concurrency

• by Press Release

• Redgate

• Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.

“Included columns” for non-clustered indexes explained

• by Michael Salzmann

• SQLServerCentral

• included columns
• Indexes
• Indexing

Microsoft SQL Server has the feature to use “Included columns” for the creation of non-clustered indexes. This feature and its benefits and disadvantages will be explained in the following article. Included columns can be used to create a covering indexes without including all the data into the key columns. This covering index has the advantage […]

What You Should Know About Coding

• by Steve Jones

• SQLServerCentral

• Career
• software development

Today Steve thinks about the skills and approach we ought to be taught before we start building software as a career.

Partitioning Data in SQL Server without using Partitioned Tables

• by Additional Articles

• MSSQLTips.com

• Partitioning

In this we look at how we to quickly split up data from a SQL Server table into relatively equal size buckets.

SQL Server 2019 Graph Database and SHORTEST_PATH

• by Steve Jones

• SQLServerCentral

• Graph databases

With SQL Server 2019 on the way, it’s time to begin learning about all the new features. In this article, Dennes Torres demonstrates how to use the new SHORTEST_PATH function that is part of the Graph Database feature.

Managing SQL Server containers using Docker SDK for Python - Part 2

• by Carlos Robles

• SQLServerCentral

• Containers
• Docker
• Python

There are multiple ways to interact with the Docker daemon, as command line client API or GUI based tools like Kitematic. Docker also provides a SDK for Go and Python,  this SDK can be used to create and manage Docker containers the same way it works with the Docker engine API.

The Crazy Times of Year

• by Steve Jones

• SQLServerCentral

• Career

Do you have busy times of the year that recur regularly? In some positions I've held, we had certain events or processes that always caused additional stress and headaches for employees. As a bartender, certain holidays (New Years, Halloween) were extra crazy. In one company, every quarter was an adventure involving a late, or a […]

A fresh new look for Redgate University

• by Additional Articles

• Redgate

• Conferences, Classes, Events, and Webinars
• Free Training

Last September Redgate University opened its doors online, since then, with their selection of getting started courses they have been helping customers get up and running with their tools. Now, along with a brand-new look, new courses have been added to help you advance your skills past the basic usage of the tools. Come and check it out and leave your suggestions for future courses.

Working with React Components

• by Additional Articles

• SimpleTalk

• .Net

The React library allows teams to work faster and with more consistency. In this article, Camilo Reyes explains how to get started using React components in a C# application

Fantasy SQL Server

• by Steve Jones

• SQLServerCentral

• Database Weekly
• SQL Server

This week Steve looks back at this month's T-SQL Tuesday invitation.