So much of modern programming is about string manipulation. Whether it’s parsing XML content, building HTML for the browser or trying to understand what the user just typed into that text entry field, ...

Let's break down when it's ideal to use the NOLOCK hint and when you should never use it. As a consultant, I work on wide swaths of database systems, which means I get to see many, many SQL statements ...

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of. SQL Server 2016 provides ...

Sign up for the Slatest to get the most insightful analysis, criticism, and advice out there, delivered to your inbox daily. On Wednesday morning, the once iconic ...

I've been playing around with the new Microsoft service, currently in preview and it's time to show off what it can do. Have you ever struggled with a database performance problem or ever struggled to ...

Company responds to global fertilizer uncertainty and rapidly changing market conditions to help ensure American farmers have the nitrogen they need during the peak of spring planting ...

Query groups uses AI to cluster similar search queries. The new card shows total clicks per group and highlights groups trending up or down. Query groups will roll out over the coming weeks to high ...

Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel. You might expect that pivot tables—which can be used to summarize rows and columns of ...

Advanced SQL Operations Task 13: Identify Members with Overdue Books Write a query to identify members who have overdue books (assume a 30-day return period). Display the member's_id, member's name, ...