This extension wraps insert and load_data commands with "set identity_insert tablename on/off" so that data can be inserted into auto increment columns when using MS SQL Server.

Security by default – protecting the enterprise in SQL Server 2025Issued by Ascent TechnologyJohannesburg, 25 Mar 2026 Security by default – protecting the enterprise in SQL Server 2025. Explore how ...

The error “Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause” appears when a query uses ...

Database administrator with 14+ years of hands-on experience in database management and database design. After spending 15 years as a SQL Server DBA, I've witnessed numerous technological evolutions, ...

Database administrator with 14+ years of hands-on experience in database management and database design. I still remember the morning our CTO walked into our weekly team meeting and dropped the bomb: ...

The primary key column is often set to auto-increment when constructing a SQL Server database. To achieve this, the IDENTITY property is enabled on the primary key column. The starting value and ...

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 ...