NEW POST:
Remove IDENTITY Property From a Column
A (mostly) simple option that doesn't require any I/O...or the need for a large maintenance window.
Dave Mason
https://www.davemason.me/2025/05/03/remove-identity-property-from-a-column
ANN: Database Workbench 6.7.0 released
- ability to view vector embeddings in PostgreSQL
- quick CSV import/export
- faster foreign key creation
- bugfixes in PostgreSQL, Firebird, InterBase and SQLite modules
https://www.upscene.com/news/item/20250425
#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench
This looks really useful: sp_IndexCleanup
It's a stored procedure from Erik Darling that analyzes SQL Server indexes. It checks for things like unused indexes, uncompressed indexes, overlapping indexes, duplicated/nearly duplicated indexes, etc. And if I understood the video, if generates 'cleanup' scripts. Cool!
| SQL Server – 2nd Course | – | Triggers – After Trigger , Instead of Triggers |
by : Dr. Mohamed El Desouki mohamed_eldesouki@hotmail.com #sql , #sqlserver ,#database ,#desouki,#الدسوقى Advanced ... source
https://quadexcel.com/wp/sql-server-2nd-course-triggers-after-trigger-instead-of-triggers/
A couple of nice database victories today. Two large tables each had one column storing DATETIME data and another column storing UNIQUEIDENTIFIER (aka GUID) data. Both columns were incorrectly using data type VARCHAR.
Changing to the appropriate types dropped table sizes from 10.62GB to 4.91GB and from 8.56GB to 6.44GB.
I put an execution plan from #SQLServer into an AI to see if it could figure out performance improvements for a query: https://www.scarydba.com/2025/04/21/can-ai-read-execution-plans/
Managing Multi-Tenant User Access with T-SQL Constraints
Master Multi-Tenant User Access in SQL Server using partial unique indexes! Maintain data integrity & flexibility with unique constraints, even when allowing default/null values. #SQLServer #PartialIndexes #MultiTenant #DataIntegrity #UniqueConstraints #DatabaseDesign
https://tech-champion.com/database/sql-server/managing-multi-tenant-user-access-with-t-sql-constraints/
...
Optimizing PostgreSQL Queries: Understanding Index Usage and the Leftmost Prefix Rule
Optimizing PostgreSQL queries? Understand index usage & the leftmost prefix rule for better performance. Proper index design is key! #PostgreSQL #SQLServer #DatabaseOptimization #IndexOptimization #LeftmostPrefixRule
https://tech-champion.com/database/sql-server/optimizing-postgresql-queries-understanding-index-usage-and-the-leftmost-prefix-rule/
...
SQL Table Data Retrieval: Handling Tables With and Without Primary Keys
Learn efficient SQL Table Data Retrieval techniques for SQL Server, handling tables with & without primary keys. Master comprehensive column metadata retrieval for robust data analysis! #SQLServer #DatabaseAdmin #DataAnalysis #SQLquery #DataRetrieval #ColumnMetadata
https://tech-champion.com/database/sql-server/sql-table-data-retrieval-handling-tables-with-and-without-primary-keys/
...
SQL Server JSON Parsing: Handling Special Characters in OPENJSON
Master SQL Server JSON parsing, even with special characters! Learn to reliably extract data using OPENJSON and JSON paths. Avoid common pitfalls and ensure accurate data retrieval. #SQLServerJSONParsing #JSONParsing #SpecialCharacters #DataExtraction #SQLServer #OPENJSON
https://tech-champion.com/database/sql-server/sql-server-json-parsing-handling-special-characters-in-openjson/
...
Troubleshooting Airflow SQL Server Errors: A Case Study of System Task Initialization Failure
Troubleshoot frustrating Airflow SQL Server errors! This post helps diagnose & fix system task initialization failures and other connection issues. Learn to build robust data pipelines. #AirflowSQLServerErrors #DataEngineering #SQLServer #ApacheAirflow #DatabaseConnection #DataPipelines
https://tech-champion.com/database/sql-server/troubleshooting-airflow-sql-server-errors-a-case-study-of-system-tas...
Understanding SQL Server BIGINT Data Type and Implicit Conversions
Master SQL Server BIGINT data type conversions! Avoid implicit casting issues & use explicit CAST/CONVERT for robust code. Prevent subtle bugs & improve readability. #SQLServer #BIGINT #DataTypeConversion #ImplicitCasting #ExplicitCasting #Database
https://tech-champion.com/database/sql-server/understanding-sql-server-bigint-data-type-and-implicit-conversions/
...
SQL Server User Permissions: A Comprehensive Guide to Schema Privileges
Master SQL Server User Permissions for robust database security! Learn to analyze permissions across schemas, join system views efficiently, and handle null values. #SQLServer #DatabaseSecurity #UserPermissions #SQLtutorial #DataAnalysis #SchemaManagement
https://tech-champion.com/database/sql-server/sql-server-user-permissions-a-comprehensive-guide-to-schema-privileges/
...
SQL Server String Aggregation: SQL Server 2016 vs. 2017
Master SQL Server String Aggregation across versions (2016+). Learn dynamic SQL, best practices, & secure techniques to prevent SQL injection. #SQLServer #DynamicSQL #StringAggregation #Database #SQLInjection #Programming
https://tech-champion.com/general/sql-server-string-aggregation-sql-server-2016-vs-2017/
...
SQL Data Pivot: Restructuring Data with Pivot Tables
Master SQL Data Pivot for efficient data transformation in SQL Server! Learn techniques for handling various scenarios & optimize queries for speed. #SQLServer #DataPivot #SQLTechniques #DatabaseOptimization #DataAnalysis #DataTransformation
https://tech-champion.com/database/sql-server/sql-data-pivot-restructuring-data-with-pivot-tables/
...
SSAS Tabular DirectQuery: Troubleshooting Transition Issues
Boost your SSAS Tabular performance with DirectQuery! Learn how to migrate from in-memory processing, troubleshoot common issues, and optimize your data model for enhanced efficiency. #SSASDirectQuery #TabularModels #DataModeling #DAX #SQLServer #PerformanceOptimization
https://tech-champion.com/database/sql-server/ssas-tabular-directquery-troubleshooting-transition-issues/
...
SQL Non-Unique Identity Column: Auto-Assignment in Microsoft SQL Server
Learn how to implement SQL Non-Unique Identity columns in SQL Server using sequences and triggers. This ensures data integrity & efficient database operations. #SQLServer #DatabaseDesign #NonUniqueIdentity #SequencesAndTriggers #DataIntegrity #SQLTips
https://tech-champion.com/database/sql-server/sql-non-unique-identity-column-auto-assignment-in-microsoft-sql-server/
...
SQL Server User Summary: Efficiently Summarizing User Data
Master SQL Server User Summary: Learn efficient data aggregation, conditional reporting, & query optimization techniques for insightful data analysis. #SQLServer #DataAnalysis #SQLqueries #DataAggregation #ConditionalReporting #DatabaseOptimization
https://tech-champion.com/database/sql-server/sql-server-user-summary-efficiently-summarizing-user-data/
...
SQL Server Date Comparison: Ignoring Time in Date Columns
Master SQL Server Date Comparison techniques! Learn efficient methods to compare dates, ignoring time components for accurate results. Improve your data analysis skills now! #SQLServerDateComparison #SQLServer #DateComparison #DatabaseAdmin #DataAnalysis #SQL
https://tech-champion.com/database/sql-server/sql-server-date-comparison-ignoring-time-in-date-columns/
...
SQL JSON Conversion: Efficiently Converting SQL Query Results to JSON
Master SQL JSON conversion for efficient database development! Learn techniques for transforming SQL query results into JSON, improving code readability & security. #SQLJSONConversion #JSONData #DatabaseDevelopment #SQLServer #DataTransformation #Programming
https://tech-champion.com/database/sql-server/sql-json-conversion-efficiently-converting-sql-query-results-to-json/
...
