Editorials Kathi Kellenberger in Editorials How different roles view database DevOps Redgate released the 2021 State of Database DevOps Report in February, and I wrote a short article talking about the... 20 April 2021 4 min read
NoSQL Robert Sheldon in NoSQL How to choose between SQL and NoSQL databases Organizations have many choices when it comes to databases. In this article, Robert Sheldon explains how to choose between SQL... 13 April 2021 10 min read
Editorials Kathi Kellenberger in Editorials Can a monitoring tool save money? When I was a DBA responsible for 40 to 50 SQL Server instances, I didn’t have many third-party tools to... 07 April 2021 3 min read
Oracle Jonathan Lewis in Oracle Oracle sequences: The basics Oracle sequences can be used to create artificial IDs for a table. In this article, Jonathan Lewis explains how they... 26 March 2021 14 min read
Testing Julio Sampaio in Testing Load/stress testing .NET apps with Apache JMeter Since Microsoft discontinued their cloud-based load testing services, developers need a new way to test applications. Julio Sampaio demonstrates how... 26 March 2021 11 min read
T-SQL Programming Shel Burkow in T-SQL Programming A data transformation problem in SQL and Scala: Dovetailing declarative solutions Part II In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.… 26 March 2021 15 min read
Security Robert Sheldon in Security What to monitor for SQL Server security Keeping databases secure is critical. In this article, Robert Sheldon explains what to monitor for SQL Server security.… 24 March 2021 11 min read
Featured Kathi Kellenberger in Featured To soon? I’ve noticed that some television shows have been incorporating the Covid-19 pandemic into their recent episodes. (There are some spoilers... 24 March 2021 2 min read
PowerShell Greg Moore in PowerShell PowerShell editors and environments part 2 In this article, Greg Moore demonstrates two additional PowerShell editors: Azure Data Studio Notebooks and Visual Studio Code.… 15 March 2021 12 min read
Editorials Kathi Kellenberger in Editorials Do something that scares you Recently, the editor of SQLServerCentral.com, Steve Jones, shared a video in our team Slack channel that talked about how you... 23 February 2021 2 min read
T-SQL Programming Shel Burkow in T-SQL Programming A data transformation problem in SQL and Scala: Dovetailing declarative solutions This article is an interesting approach to solving a data transformation problem in SQL and Scala. Shel Burkow uses a... 22 February 2021 11 min read
Data Science Ashwin Thota in Data Science How to become a data scientist: A data-driven approach to careers in data science Many devs and IT professionals looking for the next career wonder how to become a data scientist. Ashwin Thota matches... 16 February 2021 11 min read
Editorials Kathi Kellenberger in Editorials Key insights from the 2021 State of Database DevOps survey This is the fifth year that Redgate has surveyed IT professionals about their organization’s DevOps practices. Each year, the number... 15 February 2021 4 min read
Database DevOps Mike Cuppett in Database DevOps Recruiting DBAs for DevOps DBAs are in great demand, but what if you are recruiting a DBA for DevOps? Mike Cuppett explains how to... 04 February 2021 10 min read
PowerShell Greg Moore in PowerShell PowerShell editors and environments part 1 There is no shortage of PowerShell editors and environments for developing and running scripts. Greg Moore explains some of his... 02 February 2021 11 min read
Editorials Kathi Kellenberger in Editorials Falling out of the zone If you are lucky enough to enjoy the work you do, it could be because you are frequently “in the... 27 January 2021 3 min read
Oracle Jonathan Lewis in Oracle Oracle archived redo size – the research Oracle archived redo size may be smaller than that of online redo log files. In this article, Jonathan Lewis takes... 11 January 2021 15 min read
Editorials Brett Newski in Editorials Visit your parents Why is it such a cliché to complain about our parents? You hear it from friends or in films all the time…”damn,... 11 January 2021 3 min read
Data Science Shree Das in Data Science Kubeflow for data scientists introduction Machine learning projects often stall when it's time to deploy. Shree Das introduces Kubeflow for data scientists, an end-to-end solution... 08 January 2021 7 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 4 PFS contention When inserting rows into a heap, SQL Server must sometimes update the PFS page which can PFS contention and affect... 05 January 2021 14 min read
