Below you'll find a list of all posts that have been tagged as “SQL”
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 …
