2023-09-18
252 reads
2023-09-18
252 reads
In this article we walk through things you should know to create new tables in SQL Server using the SQL Server Management Studio interface.
2022-04-13
When you run a query, how does SQL Server estimate the number of rows? I’ll explain in this half-hour video demo using playing cards, then showing the same issues in SQL Server Management Studio.
2020-09-22
On September 24th Microsoft released the first Community Technical Preview for SQL Server 2019, which was CTP2.0. At the same time Microsoft pushed out a new preview for SQL Server Management Studio (SSMS) known as version 18. Now is the time to download this new preview!
2019-01-15
4,118 reads
In this tip Aaron Bertrand looks at how to generate scripts for triggers using simple T-SQL statements. This tip shows how to easily build scripts for disabling, enabling, dropping and creating.
2018-06-07
3,640 reads
Matteo Lorini shows how to setup a project in SSMS to organize files.
2017-09-27
4,539 reads
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
This is more complicated than using the Azure Migration method, but because it’s maxed...
I’ve covered how to create Elastic Jobs in the portal (this one is important...
Hi, I am using the SSMA for Oracle v10.0. I have installed the SSMA...
Hi, I an using VS 2022 to build a package that selects and then...
Accidental DBA here. After looking at all the work that needs to be done,...
Which of these is not a requirement for a database to be added to an Availability Group (AG)?
See possible answers