How to use SQL Server Data Tools in Visual Studio 2017

preview_player
Показать описание
Watch this session to learn how to use SQL Server Data Tools in Visual Studio 2017 to quickly develop a SQL Server database that runs anywhere and an Azure SQL database. Learn how to automate your application and database CI/CD pipeline by using Visual Studio Team Services.
#SQLServer#DataTools#VisualStudio2017#
Рекомендации по теме
Комментарии
Автор

This is awesome demonstration! You need to have some knowledge related to this topic to understand it, that's probably why some people complain. But non the less great job, helped me a lot.

Rajkorule
Автор

I'll use this as one of my foundation for creating databases. Thank you!

bachatero
Автор

I really liked the pace of the session along with the way it was explained for beginners... Thanks

sttpt
Автор

Will it be possible to push the changes to Azure sql database without Azure subscription?

ksvshankar
Автор

create procedure st_getShifts
as
select s.sh_id as 'ID',
s.sh_name as 'Name',
format(s.sh_fromTime, 'hh:mm tt') as'From',
format(s.sh_toTime, 'hh:mm tt') as'TO',
s.sh_number as 'Number'
from shifts s
when execute error show
Msg 195, Level 15, State 10, Procedure st_getShifts, Line 49
'format' is not a recognized built-in function name.
pls help me give solution pls

jontipass
Автор

"Can't connect to target server "master" ... " how do i create a target server then?

simmemamma
Автор

How to manage datasets not only database schema?

Kingside
Автор

What if data already exists in 'MyTable' and you rename to 'Employee' ??? The data is lost?

gagnonp
Автор

Can we open solution file in ssdt ?? If no then why?

shashankdhoke
Автор

Good video, but totally overkill with he ads

Urumitals
Автор

you've jumped straight into the sqldevops without explaining how. Poor tutorial

DrewPyke