Database DevOps Phil Factor in Database DevOps But the Database Worked in Development! Preventing Broken Constraints Database table constraints such as foreign keys and default values ensure reliability of the data. In this article, Phil Factor... 08 January 2020 19 min read
PowerShell Greg Moore in PowerShell Comments and More in PowerShell Comments are helpful when programming in any language, and PowerShell is no exception. In this article, Greg Moore demonstrates how... 03 January 2020 12 min read
Editorials Kathi Kellenberger in Editorials Why the Database Must be Part of DevOps According to Microsoft, DevOps is “the union of people, process, and products to enable continuous delivery of value to our... 01 January 2020 3 min read
NoSQL Shel Burkow in NoSQL Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key As many companies consider moving data to NoSQL, Cassandra may be the choice. In this series, Shel Burkow discusses design... 18 December 2019 13 min read
PowerShell Allen White in PowerShell Portable Objects in PowerShell with CLIXML PowerShell is a widely used tool for administrators. In this article, Allen White shows how to export objects using CLIXML... 17 December 2019 16 min read
.NET Lance Talbert in .NET Debugging in Unity Developers probably spend as much time debugging as they do writing code. In this article, Lance Talbert demonstrates how to... 13 December 2019 15 min read
Editorials Kathi Kellenberger in Editorials Distractions at Work Many jobs in technology, especially those that involve writing code, take concentration and focus. It’s often called being “in the... 04 December 2019 3 min read
PowerShell Greg Moore in PowerShell Building a Countdown Timer with PowerShell Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that... 03 December 2019 11 min read
Database DevOps Robert Sheldon in Database DevOps 10 Guidelines for Implementing DevOps Robert Sheldon discusses ten guidelines for implementing DevOps, helping organizations get started improving their application delivery processes.… 12 November 2019 13 min read
Editorials Kathi Kellenberger in Editorials The Ignite Conference Brought News and Changes The first week of November was a big week for Microsoft. They made many announcements at the Ignite conference about... 11 November 2019 3 min read
.NET Lance Talbert in .NET Creating a Shader in Unity The visual elements of games are very important, and there is a lot to learn before you create the next... 04 November 2019 13 min read
T-SQL Programming Joe Celko in T-SQL Programming Understanding Auctions We participate in auctions all the time even when we don’t realize it. In this article, Joe Celko discusses the... 29 October 2019 13 min read
Editorials Kathi Kellenberger in Editorials Moving on from Volunteer Projects I can’t remember a time when I was not involved in side-projects, usually as a volunteer but also writing books... 23 October 2019 3 min read
Database DevOps Rahul Varshneya in Database DevOps Establishing a DevOps Organization In this article, Rahul Varshneya explains some of the benefits and reviews the stages of establishing a DevOps organization.… 08 October 2019 7 min read
T-SQL Programming Joe Celko in T-SQL Programming SQL and Scope Understanding scoping rules is a basic skill for developers. In this article, Joe Celko gives a bit of the history... 07 October 2019 20 min read
Editorials Kathi Kellenberger in Editorials Lessons Learned From Modelling Clay I never allowed my children play with modelling clay in my home when they were young, but changed my mind... 06 October 2019 3 min read
.NET Lance Talbert in .NET Using the iTween Plugin for Unity Video games often contain animation of the objects and characters, but how is that accomplished? In this article, Lance Talbert... 27 September 2019 15 min read
PowerShell Greg Moore in PowerShell How to Use Parameters in PowerShell Part I Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that... 17 September 2019 12 min read
Editorials Kathi Kellenberger in Editorials The Data-Philes Team Meet the Time Traveler The year is 1999, somewhere in Cambridge, UK. Kathi, a member of the Data-Philes team, is reading a memo sent... 11 September 2019 4 min read
T-SQL Programming Dennes Torres in T-SQL Programming SQL Server 2019 Graph Database and SHORTEST_PATH With SQL Server 2019 on the way, it’s time to begin learning about all the new features. In this article,... 11 September 2019 13 min read