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

  • How to install Home Assistant on Synology NAS (DSM 7.2)?

     August 29, 2023
  • Classic SharePoint 404 showing pagenotfound.aspx

    How to configure a custom 404 page for a SharePoint site?

     August 22, 2023
  • Azure DevOps build pipelines failing

    Azure DevOps pipelines suddenly failing with “##[error]#0 building with default instance using docker driver”

     August 15, 2023
  • I've got 99 problems but the lack of a gaming mouse ain't one

    How to fix Windows not recognizing your mouse clicks?

     August 8, 2023
  • I will fix your Outlook

    Outlook Search broken due to Windows Search acting up? Here’s 3 ways to fix it!

     August 1, 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!