Install Ansible Here are all the steps needed to install Ansible and configure the system to run your ansible scripts or playbooks Validate Ansible Version Install Python Validate Python Version Enable WinRM for Windows Hosts Windows Host Configuration For Ansible to be able to connect to the Windows Host, host should be configured as well, […]
Read more >Technically, Ansible cannot run on a Windows. However, it may manage Windows hosts. As a workaround Ansible can be run under the Windows Subsystem for Linux (WSL). Let me elaborate three ways to make this happen (I will cover one for now, however, will leave the other 2 for future): Microsoft store’s Ubuntu App Linux Virtual Machine on Windows Host Cygwin 1st Approach: Microsoft store’s Ubuntu […]
Read more >The last two articles help you identify where the issue is? this one will take you through step by step process of what one may do to regain the space occupied by the databases. Hence freeing some resources on the SQL server and improving the performance too. Identify and clean Log/Temp Tables Truncate/Delete the log […]
Read more >In continuation with the previous article, this will help to identify which tables in your database are eating up space, maybe it’s just a log table or a temp table, that you may wipe off to save the space and optimize the performance of your DB. Here is how you would do this based on […]
Read more >This thread outlines how to display data and log space information for all the databases in SQL Server. This will give you an insight into which database needs to be maintained or dropped to save space on your server. Connect to the Database Engine. From the Standard bar, click New Query. Copy and paste the following example into the query window and click Execute. one may uncomment a […]
Read more >This is an obsolete, yet a powerful tool to test access to a given database server or to do some more complex stuff like building or populating a database. It’s a fast, easy way to access the database while working with SQL Server without needing SQL Server Management Studio to install. Note:OSQL was replaced with a […]
Read more >This may be useful if you have want to view or change the default location of the database files on an installed instance. View or change the default locations for database files In Object Explorer, right-click on your server and click Properties. In the left panel on that Properties page, click the Database settings tab. […]
Read more >If you are working with remote machines and/or UNC path you may experience following dialog every time you try to open an EXE or batch file from a shared location: Let see how to disable this Open run prompt Type inetcpl.cpl and press enter Click the Security tab Click Custom Level… Select Enable (not secure) under Launching applications and unsafe files. Click OK Then Yes […]
Read more >For testing the scenarios using Visual Studio 2015 and Visual Studio Team Services or Team Foundation Server (TFS) 2015, you won’t need a test controller because Agents for Microsoft Visual Studio 2015 handle orchestration by communicating with Team Services or TFS 2015. If one would install VS 2015 Agent when tried to invoke it through […]
Read more >Is the version of SQL Server with which the database is to be made compatible. The following compatibility level values can be configured (not all versions supports all of the above listed compatibility level): The compatibility level of a database dictates how certain language elements of the database functions when it relates to an earlier […]
Read more >