InDatavailbyJP ChenUpgrading and Migrating End of Life SQL Server 2012 Databases on AWSSQL Server 2012 reached End of Support (EOS) on July 12, 2022, after being a mainstay for many organizations over the past decade.Feb 21, 2023
Naibedya KarSynchronizing two MS SQL tables using MERGE StatementMERGE statement was introduced in SQL 2008 which allows us to do INSERT, UPDATE and DELETE operations as a single SQL statement.Sep 13, 2017
Ganesh ChandrasekaranImplement SQL Server 2012 like permissions in SQL Server 2017In SQL Server 2012 or below, when you grant SELECT permissions for a table / view to a non-admin user they get to see only those table /…Jul 13, 2019Jul 13, 2019
suresh kumarWhat is Auto shrink in SQL SERVER or Is it safe to have SQL Server auto-shrink turned on?SQL Server is one of the easiest databases to maintain because of all of the automatic settings it has, but as I mentioned with Auto-Close…Nov 25, 2018Nov 25, 2018
InRiCosNotebyRiCo 技術農場[SQL Server] Setup Data Collection透過SSMS安裝和設定Data Collection一點都不難，基本上，SQL Agent service的account權限注意一下就好，Apr 20, 2018Apr 20, 2018
InDatavailbyJP ChenUpgrading and Migrating End of Life SQL Server 2012 Databases on AWSSQL Server 2012 reached End of Support (EOS) on July 12, 2022, after being a mainstay for many organizations over the past decade.Feb 21, 2023
Naibedya KarSynchronizing two MS SQL tables using MERGE StatementMERGE statement was introduced in SQL 2008 which allows us to do INSERT, UPDATE and DELETE operations as a single SQL statement.Sep 13, 2017
Ganesh ChandrasekaranImplement SQL Server 2012 like permissions in SQL Server 2017In SQL Server 2012 or below, when you grant SELECT permissions for a table / view to a non-admin user they get to see only those table /…Jul 13, 2019
suresh kumarWhat is Auto shrink in SQL SERVER or Is it safe to have SQL Server auto-shrink turned on?SQL Server is one of the easiest databases to maintain because of all of the automatic settings it has, but as I mentioned with Auto-Close…Nov 25, 2018
InRiCosNotebyRiCo 技術農場[SQL Server] Setup Data Collection透過SSMS安裝和設定Data Collection一點都不難，基本上，SQL Agent service的account權限注意一下就好，Apr 20, 2018
RedBush TechnologiesCursors in SQL ServerFirst thing first. Usage of Cursors is not encouraged in SQL Server as they are slow. You may go with WHILE loop if you need to iterate…Sep 8, 2017
InSQL Lessons with Bert WagnerbyBert WagnerHow To Roll-Back Data in a Temporal TableFor those times when you unintentionally change the data in a temporal table.May 30, 2017
InClarity ConsultingbyClarityAdminEasily Restore SQL Azure Database to Local SQL InstanceJun 15, 2012
![[SQL Server] Setup Data Collection](https://miro.medium.com/v2/resize:fill:160:106/format:webp/0*emPOr2F6MKydEvsR.png)
![[SQL Server] Setup Data Collection](https://miro.medium.com/v2/resize:fit:730/format:webp/0*emPOr2F6MKydEvsR.png)
