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 » SQLServerManagementStudio

Tag: SQLServerManagementStudio

T-SQL, yes please!

How to (easily) move data between SQL databases

Every now and then, you will run into a situation where you need to overwrite a database’s contents with those of another database. Maybe you’ll need to update a staging environment with a partial data import from production, or perhaps you have a new developer coming in who needs some…Continue reading How to (easily) move data between SQL databases

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

How to connect to your local MSSQL server using SSMS?

Every now and then you run into a situation, where you really need to run some SQL against your local development database. That database, at least in my case, is hosted on your local SQL Server Express. Connecting to a local SQL Server should be a walk in a park,…Continue reading How to connect to your local MSSQL server using SSMS?

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

  • Even Geralt can get sad using a mac

    Am I the problem? Even onboarding to the Apple ecosystem failed miserably.

     July 8, 2025
  • Run Kubernetes in production - it'll be easy, they said

    Any kubectl command throws “Unhandled Error” err=”couldn’t get current server API group list: Get \”http://localhost:8080/api?timeout=32s\”: dial tcp [::1]:8080: connect: connection refused” – what do?

     July 1, 2025
  • OneNote logo

    “Sync error. We are having trouble syncing. Click ‘Sign in again’ to fix the issue.” in OneNote? Let’s fix it!

     June 24, 2025
  • smug-geralt-of-apple

    How to set Outlook as Your default email client on a mac (because that’s definitely a totally sensible thing to do)

     June 17, 2025
  • msbuild - failed

    GitHub Actions build for Blazor Static (or rather StaticBlazor) never ending? Super-easy fix!

     June 10, 2025

Like these posts and tips? You can get them automatically right as I post them! Enter your email here or check out the RSS feed here: https://www.koskila.net/feed/
Loading

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!