Menu

Month: July 2022

How to run .msi files as an administrator
07/26/2022
| No Comments
| Windows Tools

Starting in Windows Server 2012 the “Run as administrator” option no longer appears when right-clicking a .msi file. This may be a required step when installing certain applications onto your Windows Server. Below are some options to be able to run a .msi file as an administrator. As a single-use solution, you can run the .msi as an administrator from the Windows command prompt. Open elevated Command Prompt. To do so, type “CMD” in the Start menu or Start screen search box,…

Read More

MSSQL – Query to Find Column From All Tables of Database
07/14/2022
| No Comments
| Microsoft SQL

How many tables in the database AdventureWorks have column names like ‘EmployeeID’? It was quite an interesting question and I thought if there are scripts that can do this would be great. I quickly wrote down the following script which will go return all the tables containing specific columns along with their schema name.

Read More

Check If IEnumerable<> or List<> Type is Empty / Null
07/13/2022
| No Comments
| Visual Studio

There are three ways to check whether IEnumerable<> or List<> type is empty / null or not. == NULL .Any() .Count() In any case, you always want to combine “== null” and, either “.Any()” or “.Count()”, with OR (“||”) operator. In addition, you want to put “== null” before the other condition. The reason for this is, “if” condition goes from left to right. So, if the list object is null, it will not go to the second check,…

Read More

How to search in Outlook
07/13/2022
| No Comments
| Microsoft Outlook

Outlook provides you with a number of built-in search filters. To use the built-in filters, click in the Search box. Based on your preference, you can use Advanced Search by clicking the filter button on the right side of the search box. Alternatively, the Outlook ribbon will change to show the Search tab and you use any of the options in the Refine group to refine your search results. You can find the search box at the top of…

Read More

Visual C# Code Snippets
07/13/2022
| No Comments
| Visual Studio

By default the following code snippets are included in Visual Studio. Name (or shortcut) Description Valid locations to insert snippet #if Creates a #if directive and a #endif directive. Anywhere. #region Creates a #region directive and a #endregion directive. Anywhere. ~ Creates a destructor for the containing class. Inside a class. attribute Creates a declaration for a class that derives from Attribute. Inside a namespace (including the global namespace), a class, or a struct. checked Creates a checked block. Inside a method, an indexer, a property accessor, or an event…

Read More

SQL Time Zone Conversion Functions
07/13/2022
| No Comments
| Microsoft SQL

I did a lot of research on Microsoft’s website, and the only time zone conversion functions that I could find were relative to analysis services, and would not provide me with a solution to my problem. So, my options were to pay someone to modify our application, or create a process in the database environment to perform the conversions as data is inserted into the common database environment.

Read More

Netstat command
07/13/2022
| No Comments
| Cheat Sheet

netstat -ano … This command displays process IDs (PIDS) that are associated with active TCP or UDP network connections. netstat -abn … This command displays the process names associated with active TCP or UDP network connections. NOTE: The option ” > c:\PortsList.txt” after the above command will allow generating a text file. Help ?

Read More

Telnet [servername] [port]
07/13/2022
| No Comments
| General Information

This command will help you determine if there is a process listing in that server with a specific port. We used this command in DocuWare to help find a service such Authentication server is listing in that DocuWare server. It is typically done from a machine that you think you do not have a connection. telnet dwserver 9000

Read More

How can I speed up queries on a large table?
07/13/2022
| No Comments
| Microsoft SQL

Any process or action that requires querying the database and getting results can be optimized by adding database indexes. An index is used to speed up the performance of queries. It does this by reducing the number of database data pages that must be visited/scanned. In SQL Server, a clustered index determines the physical order of data in a table. There can be only one clustered index per table (the clustered index IS the table) What is an index?So,…

Read More

© 2019 www.myw0.com . All Rights Reserved
Design www.tenemaza.com