With the latest version of SSMS, SSMS 21, there is now integration with Copilot. In this blog post, we’ll go through the setup step by step, with screenshots, to get everything ready to use Copilot in SSMS.There is already some official documentation on this, but I believe many people will find it clearer to see everything illustrated. Copilot is not…
In this blog we will explain what to do to regain the access to your SQL Server instance. Here is our scenario : – You have by accident removed all logins in SQL Server instance – Your sa account by security and best practice is disabled – So no possibility to login with a sqlcmd or your SSMS (SQL Server…
As you know, since SQL Server 2016, SQL Server Management Studio is not anymore part of the SQL Server ISO files and needs to be downloaded independently. If you want to have a complete list of all SSMS versions please click here. Some days ago, I installed the new version of SQL Server 2022 ctp2.0 on two VMs to play…
By Franck Pachot . You can create a VM with SQL Server running in the Oracle Cloud. This is easy with a few clicks on the marketplace: Here are the steps I did above: Oracle Cloud -> Marketplace -> Application -> Category -> Database management You have multiple flavors. I’ve chosen the lastest cheaper “Microsoft SQL 2016 Standard with Windows…
SQL Server Management Studio is a well know integrated environment used to manage SQL Server infrastructure. This new version 17.4 can support SQL Server from 2008 up to 2017. It enhances existing features like Showplan, XE Profiler (complete list here) but also add an interesting one which is the Vulnerability Assessment. Vulnerability Assessment will scan a database in order to…
With the latest release of SQL Server Management Studio(SSMS) 2016 (13.0.15500.91), downloadable here, was introduced new CMDLETs for Always Encrypted, SQL Agent and the ErrorLog. In this article, I will present you the 2 new CMDLETs for the Error Logs: Get-SqlErrorLog: Retrieves the SQL Server Logs. Set-SqlErrorLog: Sets or resets the maximum number of error log files before recycling. My…
