Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 6 SQL Server has many tools used to make it secure. In this article, Robert Sheldon demonstrates several of these features... 29 May 2019 15 min read
Containers and Virtualization Carlos Robles in Containers and Virtualization Creating Your First SQL Server Docker Container in macOS The use of macOS by developers and IT professionals has gained popularity the past few years. Running a sandboxed SQL... 13 May 2019 14 min read
Testing Michael Sorens in Testing The Phantom Menace in Unit Testing Testing is a challenging yet crucial part of software development, but how do you know that a test is telling... 09 May 2019 10 min read
Editorials Kathi Kellenberger in Editorials Why DBAs Must Embrace DevOps A good day for a database administrator (DBA) is a lot like a good airline flight. A lot of excitement... 09 May 2019 3 min read
Editorials Kendra Little in Editorials What is Automation? Today I got a bit closer to a meaningful definition of automation as it applies to the software development process.... 30 April 2019 5 min read
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 Scary Stories from the Trenches If you have worked with databases long enough, you probably have many frightening stories to tell about things that have... 03 April 2019 3 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
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 3 SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the... 25 February 2019 14 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
Editorials Kathi Kellenberger in Editorials Protecting Data During Development In the years before joining Redgate, I was a SQL Server database consultant. I spent a lot of time doing... 20 February 2019 3 min read
Database DevOps Grant Fritchey in Database DevOps DevOps Without the Database: A Cautionary Tale Communication is the foundation of DevOps. Grant Fritchey tells the tale of a project that failed because of previous communication... 07 February 2019 12 min read
Editorials Robert Cain in Editorials What is the purpose of your organization? A lesson in DevOps I’ve been speaking a lot on the topic of DevOps lately, and there’s a question I like to ask. What... 29 January 2019 5 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
Editorials Kendra Little in Editorials Implementing DevOps Doesn’t Get Rid of Database Administrators I hear from a lot of database administrators who are worried about being automated out of a job. These kinds... 21 January 2019 5 min read
Editorials Arvind Kumar in Editorials The Case for Value-Based Delivery In the past, I was very proud that I’d meticulously defended my projects against scope creep, but I was missing... 08 January 2019 3 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
Database Administration Greg Larsen in Database Administration Protecting SQL Server Data Using Static Data Masking In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and... 07 January 2019 19 min read