Editorials Louis Davidson in Editorials What Counts for a DBA – Deadlines Everyone needs deadlines. Even the beavers. They loaf around all summer, but when they are faced with the winter deadline,... 01 June 2021 4 min read
Editorials Kathi Kellenberger in Editorials PASS Data Community Summit 2021 I began attending PASS Summit in 2003. I had no idea that it would change the course of my career... 13 May 2021 2 min read
Oracle Jonathan Lewis in Oracle Oracle Sequences: RAC Using sequences when scaling up with Oracle RAC presents more issues with contention. In this article, Jonathan Lewis explains how... 11 May 2021 19 min read
.NET Diogo Souza in .NET Setting up a Kafka test environment with Kafdrop Kafdrop is n open source project that allows you to view information from Kafka brokers. In this article, Diogo Souza... 10 May 2021 9 min read
Theory and design Joe Celko in Theory and design Constraints and declarative referential integrity Database systems have powerful features built right in that can ensure the integrity of data. In this article, Joe Celko... 06 May 2021 14 min read
Editorials Kathi Kellenberger in Editorials What is an ad hoc query? Someone recently asked me which queries are ad hoc in SQL Server. An ad hoc query is a single query... 04 May 2021 4 min read
Security Greg Larsen in Security SQL Server security – Providing a security model using user-defined roles Greg Larsen continues his series and shows how user-defined roles roles can control SQL Server security.… 26 April 2021 13 min read
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
