ALTER Database Archives - SQLServerGeeks

SQL Server / SQL Server Accidental DBA Series

How to change database compatibility level in SQL Server

December 15, 2014December 20, 2019 - by SQL Geek - Leave a Comment

Many a times one may need to change compatibility level of a database. In this blog we’ll see how to change database compatibility level or mode of a SQL Server database. …

SQL Server / SQL Server Accidental DBA Series

How to kill all sessions in SQL Server

September 21, 2014December 23, 2019 - by SQL Geek - Leave a Comment

In my previous two blogs, I talked about how kill a session in SQL Server and how to kill multiple sessions in SQL Server. In this blog I will talk about …