Loading
Quick takes from developers at work.
Tips, fixes and short write-ups on what developers ran into this week, in their own words.
Learn how SQL Server write-ahead logging persists transaction log records before data pages, enabling durable commits and crash recovery.
Avoid common SQL database recovery mistakes. Learn best practices for manual recovery, when to use specialized tools, and prevent data loss.
What is Normalization? Normalization is the process of organizing data in a database to reduce data redundancy and improve data integrity. Why Does Normalization Play a Significant Role in Enterprise Applications? Data plays a critical role in enterprise applications because the entire application is built around data processing and management. Most enterprise applications follow normalization principles to store data in a structured and efficient manner.
Learn how to extract data from SQL Server using SSMS, SQL queries, BCP, SSIS, SQLCMD, PowerShell, and more. Includes troubleshooting and best practices.
Master SQL Server data types! Learn about numeric, string, date, boolean, binary, and special types. Optimize your database for speed, accuracy, and storage.
Learn what an SSIS package is and how it automates data tasks! This guide covers Control Flow, Data Flow, Connection Managers, and a step-by-step Excel to SQL Server example.
Connect .NET apps to Google Cloud MySQL with C# using dotConnect. Enjoy Direct Mode, advanced ORM, enhanced security, and optimized performance. Simplify cloud data!
Learn how to generate scripts for tables and stored procedures in SQL Server, including both schema and data. This step-by-step guide covers how to use SQL Server Management Studio (SSMS) to export database objects, including CREATE TABLE, INSERT statements, and full stored procedure logic. Ideal for developers, DBAs, and data analysts working on database backup, migration, or documentation. Visual aids and practical examples included.
Master SQL Server Stored Procedures! Learn what they are, why to use them, how to create & execute them with examples. Boost performance & security now!
Explore SQL Server Management Studio 22's newest features! Themes, Git integration, AI-powered assistance, enhanced index options, and more boost DBA productivity.
Explore SQL Server 2025's game-changing features: native AI, JSON support, regex, enhanced query processing, and more. Is it time to upgrade? Find out now!
Master SQL Views for efficient data handling in Angular apps. Simplify queries, enhance security, and boost performance. A must-read for senior developers!
Boost SQL Server performance with large datasets! Learn partitioning, indexing strategies (clustered, non-clustered, filtered, columnstore), and Query Store insights.
These SQL queries demonstrate how to calculate running total sums using the SUM() window function. They show cumulative amounts before and after the current row for office expense claims.
Generates detailed banking credit and debit transaction reports using a table-valued function and stored procedure, calculating real-time balances, handling transfers, and ensuring secure, auditable account activity tracking in SQL Server.
This script dynamically creates temporary tables, populates user and product transaction data, and generates a pivot report with formatted totals, showcasing each user’s product-wise spend and overall transaction summary in SQL Server.
Use ROW_NUMBER() with PARTITION BY to remove duplicates efficiently. Assigns a unique row number, filters duplicates (RN > 1), and deletes them while keeping the first entry. Ideal for cleaning data in SQL databases.
Explore the key differences between stored procedures and functions in SQL Server. Stored procedures are used to execute a series of SQL statements and can perform complex operations, including transactions.
This guide provides step-by-step instructions to troubleshoot and fix common issues during the update process, ensuring your SQL Server remains secure and up-to-date.
The upcoming SQL Server release, expected in 2025, introduces exciting features like enhanced analytics with Azure Synapse integration, S3-compatible object storage, improved availability with contained availability groups, AI and Machine Learning enhancements, performance boosts, and security upgrades.
To trace the organizational hierarchy, start by identifying the immediate manager of an employee. Then, sequentially determine each manager's superior until you reach the highest level of the organization.
Learn efficient SQL methods to remove duplicates from tables using DELETE statements with subqueries and HAVING clauses. Utilize the MAX function and NOT IN operator to streamline database operations and maintain data integrity.
Learn how to remove special characters from strings in SQL Server using T-SQL functions. This guide covers various methods, including using REPLACE, PATINDEX, and user-defined functions, to clean and sanitize your data efficiently.
Learn how to efficiently select 50% of data from a SQL table using the 'SELECT TOP 50 PERCENT' query. This SQL technique is crucial for data sampling and optimizing query performance, often discussed in SQL interviews and database management.
Learn how to efficiently retrieve data from SQL databases when dealing with comma-separated values. Explore SQL queries and techniques for parsing and extracting data from fields containing comma-separated lists, ensuring effective data handling and processing in your applications.
Everything on SQL Server, not only its blogs: the SQL Server page →
Write a blog post and earn +250 SHARP when it is approved.
Write a blog
