TEXT(F440,0) INT(F440) How To Vlookup Numbers Stored As Text In Excel?

https://www.extendoffice.com/documents/excel/3802-excel-vlookup-numbers-stored-as-text.html

How To Vlookup Numbers Stored As Text In Excel?

2. If your lookup value is number format, and the ID number in the original table is stored as text, the above formula will not work, you should apply this formula: =VLOOKUP(TEXT(G1,0),A2:D15,2,FALSE) to get the correct result as you need.

https://exceljet.net/formula/extract-date-from-a-date-and-time

Generic formula 

=INT(date)

How To Safely Delete SQL Server ErrorLog Files

How To Safely Delete SQL Server ErrorLog Files

By default SQL Server stores seven ErrorLog files named:

• ErrorLog
• ErrorLog.1
• ErrorLog.2
• ErrorLog.3
• ErrorLog.4
• ErrorLog.5
• ErrorLog.6

n SQL Server 2005 and later versions, the ErrorLog files are stored in the c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG folder.  The ErrorLog file contains the newest information; the ErrorLog.6 file contains the oldest information. 

If one of the ErrorLog files has grown to a large size, the ErrorLog files can be manually cycled by running the sp_cycle_errorlog Stored Procedure.  

Delete 

• ErrorLog manually

In SQL Server Management Studio, open the MANAGEMENT folder, then right click on SQL SERVER LOGS and say CONFIGURE.  Check the LIMIT ERROR LOGS box and set the number to 30 (a month's worth).  Now, set up a new job in the SQL Agent that runs sp_cycle_errorlog every night at midnight.

Found on Spiceworks: https://community.spiceworks.com/topic/564167-clearing-sql-server-errorlog-files?utm_source=copy_paste&utm_campaign=growth

cisco ap 1602 data rate to set 802.11g only

https://www.cisco.com/c/en/us/td/docs/wireless/access_point/12-4-25d-JA/Configuration/guide/cg_12_4_25d_JA/scg12-4-25d-JA-chap6-radio.pdf


Command Purpose Step 1 configure terminal Enter global configuration mode. Step 2 interface dot11radio {0 | 1} Enter interface configuration mode for the radio interface. The 2.4-GHz radio and 2.4-GHz N radio is radio 0, and the 5-GHz radio and 5-GHz N radios radio 1.


speed 802.11b, 2.4-GHz radio: {[1.0] [11.0] [2.0] [5.5] [basic-1.0] [basic-11.0] [basic-2.0] [basic-5.5] | range | throughput} 802.11g, 2.4-GHz radio: {[1.0] [2.0] [5.5] [6.0] [9.0] [11.0] [12.0] [18.0] [24.0] [36.0] [48.0] [54.0] [basic-1.0] [basic-2.0] [basic-5.5] [basic-6.0] [basic-9.0] [basic-11.0] [basic-12.0] [basic-18.0] [basic-24.0] [basic-36.0] [basic-48.0] [basic-54.0] | range | throughput [ofdm] | default } 802.11a 5-GHz radio: {[6.0] [9.0] [12.0] [18.0] [24.0] [36.0] [48.0] [54.0] [basic-6.0] [basic-9.0] [basic-12.0] [basic-18.0] [basic-24.0] [basic-36.0] [basic-48.0] [basic-54.0] | range | throughput | default}

cisco ap install guide celling mount

https://www.cisco.com/c/en/us/td/docs/wireless/controller/technotes/8-3/b_cisco_aironet_series_2800_3800_access_point_deployment_guide/b_cisco_aironet_series_2800_3800_access_point_deployment_guide_chapter_010.html

cisco 1242 dtim wmm

Choosing “Mixed 802.11g, 802.11b and 802.11n” and using WMM function are forbidden
for wireless mode.

When client devices receive a beacon that contains a DTIM, they normally wake up to check for pending packets. Longer intervals between DTIMs let clients sleep longer and preserve power. Conversely, shorter DTIM periods reduce the delay in receiving packets but use more battery power because clients wake up more often.

The default beacon rate is 2, which means that every other beacon contains a DTIM. Enter a beacon rate between 1 and 100.

https://www.cisco.com/c/en/us/td/docs/wireless/access_point/12-3_7_JA/configuration/guide/i1237sc/s37ssid.html

WMM is in QoS , 

QoS is disabled by default (however, the radio interface always honors tagged 802.1P packets even when you have not configured a QoS policy). This section describes how to configure QoS on your access point. It contains this configuration information:

https://www.cisco.com/c/en/us/td/docs/wireless/access_point/12-4_3g_JA/configuration/guide/ios1243gjaconfigguide/s43qos.html

Reporting Service for SQL 2008

Procedure for update Reporting Service for SQL 2008

1. copy live folder to another
2. RptPrj_NDSICU.sln
3. Open Solution Explorer if you cannot see
4. Open the form you need to change. example : SubRpt_partF.rdl
5. Save all
6. on Solution Explorer , right click on very top . RptPrj_NDSICU
7. Click Clean
8. Click Build
9. on Debug , click Start Debugging
10. will show the preview
11. Select Bed-09 , then on right side click "View Report"
12. if ok , on Solution Explorer , right click on very top . RptPrj_NDSICU. Click Deploy
13. when uploading finish . will show 1 success 0 fail

Tip: Configure a User Account to Log On Automatically on Windows 7

. Click Start, type netplwiz, and then press Enter.
2. In the User Accounts dialog box, click the account you want to automatically log on to.If it is available, clear the Users Must Enter A User Name And Password To Use This Computer check box.
3. Click OK. 
4. In the Automatically Log On dialog box, enter the user’s password twice and click OK. 

https://technet.microsoft.com/en-us/library/ee872306.aspx