Profile cover photo
Profile photo
Krishan Gurusinghe
4 followers
4 followers
About
Communities and Collections
Posts

Post has attachment

Post has attachment
Creating a Link Server to MYSQL from MSSQL
There might be situations where there might be a need to apply CRUD  operations ( Create,   Read,   Update,   Delete ) on data residing in a MYSQL server database from SQL server. In order to do this you will need to create a link service from SQL server to...
Add a comment...

Post has attachment
How to pass a data table into a stored procedure as a Table Value Parameter (TVP) in SQL server 2008 and above.
In some instances there might be a need to manipulate an
entire data set rather than passing individual values as variables into a
database. To do this I explain how to start by creating the proc with the
parameters then obtaining the inserted identity valu...
Add a comment...

Post has attachment
Growing Log file issues - How to shrink a SQL server Log and data file.
Sometimes
it is necessary to do this via a script as the UI does not work for reasons
such as the DB is being in used. This method sets the recover mode and
then shrinks the log and data file. Before
doing this backup your databases using Management studio ...
Add a comment...

Post has attachment
PhotoPhotoPhotoPhotoPhoto
NirringaDr
8 Photos - View album
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...

Post has attachment

Post has attachment
Wait while more posts are being loaded