How to Download and Restore AdventureWorks 2019 Database
Learn how to download and restore AdventureWork 2019 Database.
2025-03-07
833 reads
ssms
How to Download and Restore AdventureWorks 2022 Database
Learn how to download and restore the AdventureWorks 2022 database in SQL Server with this step-by-step guide.
2025-02-28
1,264 reads
How to Attach and Detach Databases in SQL Server
Learn how to effectively attach and detach databases in SQL Server, exploring the differences between these methods and traditional backup and restore procedures. Streamline your database management tasks with clear, step-by-step instructions.
2024-12-30
1,710 reads
SQL Prompt Safety Net Features for SSMS: Tab Coloring
The Tab Coloring component of SQL Prompt’s SSMS Tab management could save you from accidentally doing something apocalyptic on a production server, ever again.
2023-04-21
SQL Prompt Safety Net Features for SSMS: SQL History
Mistakes occasionally happen. Occasionally, you make some ill-judged 'refinements' to working code and now just wish you could rewind your tab back in time an hour and forget the whole sorry episode. Now and again, SSMS just conspires against you and crashes unexpectedly, and you lose all your currently open query tabs, some of which you hadn't saved. SQL History offers a useful safety net in the event of any of these unfortunate events.
2023-04-17
How to Import and Export Connections from SQL Server Management Studio
In this article we look at how to import and export connection information for servers in SQL Server Management Studio for backup and to move to another installation of SSMS.
2022-07-04
Views in SQL Server 2019 with SSMS
This article explores how to create and use views in SQL Server 2019 using SSMS.
2021-12-27
6,817 reads
Searching for Objects in SQL Server Databases
How to get the most out of SQL Search, a free database search tool for SQL Server Management Studio (SSMS) and Visual Studio that will locate database objects based on their names, columns, or text.
2021-11-19
Azure Data Studio vs SSMS - Who is the winner?
Introduction I have to admit that I love SSMS. It is a great tool, and I felt furious when a colleague mentioned that Azure Data Studio will replace SSMS in the long run. In this new article, we will talk about the main differences between Azure Data Studio and SSMS. We will see if my […]
2021-11-10
25,642 reads
Issues with SQL Server Permissions to Restore a Database
In this article we look at solving SQL Server database restore issue when backup file does not show up in SSMS restore GUI as well as other permissions issues with backup and restore.
2021-08-23
Blogs
SQL Server Wait Stats
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
FabCon 2025 Recap
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Forums
why cant i get rid of extra dataset
hi i never used shared datasets before in ssrs. i created a dataset called...
Distinct values using string_agg
Hi Is it possible to get distinct values using string_agg Select T1."transType", WHEN T1."TransType"...
Refactoring a DELETE query using NOT EXISTS — need expert feedback
Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup...
Question of the Day
Importing Flat Files
What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?
See possible answers