Latest published stories - DeveloperSites

All

1
likes

When and When Not To Use NOLOCK

published 524 days, 18 hours, 33 minutes ago posted by

matthewpomar 534 days, 16 hours, 44 minutes ago

To NOLOCK or Not to NOLOCK... That is the question. Lots of developers who don't fully understand the requirements of their application or how NOLOCK works will indiscriminately add NOLOCK to all of the SQL queries. But doing so isn't always the best decision. Brent Ozar describes some times when it is beneficial to use NOLOCK and times where it isn't the right choice. (more)

category: SQL Server | clicked: 1 | comment | | source: www.brentozar.com

tags: MS SQL, Performance

1
likes

Good Reasons Not To Use SQL Server To Send Emails

published 524 days, 18 hours, 33 minutes ago posted by

matthewpomar 534 days, 16 hours, 51 minutes ago

Good Reasons Not To Use SQL Server To Send Emails

When all you have is a hammer, everything looks like a nail. Over the years, I have seen my fair share of complex SQL Server applications, where loads of business logic exist in stored procedures and cursors churn through thousands of records handling complex business rules and sending out emails. But there are some really good reasons not to send emails from SQL Server. In his blog, Brent Ozar describes some of these reasons. (more)

category: SQL Server | clicked: 3 | comment | | source: www.brentozar.com

tags: Email, MS SQL

1
likes

Want to get a job as a programmer? Learn these high demand languages.

published 531 days, 16 hours, 30 minutes ago posted by

matthewpomar 536 days, 17 hours, 5 minutes ago

Want to get a job as a programmer? Learn these high demand languages.

Are you wanting a new career as programmer and don't know where to start? There are so many choices of specialization in the programming world that is can be incredibly overwhelming to decide what programming languages to learn and even harder to know which ones are in demand. The good news is, most programming language concepts are transferable, so even if you decide to learn, let's say PHP today, it will be far easier for you to pickup another language, such as JSP, as many of the concepts are transfe... (more)

category: PHP | clicked: 5 | comment | | source: www.youtube.com

tags: JavaScript, PHP, Python, Video

1
likes

12+ Things You MUST DO Before Changing WordPress Themes

published 531 days, 16 hours, 30 minutes ago posted by

matthewpomar 539 days, 11 hours, 14 minutes ago

12+ Things You MUST DO Before Changing WordPress Themes

Are you wondering what you should do before you change WordPress themes? When switching your WordPress theme, there are few very important steps that you must take to ensure the process is smooth, and you don’t lose any important data. In this WordPress checklist, we’ll share the top things you must do before you change WordPress themes. (more)

category: WordPress | clicked: 4 | comment | | source: www.wpbeginner.com

tags: Theme

1
likes

How to Add Product Tags, Attributes, and Categories to WooCommerce

published 531 days, 16 hours, 30 minutes ago posted by

matthewpomar 539 days, 11 hours, 17 minutes ago

How to Add Product Tags, Attributes, and Categories to WooCommerce

Do you want to learn how to add tags, attributes, and categories to your WooCommerce products? By optimizing your WooCommerce product listings, you can help your visitors find what they’re looking for and get more traffic from search engines and social media. In this article, we’ll show you how to add product tags, attributes, categories, and more in WooCommerce, step by step. (more)

category: WordPress | clicked: 1 | comment | | source: www.wpbeginner.com

tags: WooCommerce

1
likes

The Many Faces of DISTINCT in PostgreSQL

published 534 days, 15 hours, 6 minutes ago posted by

matthewpomar 543 days, 17 hours, 32 minutes ago

The Many Faces of DISTINCT in PostgreSQL

I started my programming career as an Oracle DBA. It took a few years but eventually I got fed up with the corporate world and I went about doing my own thing. After I gotten over not having proper partitions and MERGE statement, I found some nice unique features in PostgreSQL. Oddly enough, a lot of them contained the word DISTINCT. (more)

category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com

tags: SQL

1
likes

9 Django Tips for Working with Databases

published 534 days, 15 hours, 6 minutes ago posted by

matthewpomar 543 days, 17 hours, 36 minutes ago

9 Django Tips for Working with Databases

ORMs offer great utility for developers but abstracting access to the database has its costs. Developers who are willing to poke around the database and change some defaults often find that great improvements can be made. (more)

category: Django | clicked: 1 | comment | | source: hakibenita.com

tags: ORM, Performance, PostgreSQL, SQL

1
likes

Be Careful With CTE in PostgreSQL

published 534 days, 15 hours, 6 minutes ago posted by

matthewpomar 543 days, 18 hours, 18 minutes ago

PostgreSQL, SQL, PerformanceHow to avoid common pitfalls with common table expressions in PostgreSQL Common table expressions (CTE), also known as the WITH clause, are a very useful feature. They help break down big queries into smaller pieces which makes it easier to read and understand. PostgreSQL Version This article is intended for PostgreSQL versions 11 and prior. Starting at version 12, PostgreSQL changed the way it treats CTE to prevent the issues described in this article.Wha... (more)

category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com

tags: Performance, SQL

1
likes

How We Solved a Storage Problem in PostgreSQL Without Adding a Single Byte of Storage

published 534 days, 15 hours, 6 minutes ago posted by

matthewpomar 543 days, 18 hours, 21 minutes ago

How We Solved a Storage Problem in PostgreSQL Without Adding a Single Byte of Storage

A while back we started getting alerts in the middle of the night on low disk space. A quick investigation led us to one of our ETL tasks. Every night the task was fired to eliminate duplicate dumps, and free up some space. This is a short story about how we found our silver bullet and solved the issue without adding a single byte of storage. (more)

category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com

tags: Performance, SQL

1
likes

How to Create an Index in Django Without Downtime

published 534 days, 15 hours, 6 minutes ago posted by

matthewpomar 543 days, 18 hours, 27 minutes ago

How to Create an Index in Django Without Downtime

In this step-by-step Python tutorial, you'll get a solid understanding of the limitations of Django migrations by tackling a well known problem: creating an index in Django with no downtime. (more)

category: Django | clicked: 1 | comment | | source: realpython.com

tags: ORM, PostgreSQL, SQL

1
likes

Fastest Way to Load Data Into PostgreSQL Using Python

published 534 days, 15 hours, 6 minutes ago posted by

matthewpomar 543 days, 18 hours, 32 minutes ago

Fastest Way to Load Data Into PostgreSQL Using Python

Explore the best way to import messy data from remote source into PostgreSQL using Python and Psycopg2. The data is big, fetched from a remote source, and needs to be cleaned and transformed. (more)

category: PostgreSQL | clicked: 7 | comment | | source: hakibenita.com

tags: Performance, Python

1
likes

How to Get the First or Last Value in a Group Using Group By in SQL

published 534 days, 15 hours, 6 minutes ago posted by

matthewpomar 543 days, 18 hours, 33 minutes ago

How to Get the First or Last Value in a Group Using Group By in SQL

Getting the last value of a group in an aggregated query in PostgreSQL is a challenging task. In this article we present a simple way to get the first or last value of a group using group by. (more)

category: PostgreSQL | clicked: 1 | comment | | source: hakibenita.com

tags: SQL

1
likes

How To Prevent SQL Injection Attacks With Python

published 534 days, 15 hours, 6 minutes ago posted by

matthewpomar 543 days, 18 hours, 35 minutes ago

How To Prevent SQL Injection Attacks With Python

SQL injection attacks are one of the most common web application security threat and one of the easiest to prevent. Web application attackers will surely test your web application for this security vulnerability so you must take steps to ensure that this security hole is plugged, and plugged fast! SQL injection attacks are made possible by allowing non-escaped single or double quote strings to be included in your database's SQL call. This can be done very easily by an attacker by including a partial SQL... (more)

category: Python | clicked: 7 | 1 comment | | source: realpython.com

tags: ORM, PostgreSQL, Security, SQL

1
likes

12 Common Mistakes and Missed Optimization Opportunities in SQL

published 534 days, 15 hours, 6 minutes ago posted by

matthewpomar 543 days, 18 hours, 38 minutes ago

12 Common Mistakes and Missed Optimization Opportunities in SQL

SQL is used by analysts, data scientists, product managers, designers and many others. These professionals have access to databases, but they don't always have the intuition and understanding to write efficient queries. In an effort to make my team write better SQL, I went over reports written by non-developers and code reviews, and gathered common mistakes and missed optimization opportunities in SQL. (more)

category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com

tags: Performance, SQL

1
likes

The Surprising Impact of Medium-Size Texts on PostgreSQL Performance

published 534 days, 15 hours, 6 minutes ago posted by

matthewpomar 543 days, 18 hours, 50 minutes ago

The Surprising Impact of Medium-Size Texts on PostgreSQL Performance

Any database schema is likely to have plenty of text fields. In this article I demonstrate the surprising impact of medium-size texts on query performance. (more)

category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com

tags: Performance, SQL

1
likes

Re-Introducing Hash Indexes in PostgreSQL

published 534 days, 15 hours, 6 minutes ago posted by

matthewpomar 543 days, 18 hours, 51 minutes ago

Re-Introducing Hash Indexes in PostgreSQL

There is a type of index you are probably not using, and may have never even heard of. It is wildly unpopular, and until a few PostgreSQL versions ago it was highly discouraged and borderline unusable, but under some circumstances it can out-perform even a B-Tree index. (more)

category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com

tags: Performance, SQL

1
likes

The Unexpected Find That Freed 20GB of Unused Index Space

published 534 days, 15 hours, 6 minutes ago posted by

matthewpomar 543 days, 18 hours, 53 minutes ago

The Unexpected Find That Freed 20GB of Unused Index Space

In this article I describe the process we took to identify potential free space, and one surprising find that helped up clear up ~10GB of unused indexed values! (more)

category: PostgreSQL | clicked: 2 | comment | | source: hakibenita.com

tags: Django, ORM

1
likes

Practical SQL for Data Analysis

published 534 days, 15 hours, 6 minutes ago posted by

matthewpomar 543 days, 18 hours, 54 minutes ago

Pandas is by far the most popular tool for data analysis. It's packed with useful features, it's battle tested and widely accepted. However, pandas comes at a cost which is often overlooked. SQL databases has been around since the 1970s. They contain many features that most developers never heard of, and I want to bring some of them to light. (more)

category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com

tags: SQL

1
likes

18+ Powerful PostgreSQL Features You Didn't Know Existed

published 534 days, 15 hours, 6 minutes ago posted by

matthewpomar 543 days, 19 hours, 15 minutes ago

18+ Powerful PostgreSQL Features You Didn't Know Existed

PostgreSQL is a powerful, full featured relational database management system. However, this free and open-source DBMS has a surprising number of fantastic features most PostgreSQL developers don't know anything about. In this article, Haki Benita, a renown and respected blogger on PostgreSQL, Python, and related technologies, list more than 18 lesser known PostgreSQL features that can improve your productivity and make your life easier as a PostgreSQL developer or admin. (more)

category: PostgreSQL | clicked: 5 | 1 comment | | source: hakibenita.com

tags: SQL

Welcome!

All

When and When Not To Use NOLOCK

Good Reasons Not To Use SQL Server To Send Emails

Want to get a job as a programmer? Learn these high demand languages.

12+ Things You MUST DO Before Changing WordPress Themes

How to Add Product Tags, Attributes, and Categories to WooCommerce

The Many Faces of DISTINCT in PostgreSQL

9 Django Tips for Working with Databases

Be Careful With CTE in PostgreSQL

How We Solved a Storage Problem in PostgreSQL Without Adding a Single Byte of Storage

How to Create an Index in Django Without Downtime

Fastest Way to Load Data Into PostgreSQL Using Python

How to Get the First or Last Value in a Group Using Group By in SQL

How To Prevent SQL Injection Attacks With Python

12 Common Mistakes and Missed Optimization Opportunities in SQL

The Surprising Impact of Medium-Size Texts on PostgreSQL Performance

Re-Introducing Hash Indexes in PostgreSQL

The Unexpected Find That Freed 20GB of Unused Index Space

Practical SQL for Data Analysis

18+ Powerful PostgreSQL Features You Didn't Know Existed

Open ID Login

Standard Login

Forgot Password?

Sign up