Forget the endless list of SQL questions — these 6 advanced queries are the ones interviewers actually care about
When it comes to developer interviews, SQL always shows up like...
How to keep your database bills low while making your queries fly like a sports car
Hey there, fellow data wrangler! If you’re here, you’re probably scratching your head over...
There are projects you never forget.
For me, it was the night (actually, many nights) we moved over a billion recordsfrom our old database to a new one…
without a single second...
A database is like a joke — if you have to explain it, it’s probably not designed well…
Picture this: It’s 3AM on a Saturday morning, and I’m sitting at my desk, three hours...
Dapper is a lightweight ORM (Object-Relational Mapping) framework for .NET Core and is commonly used to query databases in .NET Core applications. Here are some of the advanced features of Dapper in .NET Core:
Dapper is a micro-ORM or a Data Mapper. It internally uses ADO.NET. Additionally, Dapper maps the ADO.NET data structures to your custom POCO classes. As this is additional work Dapper does, in theory,...
This article describes ways to improve SQL query performance for very large data sets having million and billions of records in many tables.
Introduction
I have been working on one of...
This article assesses the design approach of my free index maintenance tool for SQL Server and Azure: SQL Index Manager. The article analyzes the approach of the RedGate SQL Index Manager (v1.1.9.1378) and DevArt - dbForge Index...
Some time ago, Phil Factor wrote his booklet 'SQL Code Smells', collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published...
