Below you'll find a list of all posts that have been tagged as “SQL”
Let’s begin with a little thought experiment. Imagine you’re responsible for the next release of your company’s flagship product, and today is the big day: you’re about to give a demo presentation for all the big shots in the company. The CTO is obviously there, since she’s your boss. The CEO is there as well, along with the VP of …
Today we’re going to look at performance tuning PostgreSQL. PostgreSQL is an advanced open source SQL database. Setting up the database is just the first step. With every table you add and every query you run, your databases will require maintenance and updates to ensure that they continue to run efficiently. Although PostgreSQL does make a lot of optimizations for you, there …
SQL performance tuning is a never ending battle. I’m not a DBA, but I am a developer who has pretended to be one for 15 years. I have worked with SQL Server databases with terrabytes of RAM all the way down to Stackify’s massive fleet of little SQL Azure databases. I have seen a little bit of everything over the …
The Java Persistence API (JPA), and Hibernate ORM as its most popular implementation are used in most Java applications to interact with a relational database. The main reason for their popularity is that they use object-relational mapping to abstract the database interactions and make it very easy to implement simple CRUD operations. But this abstraction also has its downsides. Hibernate …
If you’ve ever worked with a database, you’ve likely worked with CRUD operations. CRUD operations are often used with SQL, a topic we’ve covered in depth (see this article, this one, and this one for some of our recent SQL tips and tricks). Since SQL is pretty prominent in the development community, it’s crucial for developers to understand how CRUD operations …
If you use SQL in your work, you have several options available, ranging from enterprise options to the free SQL Server Express. Monitoring SQL queries are just one of the many things you can monitor with Prefix, so today we thought we’d take a closer look at how SQL Server Express stacks up to the more advanced, paid options, its …
Almost every ASP.NET application uses some sort of database. But from my experience, the reporting of how long SQL queries take is wildly inaccurate. In this article I’m going to explain why, and show you how you can see the real amount of time that your queries take. This article is really specific to Microsoft SQL Server but the principle …
