Category: Performance
-
How to list SQL Jobs using Query?
-
How to use CLR function at SQL Server?
Creating a CLR function in SQL Server involves the following steps: 1. Define the function as a static method of a class in a language supported by the .NET Framework 2. Register the assembly in SQL Server by using the CREATE ASSEMBLY statement 3. Create the function that references the registered assembly by using the…
-
Cannot load Counter Name data because an invalid index ” was read from the registry
Cannot load Counter Name data because an invalid index ” was read from the registry When we are trying to read system performance counters, some time we will get this type of error on machines. “Cannot load Counter Name data because an invalid index ” was read from the registry” To fix the issue: Click…
-
SQL SERVER – Installation Failure Database engine services failed.
Sometimes when we install SQL Server or Add any new SQL Server Instance on Windows Machine, we can see the database errors listed below. To resolve these errors we are trying to repair existing installation or do something else. If nothing happens then we are trying to install it completely from control panel, but it…
-
Missing Windows Authentication Feature IIS and Windows 10
If you have windows 10 Home or SL version when might be you are unable to see Windows Authentication under IIS options when installing. To enable “Windows Authentication” either you need to upgrade the OS to Pro version or you can run this command to enable it. C:\WINDOWS\system32>dism /online /norestart /add-package:%SystemRoot%\servicing\Packages\Microsoft-Windows-IIS-WebServer-AddOn-2-Package~31bf3856ad364e35~amd64~~10.0.17134.1.mum The file name will…
-
Installation issue on ubuntu: Could not get lock /var/lib/dpkg/lock
Sometime when we install or update any package on the Ubuntu we can get error related to dpkg. So we need to delete lock file once from the below locations and restart the machine. sudo rm /var/lib/apt/lists/lock sudo rm /var/cache/apt/archives/lock sudo rm /var/lib/dpkg/lock
-
How to speed up database and table listing in Management Studio
In SQL Management Studio, select the “Databases” node in the Object Explorer. Then, click View –> Object Explorer Details. Right click on one of the column headers and uncheck all of the columns besides “Name”. These columns are slowing down the process of expanding the database list.
-
How to get list of all always encrypted columns in SQL Server
We do have “Always encrypted” feature in SQL 2016 and later versions, from this feature we can encrypt the column data instead of encrypting whole database. Sensitive data like credit card numbers, SSN. We need to prepare a list of encrypted columns at some where to track for future. Without tracking anywhere in the documents…
-
How to fix apache drill startup error on windows-10
Apache Drill can be downloaded from here. It will works fine on windows 7 but it is giving error when you install it as embedded mode on Windows-10. Error is something like that after running the command: sqlline.bat -u “jdbc:drill:zk=local” Error during udf area creation [/C:/Users/<user>/drill/udf/registry] on file system [file:///] (state=,code=0) After googling I found…
-
how to remove helper warnings at visual studio mvc view page
While working on MVC project we can get warnings in the MVC view/ partial view / layout page. The name ‘ViewBag’ does not exist in the current context ‘System.Web.WebPages.Html.HtmlHelper’ does not contain a definition for ‘ActionLink’ … ‘System.Web.WebPages.Html.HtmlHelper’ does not contain a definition for ‘AntiForgeryToken’ … These are due to wrong version in the config…