In this article we’ve collected all the essential information about writing SQL queries into one ultimate guide to help you gain and practice this knowledge more effectively.
In this video and the following article, we’ll take you step-by-step through the process of changing a query’s filter criteria into a SQL variable, then ultimately into a stored procedure.
Sooner or later, you want to know when a column contains in SQL another value. In this article we’ll go over several ways you can test to see whether one value is contained within an another.
Universally Unique IDs (UUIDs) use random numbers to create unique IDs. UUIDs use more storage, but they provide a good solution for distributed databases and security.
When storing data in Azure blob storage, the process of upload a blob is fairly straight forward, and all it takes is setting the access tier to “Archive” to move data to blob storage.
The benefit of this approach is that you can then regularly scan your entire code base for the use of .ExecuteReader and .ExecuteNonQuery knowing that there should be no cases of those methods, other than the exception cases you expect.
In this puzzle, we’re going to learn how to calculate moving averages by working through a hypothetical stock market example. Solving puzzles is a great way to learn SQL. Nothing beats practicing what you’ve learned.
Hello all, in keeping with the last post on the blog, I started doing some posts around High Availability, so ultimately the focus here is how do I architect my solution to ensure that is meets the availability demands of my customers.
Hello all, It’s been a while since I did a blog post outside of the weekly updates. But I wanted to do one in terms of conversations that I’ve been having a lot lately and seems to be largely universal. High Availability.
This multi-part article series discuss migrating your databases, applications and services from SQL Server to PostgreSQL and discusses all the important information you need to be aware of, before beginning a migration project..
This article describes a simple and elegant way to allow write access to ASP.NET apps to the App_Data folder. This is required for applications to work properly when deployed in AWS Beanstalk.. The post Granting write access to ASP.
Part 3 of this multi-part article series discusses the actual migration process: Schema and data migration, ETL/ELT, Reporting & OLAP, Scheduling and Applications & Services migration.. The post Migrating your SQL Server Workloads to PostgreSQL – Part 3 appeared first on The Developer Space..
This article walks you through the summary of most important new features. enhancements and breaking changes in PostgreSQL 12.. The post PostgreSQL 12: New Features and Enhancements appeared first on The Developer Space..
This article describes the new Stored Procedure feature in PostgreSQL 11.5 and shows you how it differs from Functions.. The post PostgreSQL finally gets Stored Procedures appeared first on The Developer Space..
Part 4 of this multi-part article series discusses Maintenance and Monitoring, High Availability, Load Balancing, and Replication and Environment Stabilization.. The post Migrating your SQL Server Workloads to PostgreSQL – Part 4 appeared first on The Developer Space..
Part 2 of this multi-part article series compares SQL Server and PostgreSQL article, database structure, language differences, data type mappings, functions and operators and other important considerations for migration..
In my previous post, I discussed the use of TransactionScope within C# and how it might simplify how transactions are managed within your applications.
In this lesson, we’re going to learn about the While Loop. So, what is a While Loop? Well, While Loop is set up using a While statement. While statements are used to repeatedly execute a block of SQL statements.
I recently put together a lesson on table aliases and multi-table joins. It is part of my Join Together Now course. Click here get the course at a discount.