Skip to content
  • GitHub
  • LinkedIn
  • Twitter
  • Instagram
  • SlideShare

#SharePointProblems

Solutions are worthless unless shared! Antti K. Koskela's Personal Professional Blog

  • Home
  • Posts
    • Configuration
    • DevTips
    • Tech Tips
    • Programming
    • Development environment
    • Troubleshooting
  • About (etc.)
    • Antti K. Koskela
    • Get in touch!
  • Archives
    • Browse my posts
  • Search

Democracy is under attack. Ukraine is the victim under fire right now, but imperialism won't stop there. I urge you to help - click this for details!

Home » SQLQuery

Tag: SQLQuery

T-SQL, yes please!

How to form a parameterized SQL query to find duplicates in a table.

So one day, I needed to quickly check if an identity field in a view in a Microsoft SQL Server was actually unique or not. I was running into weird issues with Entity Framework throwing an error somewhat like this: Store update, insert, or delete statement affected an unexpected number…Continue reading How to form a parameterized SQL query to find duplicates in a table.

T-SQL, yes please!

How to verify connection to the database in Entity Framework Core?

This article explains how to perform a very simple and lightweight database connection test for an existing database context. A while ago, I needed to develop a simple API that I can poll from a load balancer to see whether: This simple API would be used for monitoring purposes –…Continue reading How to verify connection to the database in Entity Framework Core?

Microsoft SQL Server logo

How to clean up duplicates from MS SQL Database?

This article explains how to query and remove duplicate entries from a Microsoft SQL database using T-SQL. The same model works both for Azure Databases (in Azure SQL Query Editor) and databases on MS SQL Server (using SSMS – SQL Server Management Studio). I had to do this a while…Continue reading How to clean up duplicates from MS SQL Database?

Microsoft SQL Server logo

Easily querying all the database and log file sizes on SQL Server

Quite often you get the need to simply quickly query all the database sizes on MS SQL Server. Most typically, for me, this need arises when a development machine gets low on disk space, and I need to check if some database’s log size has been growing, or if something…Continue reading Easily querying all the database and log file sizes on SQL Server

Author's photo: Antti K. Koskela

About the site and the author

Welcome! You just stumbled upon the home page of an all-around artisan code crafter and Microsoft MVP, Antti "koskila" Koskela.

Don't hesitate to leave comments. I read them all and try to reply as well!

More information about me in the About -section!

Recent articles

  • OpenSSL logo

    How to include the whole certificate chain in your .cer, .crt or .pem certificate file?

     May 2, 2023
  • Replace text containing double quotes in GitHub Actions

    How to avoid sed in GitHub Actions removing spaces from your script steps?

     April 25, 2023
  • Some men want to watch the build fail

    How to fix “MSB4044: The AndroidSignPackage task was not given a value for the required parameter KeyPass

     April 18, 2023
  • Windows failed successfully

    How to set Window size for your MAUI app in Windows?

     April 11, 2023
  • Entity Framework Core logo

    How to fix “System.InvalidOperationException: The property ‘ItemBody.AdditionalData’ could not be mapped because it is of type ‘IDictionary’, which is not a supported primitive type or a valid entity type. Either explicitly map this property, or ignore it using the ‘[NotMapped]’ attribute or by using ‘EntityTypeBuilder.Ignore’ in ‘OnModelCreating’.” in .NET 7 and Entity Framework?

     April 4, 2023
Microsoft MVP Program logo in dark grey and white
To the top of the page!
Koskila.net has been going strong since 2009 - way before I knew anything about .NET! :)

Want to see old versions of the site? Check them out on Archive.org!

x
x