WITspiration - Year 2
A new cohort of WITspiration is strating, the women in technology mentoring circle.
Bridging Snowflake and Azure Data Stack: A Step-by-Step Guide
This article shows how to access Snowflake information from Synapse Analytics.
DBCC CLONEDATABASE is Semi-Discontinued
Microsoft is no longer supporting some uses for DBCC CLONEDATABASE. Read a few of Steve's thoughts on the change.
Who’s Changing the Table? Answers and Discussion
Your challenge for this week was to find out who keeps mangling the contents of the AboutMe column in the Stack Overflow database.
On Being an "Expert"
I had the opportunity last week to present a session at DataSaturdays Stockholm. I can't say enough nice things about the event and the organizers. I presented on Query Store in SQL Server. In my mind, it's an entry-level to middle tier presentation. Most of the room was already working with Query Store, some quite […]
PostgreSQL UNION, INTERCEPT & EXCEPT Operator
Another article on how the SQL language works in PostgreSQL. This time we examine the UNION, INTERSECT, and EXCEPT operators.
SQL Bulk Insert Command Examples
Learn about the SQL Server BULK INSERT command and how to use it to import text data in a SQL Server database table.
Common Algorithm Concerns
Steve doesn't have a lot of concerns about AI models writing code and reusing algorithms, but others might not feel the same way.
Enhancing Web Application Performance through Database Optimization: A Comprehensive Study
In the contemporary digital landscape, web applications play a pivotal role in delivering services and facilitating interactions between users and businesses. However, the performance of these applications heavily relies on the efficiency of underlying databases. This comprehensive study aims to explore the intricate relationship between database optimization techniques and web application performance enhancement. The study begins by delineating the significance of web application performance and its correlation with database operations. It examines various factors affecting performance, including data retrieval, storage, and processing. Furthermore, it identifies common challenges such as latency, scalability issues, and inefficient query execution. Through an extensive review of the literature, this study evaluates state-of-the-art database optimization methodologies and their applicability to web applications. Techniques such as indexing, query optimization, denormalization, caching mechanisms, and data partitioning are scrutinized, highlighting their potential to mitigate performance bottlenecks. Moreover, the study investigates emerging trends and technologies in database management systems (DBMS), such as NoSQL databases, in-memory databases, and cloud-based solutions. It assesses their suitability for enhancing web application performance, considering factors like data volume, query complexity, and real-time processing requirements.
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers