Security Robert Sheldon in Security Introduction to SQL Server Security — Part 5 SQL Server contains many built-in views and functions that can be used to understand what is going on “under the... 23 April 2019 21 min read
Editorials Kathi Kellenberger in Editorials The Future of Medicine If you are a Star Trek fan, you’ve seen the future of medicine, or at least how the writers imagine... 17 April 2019 3 min read
Performance Samir Behara in Performance Designing Highly Scalable Database Architectures While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and... 09 April 2019 13 min read
Oracle Cynthia Dzikiti in Oracle Security Considerations for ERP Applications Security is, or at least should be, the priority for any IT system. In this article, Cynthia Dzikiti discusses the... 01 April 2019 16 min read
Data Privacy and Protection Grant Fritchey in Data Privacy and Protection GDPR in the USA GDPR enforcement began in May of 2018, but if you are doing business in the US, you may not think... 28 March 2019 10 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 4 The sa account is the most powerful account in a SQL Server instance, and most DBAs disable it. There are... 26 March 2019 19 min read
.NET Lance Talbert in .NET Breaking the 4th Wall with Unity Even when creating games, your code has access to environment variables and document files. In this article, Lance Talbert shows... 12 March 2019 16 min read
Editorials Kendra Little in Editorials Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures “There are only two hard things in Computer Science: cache invalidation and naming things” Phil Karlton I’m terrible at naming... 12 March 2019 4 min read
Blogs Kathi Kellenberger in Blogs Help Shape the Future of SQL Monitor Each year, Redgate runs a survey to ask the folks at companies, from DBAs and Devs to CIOs, about how... 12 March 2019 1 min read
NoSQL Adam Aspin in NoSQL Introduction to SQL for Cosmos DB This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer.... 06 March 2019 22 min read
Editorials Kathi Kellenberger in Editorials Celebrating Women in Tech NASA recently named a facility in honour of Katherine Johnson, the mathematician who performed the calculations for space flights in... 04 March 2019 3 min read
Software Delivery Afsana Atar in Software Delivery Applied AI in Software Development Artificial Intelligence is making inroads in all aspects of technology. In this article, Afsana Atar explains the role of AI... 20 February 2019 14 min read
.NET Lance Talbert in .NET Basic Modding with Unity It's even more fun to play a game when you can customize it, but creating such a game is more... 11 February 2019 11 min read
NoSQL Pushpa Sekhara Reddy Matli in NoSQL Apache Cassandra Data Modeling and Query Best Practices Organizations have many choices when it comes to database platforms. Choosing the right one for an application should be based... 07 February 2019 11 min read
PowerShell Greg Moore in PowerShell Using a Server List to Control PowerShell Scripts PowerShell is the preferred tool for many DBAs when automating SQL Server administration. In this article, Greg Moore demonstrates how... 29 January 2019 13 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 2 In this article, the second in the series, Robert Sheldon demonstrates how to manage the SQL Server security with granting... 28 January 2019 23 min read
.NET Lance Talbert in .NET Introduction to Mobile Development with Unity In today’s world, some people do not need computers because they can do everything on their smartphones. Playing games is... 16 January 2019 17 min read
T-SQL Programming Joe Celko in T-SQL Programming Empty Thoughts: Working with NULL Whether or not to have NULLable columns in a table can be a religious debate, and how missing data is... 10 January 2019 12 min read
.NET Joydip Kanjilal in .NET Policy-based Authorization in ASP.NET Core – A Deep Dive Getting security right is always necessary but often not easy. In this article, Joydip Kanjilal describes policy-based authorization in ASP.NET... 08 January 2019 13 min read
Software Delivery Michael Sorens in Software Delivery Better Code Reviews with GIT As more dev teams move their code to Git, it’s important to understand the differences between it and other tools... 07 January 2019 12 min read
