by George Chrysovaladis Grammatikos | May 17, 2017 | IT, IT-Troubleshooting
DLLs once deployed in GAC (normally located at c:\windows\assembly) can’t be viewed or used as a normal DLL file. If we need to get the DLL file from the GAC you must follow the following steps. Run regsvr32 /u %windir%\Microsoft.NET\Framework\\shfusion.dll Open...
by George Chrysovaladis Grammatikos | May 17, 2017 | Az-Powershell, Azure
One important thing you must do for an SMTP Server is to add reverse DNS record on your Cloud Service. To do this, first of all, you must install Azure Powershell, WindowsAzurePowershell. Now, you must execute the following commands in PowerShell: Azure Service...
by George Chrysovaladis Grammatikos | May 17, 2017 | SQL Server, Troubleshooting
Heap table are the tables which they don’t have any clustered index. : — List all heap tables SELECT SCH.name + ‘.’ + TBL.name AS TableName FROM sys.tables AS TBL INNER JOIN sys.schemas AS SCH ON TBL.schema_id = SCH.schema_id INNER JOIN sys.indexes...
by George Chrysovaladis Grammatikos | May 17, 2017 | IT, IT-Troubleshooting
By using the following command you can check the remaining days of RDS. Open CMD, and run the following command : wmic /namespace:\\root\CIMV2\TerminalServices PATH Win32_TerminalServiceSetting WHERE (__CLASS !=””) CALL...
by George Chrysovaladis Grammatikos | May 17, 2017 | Installation / Configuration, SQL Server
By following the next steps you are able to create storage pools for a SQL Server installation. Storage Pool Best Practices Column Size = Number Of Disks In The Storage Pool, example 2 Disks = Column Size 2 Interleave = For OLTP Best is 256KB , For TSQL Best is 64K...
